MS Access to MSSQL Converter is a tool to Convert, Migrate MS Access Databases to MS SQL Server Database or Convert MS SQL Server to MS Access Database.
It can convert multiple tables in either direction in one go. While converting you can map source table columns to matching destination table columns. Filter rows by specifying WHERE conditions.
Imports Tables Schemas, Constraints, Indexes and Default values.
Automatically chooses appropriate target datatypes and widths.
Supports all versions of Access and MS SQL Server. You can import from MDB of ACCDB files.
MS Access to MSSQL Converter comes with a built in scheduler so that you can run transfer jobs at specified intervals. Now no need to run jobs repeatedly, just create a session define the schedule date and time and MS Access to MSSQL Converter will automatically executes your session in the background and records the actions in a specified log file. You can later on check the log file for information.
Provides a command line interface also to run migration jobs manually so that it can be easily integrated with your own application. br>
Synchronizes FoxPro and MySQL databases by using UPSERT and INSERT loading options. UPSERT option Updates a row if a matching row exist in the MySQL target table. If the matching row does not exist it Inserts a new row in the MySQL table
Imports all Access Constraints and Indexes into MSSQL.
Convert data between Access and MSSQL or vice versa automatically at specified intervals
Uses Native MSSQL Bulk Load feature to load millions of rows at top speed without writing a single piece of code
Load data into new or existing tables with full Column Mapping support
Generate MSSQL SQL dump files from FoxPro in case there is no direct connection to MSSQL
UPSERT and INSERT loading options to Synchronize Access and MSSQL databases.
Try it Free
Download MS Access to MSSQL Converter