Microsoft SQL Server to Microsoft Access Migration.

 DBConvert for Access & MSSQL

Version: 6.1.0

Release Date: Feb. 19, 2018

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
 Download 45.5 MB  Order from US$ 149
 DBSync for Access & MSSQL

Version: 4.1.2

Release Date: Feb. 19, 2018

Synchronization directions:

  • Access ↔ MS SQL Server
  • Access ↔ SQL Azure
  • MS SQL Server ↔ SQL Azure
  • Access ↔ Amazon RDS
 Download 44.2 MB  Order from US$ 149

The programs listed here support conversions and synchronizations of Microsoft SQL database structures, tables, fields and indexes to Microsoft Access 32/64 formats.

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

Both MS Access x86 and MS Access x64 versions are supported.

Microsoft SQL Server is definitely the superior database system.

And almost all migration jobs require moving up to MS SQL from MS Access. Below you can find some considerations that should be taken into account when moving the opposite way.

Synchronization of data between MS SQL/Windows Azure SQL databases and MS Access is available as well.

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

Run our programs using the easy-to-use wizard interface or through our powerful command line to automate scheduling jobs.

 MS SQL configuration for DBConvert  Windows Azure SQL database configuration for DBConvert  Amazon RDS configuration manual for DBConvert.

Microsoft Access to Microsoft SQL Server

Read information about reverse migration.
 DBConvert Key features.   Built-in Scheduler    Trigger-based Sync  Bulk Insert/ Quantization

Product Highlights

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)
  • Microsoft Visual C++ 2008 x86 Redistributable package
  • Access 2000 or higher. Both Access 32/64 versions are supported

Screenshots

  1. Workaround for firewalls and access rights
  2. Views translation
  3. Flexible customization for all db elements
  4. Bulk Insert and Quantization options for speed-up processing of big volume of data
  5. Conditional data migration. Data Filters.
  6. Full UNICODE architecture support
  7. Optimal data mapping
  8. Autodetection of potential migration issues
  9. Command line mode. Scheduling
  10. Savable sessions

Latest News

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