MS ACCESS database to SQL SERVER 2008

Question

How to to transfer a MS ACCESS database to SQL SERVER 2008. I am using 2008 management studio.

Gohil Jayendrasinh · Answer

if you want to Migrate your MS Access Database to SQL Server the best option is to use Microsoft SQL Server Migration Assistant (SSMA) http://www.microsoft.com/sqlserver/en/us/product-info/migration-tool.aspx#Access http://www.microsoft.com/download/en/details.aspx?id=959

Senthilkumar · Answer

Hi The sql server 2008 has the import and export data wizard and you can migrate easily. http://www.packtpub.com/article/transferring-data-ms-access-2003-to-sql-server-2008