Transfer MS Access Database to MS SQL Database

Asked By beverlynavarro 0 points N/A Posted on - 06/04/2012

 

Is there an automatic conversion of MS access database into MS SQL database?

 If there is, will it also automatically copied the relationship between the tables, the primary Keys?

Will the records be transferred automatically upon conversion?

• Status: Open
• Question Views: 813
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS SQL Server

Answered By Edwin Malig 0 points N/A #97626

Transfer MS Access Database to MS SQL Database

Hi Friend,

Upon reviewing your question, I believe you need a bi-directional database migration tool that allows you to convert MS Access to MS SQL and MS SQL to MS Access. I highly recommend that you need to download "DB convert for Access and MS SQL". And also, you can customize your data conversion process and database copying totally even all objects can be copied such as tables, fields, Primary and foreign keys and it can be tuned up.

The advantages of this software are it works for you firewall and access rights, it can detect possible conversion errors before your conversion started. Also, it is safe in terms of Binary data conversion and it is supported all binary data types including BLOB's, OLE object packages, and BYTEA.

Hope this might help. Have a great day. =) 

About Edwin Malig

Questions
0

Answers
26

Best Answers
9

• Vote Up 0 Vote Down

• Posted on - 06/05/2012
• Question Category: MS SQL Server