MS SQL to MS Access Migration and Sync

The program to convert and synchronize Microsoft SQL database structure, tables, fields and indexes into Microsoft Access format.

A lot of options make the job fast and fully customized to get the perfect results of migration process.

Sql Server is definitely the superior database system. MS Access databases are not recommended as a data store for web applications.

Almost all migration jobs require moving up to MS SQL from MS Access. Below there are some considerations that should be taken into account when moving the other way.

Why you might want to migrate data from SQL Server to MS Access.

• If a project is relatively small, and you know the volume of managed data will not rise significantly.
• Or maybe you just don't want to spend the extra money for Sql Server hosting.
• Your boss or your client wants you to use Access in the next project and you have no choice.

Synchronization of data between MS SQL and MS Access is available as well.

Our solutions help you to make this kind of jobs smoothly and fast. There is no need to do anything manually. Just connect to source and destination databases, set up parameters and run migration job. That’s all. 

Run programs in easy-to-use wizard interface or through command line to automate scheduling job.

Read here trial versions limitations

Product highlights

• Views conversion from MS SQL to MySQL and Oracle and back support
• Bi-directional synchronization between MS SQL, MySQL, Oracle and PostgreSQL
• MS SQL Server Express 2005/2008/2008 R2/2012, MS SQL Server 2000/2005/2008/2008 R2/2012, SQL Azure support
• MS SQL schemes support
• Saving data into a MS SQL Dump for export to MS SQL database
• Ability to select TCP/IP, PIPE, IPX/SPX communications protocols
• Speed conversion with Bulk and Quantization features
• Access queries to MS SQL, MySQL and PostgreSQL views conversion support
• MS Access Work Groups support
• Linked tables support
• Also see common features for all DBConvert tools

Requirements

• MDAC 2.8
• 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
• Microsoft Visual C++ 2008 x86 Redistributable package