MS Access to SQL Server

[FAQ]  [Tutorial]  [Release Notes]  [Download]  [Buy]
Latest version 5.3 released 06/11/2018

Access-to-MSSQL is a program to migrate Microsoft Access databases to Microsoft SQL server. The program has high performance due to direct connection to source and destination databases (it does not use ODBC or any other middleware software). Command line support allows to script, automate and schedule the conversion process.

Features
  • All versions of Microsoft Access are supported
  • All versions of SQL Server are supported (including Azure SQL)
  • Converts indexes with all necessary attributes
  • Relationships between tables are converted
  • Option to convert MS Access database to T-SQL script file
  • Password protected MS Access databases are converted
  • MS Access databases protected with user-level security are supported
  • Option to merge MS Access data into an existing MS SQL database
  • Option to filter data using SELECT-queries
  • Option to convert individual tables
  • Stores conversion settings into profile
  • Command line support
  • Easy-to-use wizard-style interface
  • Full install/uninstall support
  • The product can be customized according to customer requirements
  • Unlimited 24/7 support service
  • 1-year subscription for updates

Limitations

  • MS Access forms, VB code, queries, reports are not supported
  • Access to MS SQL migration tool does not convert system (hidden) tables
  • Demo version of the program converts only 50 records per table, does not convert queries/views and relationships between tables
    
1. Start the Conversion 2. Connect to Microsoft SQL Server
4. Select Source and Destination Databases 5. Select Tables to Convert
Video Demonstration

Requirements

Export into T-SQL script file

It is not always possible to have direct access to Microsoft SQL server. For this cases MS Access to MS SQL converter allows users to do indirect conversion and get more control over the process. Following this way, the program exports MS Access data into a local T-SQL script file instead of moving it to MS SQL server directly. This file contains SQL statements to create all tables and to fill them with the data. Click here to learn how to import T-SQL script file into MS SQL server.

Try before you buy

Still not sure the program fits your needs? Try free demo version with limited features. It will allow you to convert only 50 records for each database table and does NOT convert queries/views and relationships between tables. Test the quality of the demo and come back to place an order if satisfied with the results.

Download trial version of Access-to-MSSQL

Ordering

Intelligent Converters software is distributed through downloading from our server only. For online credit card purchasing select the desired software package in the table below and click the corresponding "BUY NOW" link. To learn about alternative payment options please visit Payment Options page. Access to SQL Server converter is covered by 30 day money-back guarantee

 

Access to MS SQL (single user license)
Click here for more information about licensing
$49 BUY NOW
Two Products Bundle
order Access to MS SQL + MS SQL to Access, save $24.5
$73.5 BUY NOW
MSSQL Migration Toolkit
software pack to convert any data source to MS SQL
and vice versa
$99 BUY NOW