MS ACCESS TO MSSQL CONVERTER
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.
MS Access to MSSQL Converter can perform the following conversion
- MS Access to MSSQL Database
- MS Access to MS SQL Server SQL Dump file
- MSSQL to MS Access
- MS Access to MS Access
- MSSQL to MS SQL Server Database
- MSSQL to MS SQL Server SQL Dump file
Synchronize Foxpro and MySQL databases
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
Supported Databases
- MySQL
- MySQL Dump
- Oracle
- Oracle SQL Dump
- MS Access
- PostgreSQL
- Foxpro/DBF Files
- CSV/Text or Fixed width
- MS SQL Server
- MS SQL Server Dump
- Maria DB
- Amazon RDS
- Amazon Aurora
- Google Cloud
- Azure Database for MySQL
Top Features
Constraints and Indexes
Imports all Constraints and Indexes and Auto Increment attributes.
In Built Scheduler
Automatically transfer data without any interaction.
Bulk Loading
Bulk Loading feature for Oracle, MySQL and MS SQL Server databases to load millions of rows at blazing speed.
Column Mapping
Load into new or existing tables with full Column Mapping.
SQL DUMP FILES
Generate SQL dump files from any database source
Synchronize
UPSERT and INSERT loading options to Synchronize Source and Target databases.
Select MS Access tables you want to convert, choose MSSQL target, Click Start to transfer data without any coding