ms sqlms access

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
MS SQL MS Access

Converter from
MS SQL to MS Access

  • 8 Oct, 2013
  • Version 5.0.7
ORDER From $149 DOWNLOAD 45.51 Mb

Synchronizer between
MS SQL and MS Access

  • 8 Oct, 2013
  • Version 4.0.5
ORDER From $149 DOWNLOAD 44.17 Mb

Two-way database migration in one package. Pay once - get both! Find more information about the reverse migration

From MS Access to MS SQL

Converter+Syncronizer Bundle! Take 25% off regular price

New Features

  • 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.
  • SSL technique for encrypted data conversion support

Screenshots

MS SQL to MS Access: Benefits

  • 1 - Workaround for firewalls and access rights
  • 2 - Views conversion
  • 3 - Flexible customization for all db elements
  • 4 - Bulk and quantization for speed up of big volume of data processing
  • 5 - Conditional data migration
  • 6 - Full UNICODE architecture support
  • 7 - Optimal data mapping
  • 8 - Verification of potential migration issues
  • 9 - Command line mode & scheduling
  • 10 - Savable sessions