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

DBConvert Studio

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.

Some reasons you might need to migrate data from SQL Server to MS Access.

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

Speed conversion with Bulk and Quantization features
Access queries to MS SQL, MySQL and PostgreSQL views conversion support
Views conversion from MS SQL to MySQL and Oracle and back support
MS SQL Server (Express) 2000/2005/2008/2008 R2/2012/2014/2016, SQL Azure support
Linked tables support
MS Access Work Groups support
MS SQL schemes support
Bi-directional synchronization between MS SQL, MySQL, Oracle and PostgreSQL
Amazon RDS SQL Server DB Instance support
Saving data into a MS SQL Dump for export to MS SQL database
Ability to select TCP/IP, PIPE, IPX/SPX communications protocols

Product Requirements

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

Screenshots

Workaround for firewalls and access rights
Views translation
Flexible customization for all db elements
Bulk Insert and Quantization options for speed-up processing of big volume of data
Conditional data migration. Data Filters.
Full UNICODE architecture support
Optimal data mapping
Autodetection of potential migration issues
Command line mode. Scheduling
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