Migrating My Access DB into Sql Server
-
Hi, We are migrating from MS Access to SqlServer 2005. Could anyone please let me know how to copy tables and other objects (Stored procedures, triggers) from our current Access Database to SqlServer 2005. Thanks & Regards Puneet
-
Hi, We are migrating from MS Access to SqlServer 2005. Could anyone please let me know how to copy tables and other objects (Stored procedures, triggers) from our current Access Database to SqlServer 2005. Thanks & Regards Puneet
This is how it is being done in sql server 2000.first from enterprise manager right click on the database. 2)choose new database and create a new database with the name of your sql server database. 3)Right click on the new database created and from tasks choose import data. 4)A dialog box will appear.you have to specify the datasource there,which is microsoft access in your case.Then just follow the instructions and you will get your database migrated.