convert an MSAccess DataBase to an SQL Server database

Question

I want to know if there is a way to convert an MSAccess DataBase to a SQL Server database without starting from the beginning.

You must always begin at the beginning.

Abe Miessler
– Abe Miessler

2010-08-12 14:50:46 +00:00
Commented Aug 12, 2010 at 14:50 — Abe Miessler
– Abe Miessler, Commented Aug 12, 2010 at 14:50

Codesleuth · Accepted Answer · 2010-08-12 11:40:28Z

5

There's a pretty verbose guide over at Microsoft that helps you get this process started. This is specifically for SQL Server 2008 though, using the SQL Server Migration Assistant (SSMA) which replaced the Upsizing Wizard: http://www.microsoft.com/sqlserver/2008/en/us/migration.aspx

Download: SQL Server Migration Assistant 2008 for Access V4.0
Note: "SSMA for Access supports Access 97 - Access 2007 databases."

edited Aug 12, 2010 at 11:40

answered Aug 12, 2010 at 11:35

Codesleuth

10.6k8 gold badges54 silver badges72 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

LeasMaps Over a year ago

Note that the first link now redirects to a sales page for SQL-Server 2016.

Collectives™ on Stack Overflow

convert an MSAccess DataBase to an SQL Server database

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related