5

Is there an easy way to export a MS Access Database backend (Tables & relations) into an SQL Server database, so that it then can be used as a backend for a tailored application written in C# using Entity Framework?

The Access Database contains at least 50 tables and the export should not ruin its structure and relations.

0

4 Answers 4

8

Microsoft SQL Server Migration Assistant for Access

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

3 Comments

Many comments indicate the SSMA does a better job than the Upsizing Wizard in Access.
NOTE: you have to download a license key to use SSMA 2008. Here is the link to get the licensing key: microsoft.com/downloads/…
Note also that the SQL Server Upsizing Wizard was removed in Access 2013 so for Access versions after 2010 this is the only option.
1

As Gabriel indicates using the SSMA is the best solution for upsizing the tables, indexes and relationships in Access. Then I'd suggest working on the Access front end, containing the queries, forms, reports, macros and VBA code so it works with the SQL Server data storage. This won't take very long by comparision to rewriting the app.

Then you may find you don't need to rewrite the application in another environment. This assumes that the tables are properly normalized and clean. Even then it may be simpler to do some cleanup in that respect in Access.

Comments

1

The Microsoft SSMA link in the comment from 2010 only worked when I chose NOT to register. Also, here is an updated link to the MS SSMA executable.

Comments

0

There are Upsizing Wizard for Access to do the migration to MSSQL 2008. Goto [Database Tools] menu and click on [SQL Server] icon, then proceed the migration with the wizard.

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.