I have a vb application. Now I have developed that same vb application in Asp.net. In vb I had used MSAccess database. In asp.net I am using Sql server. Now I want to Move or copy the MSaccess database data into Sql server.
Sql-server – How to import mdb to sql server
asp.netms-accesssql servervb.net
Related Topic
- Sql-server – How to check if a column exists in a SQL Server table
- Sql – How to concatenate text from multiple rows into a single text string in SQL Server
- Sql – Insert results of a stored procedure into a temporary table
- Sql-server – Altering a column: null to not null
- Sql-server – the best way to auto-generate INSERT statements for a SQL Server table
- Sql – How to UPDATE from a SELECT in SQL Server
- Sql-server – Get size of all tables in database
- R – How far do you go with YAGNI?
Best Answer
Open your MS Access database, go to tools/database utilities/upsizing wizard. You're done.
Just follow the wizard's steps, make sure you have administrative rights on the SQL server, check all your steps with the integrated help for detailled table/indexes/rules upsizing.
Some database will not upsize easily, due to specific Access/Jet configuration that cannot be imported into SQL. This company has a small module to check this kind of issue and might also propose its own upsizing wizard here.