Access2MSSQL Pro description
A reliable bi-directional database migration tool.
DBConvert for Access & MSSQL is a reliable bi-directional database migration tool which allows you to convert from MS Access to MS SQL, MS Access to MS Access, MS Access to MS SQL Dump, MS SQL to MS Access, MS SQL to MS SQL
MS SQL to MS SQL Dump.
This software will help you convert databases from MS Access to MS SQL or from MS SQL to MS Access rapidly and reliably!
Operate with a whole database or select only needed tables, fields, indexes and foreign keys to proceed! Reach the desired result by simple configuring of several options through Wizard interface or in command line mode!
DBConvert for Access & MSSQL is also applicable for MS SQL database migration to another MS SQL database or to another MS SQL Server. Moreover, DBConvert for Access & MSSQL is quite well for copying MS Access database to another MS Access database.
Workaround problems with firewalls and access rights
Use our workarounds as MS SQL Dumps if you don�t have a direct access to MS SQL Server! Dump file can be used if you have no direct access to server, but can execute SQL-scripts, for example through Query Analyzer
or other tools.
Customize your data conversion process and database copying totally
Copy your database as is or with modified structure! All customizations are organized on the WYSIWYG principal. All objects (tables, fields, indexes, foreign keys) can be tuned up, i.e. renamed or excluded.
Full UNICODE architecture support
DBConvert for Access & MSSQL is based on full Unicode architecture with multibyte character sets support. It is compatible with a lot of character sets (including Unicode utf-8) and associated standards.
Savable sessions
Save your sessions and use them again if you do not want to loose time for configuring source, destination database and other customizations for conversion process.
Command line mode
Run DBConvert for Access & MSSQL as a part of your automate solution to activate it from a command line with saved session name as a parameter.
Effective scheduler
Automate running of your DBConvert for Access & MSSQL by using Data Conversions Scheduler! Convenient scheduler is available for all data converters, so you can run the program without user input after having scheduled it once.
Here are some key features of "Access2MSSQL Pro":
· Microsoft SQL Server Express and Microsoft SQL Server 2000/2005 support
· Interactive (GUI) mode / command line mode;
· Saving data into a MS SQL Dump for export to MS SQL database;
· Support for MS Access Work Groups;
· Automation of the conversion process with task scheduler;
· Primary keys and Indexes support ;
· Foreign keys (relations) support;
Advanced customization options:
· partial selection for database objects to be converted;
· database objects (tables, fields, indexes, foreign keys) renaming before conversion;
· detection of possible conversion errors on customization stage.
· Sessions support - all your settings can be saved and restored later;
· `GUID` Access database type support;
· `OLE Object` packages support;
· Skins support.
Limitations:
· 10 runs of the application
· 10 initial records for each database table