Migrate Access 2007 DB to SQL?

Question

Hi, What is the best method to migrate a Access 2007 DB to SQL 

How do you know its all moved successfully?

and how do you launch it afterwards?

thanks

Answer 1

SQL?

SQL Server? MySQL?

If you mean SQL Server, then take a look at

• https://docs.microsoft.com/en-us/sql/ssma/access/sql-server-migration-assistant-for-access-accesstosql
• https://www.microsoft.com/en-us/download/details.aspx?id=54255

---

Daniel Pineault, 2010-2017 Microsoft MVP
Professional Support: http://www.cardaconsultants.com
MS Access Tips and Code Samples: http://www.devhut.net

Answer 2

SQL?

SQL Server? MySQL?

If you mean SQL Server, then take a look at

• 
  

---

Daniel Pineault, 2010-2017 Microsoft MVP
Professional Support: 

thanks, yes sql server standard 2012, but not azure 

Answer 3

Hi WillFulove,

did you visit the link provided by the Daniel  Pineault ?

if not I suggest you to visit the link and try to refer it.

if you think that it can solve your issue then I suggest you to mark the suggestion given by Daniel  Pineault as an answer.

if you still have any further questions then let us know about that.

we will try to provide you further suggestions to solve your issue.

Thanks for your understanding.

Regards

Deepak

---

MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact [e-mail].