N/APosted 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?
Transfer MS Access Database to MS SQL Database
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. =)