Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Other Forums
 MS Access
 convert ms access to sql server

Author  Topic 

Exir
Posting Yak Master

151 Posts

Posted - 2009-04-29 : 00:37:30
I have a database in ms access with lots of relations between tables and about some tousands records. i want to covert it to sql server. is it possible? how can i do it? and are the records transfer to sql or i should do data entry again?

Sequin
Starting Member

25 Posts

Posted - 2009-04-30 : 08:10:03
Use either the Access upsizing wizard (Tools/Database Utilities in Access 2003) or the SQL Server migration assistant

http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=d842f8b4-c914-4ac7-b2f3-d25fff4e24fb
Go to Top of Page
   

- Advertisement -