Microsoft Access to Microsoft SQL Server Migration.

 DBConvert for Access & MSSQL

Version: 6.0.1

Release Date: Aug. 11, 2015

Conversion directions:

  • Access x86/x64 → MS SQL Server, MS SQL Dump
  • MS SQL Server → Access 32/64
  • Access queries → MS SQL Server views
  • Access 32/64 ↔ SQL Azure
  • Access x86/x64 ↔ Amazon RDS
 DBSync for Access & MSSQL

Version: 4.1.0

Release Date: April 14, 2015

Synchronization directions:

  • Access ↔ MS SQL Server
  • Access ↔ SQL Azure
  • MS SQL Server ↔ SQL Azure
  • Access ↔ Amazon RDS

DBConvert/ DBSync for Access and Microsoft SQL Server are powerful cross database migration tools for upsizing and synchronization of Access x86/x64 data to MS SQL Server.

Generally the number concurrent users for an Access database is limited to maximum of 10-20 users. Access does not provide the level of security and reliability that SQL Server does. Besides, Microsoft said, that the MS Jet Database Engine that is used in MS Access, has entered a state of functional deprecation. They recommend using MS SQL Server Express or MS SQL Server Compact Editions instead for new database applications as a backend.

DBConvert for Access and MSSQL performs database conversion from Access 32/64 versions to Microsoft SQL Server/ Windows Azure SQL Databases and inversely. Other migration combinations are supported as well. The tool provides direct conversion but when you need to workaround firewalls MS SQL Dump files may be generated.

DBConvert software is able to convert MS Access queries to MS SQL Server views automatically with no need to know about the differences between SQL dialects.

DBSync for Access and MSSQL is a powerful Sync tool designed for two-way synchronization between Access and Microsoft SQL Server databases. Sync of data from MS Access to SQL Azure and vice versa is possible as well. It is also appropriate for database replication between two MS SQL Server databases. DBSync for Access and SQL helps to keep your Access, MS SQL, Azure SQL databases fresh and up-to-date satisfying all possible syncing needs.

Read more information about Types of Synchronization.

In case you have restricted direct access to your MS SQL database, MS SQL Dump files may be generated.

Automate the process using built-in scheduler and command-line mode.

It takes about 6 minutes to convert 1 Million of records from MS Access x64 to MS SQL Server.

Product Highlights

Interface languages

English German French Spanish Italian Danish Chinese Russian Portuguese Polish Greek Bahasa

Product Requirements

  • Necessary privileges to write into database on the target MS SQL server (this requirement is optional as there is an option to overcome the restrictions using dump file)
  • Access 2000 or higher. Both Access 32/64 versions are supported
  • Microsoft Visual C++ 2008 x86 Redistributable package
  • MDAC 2.8

Latest News

  • SSL technique for encrypted data conversion support
  • Support for Access x64 databases has been added.
  • Added conversion/synchronization for SQL Azure.
  • Queries conversion improvements.
    Now Ms Access queries are converted more productively.
  • Large databases (about 500 thousand records) are converted approximately in 30-40 min.