DBSync for MS Access & MSSQL 2.0.2

A reliable bi-directional database migration tool which allows you to synchronize and convert databases. DBSync for MS Access & MSSQL a reliable bi-directional database migration tool which allows you to synchronize and convert from: MS Access to MS SQL, MS Access to MS Access, MS SQL to MS Access, MS SQL to MS SQL.
Synchronize and 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 simply configuring of several options through Wizard interface or in command line mode! DBSync for MS Access & MSSQL is also applicable for MS SQL database synchronization and migration to another MS SQL database or even to another MS SQL Server.
Moreover, DBSync for MS Access & MSSQL is quite well for copying and synchronizing MS Access database with another MS Access database.
High speed data conversion and performance
Try it now and make sure that it’s true! DBSync for MS Access & MSSQL establishes a direct connection to source and destination databases. Thanks to improved quality of synchronization, data is transferred much faster and more accurate in comparison with lots of universal synchronizers which use ODBC or ADO. It is developed exactly for solving your problem with minimum effort and time!
Safe data conversion and database integrity
Don’t care about safety of your data. Our converter will do it for you! DBSync for MS Access & MSSQL supports all MS SQL Server and MS Access data types (including `BLOBS` and `OLE Object` packages). Primary keys, indexes and foreign keys (relations in MS Access) are supported in the best way.
Update, Insert and Drop synchronization
Keep all your databases up-to-date. Insert synchronization is meant for new records adding from a source to a destination database. Update synchronization is meant for replacing of the altered records in destination database. Drop-synchronization allows users to delete records from destination database if these records were removed in source. Together they allow keeping distributed databases in agreement.
Database objects (tables, fields, indexes and foreign keys) remapping for synchronization
Synchronize databases with different structures easily! All database objects (fields, indexes and foreign keys) can be remapped on the customization stage.
Customize your data synchronization process and database copying totally
Synchronize databases with identical or even with different structures! All customizations are organized on the WYSIWYG principal. All objects (tables, fields, indexes, foreign keys) can be tuned up, i.e. renamed, remapped or excluded.
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 DBSync for MS 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 DBSync for MS 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.
Main features:
- Microsoft SQL Server Express and Microsoft SQL Server 2000/2005 support
- Primary keys and Indexes support.
- Foreign key (relations) support.
- Insert-synchronization and Update-synchronization available.
- Advanced customization options:
- - partial selection for database objects to be converted;
- - database objects (tables, fields, indexes) renaming before conversion;
- - detection of possible conversion errors at customization stage
- Sessions support - all your settings can be saved and restored then.
- `GUID` Access database type support.
- `OLE Object` packages support.
- Unicode (utf-8/ utf-16) for MS SQL Server support, all possible encoding support.
- On MS Access connection page "Database" field now "readonly" to prevent wrong DB name entering.
- Interactive (GUI) mode / command line mode.
- Support for MS Access Work Groups.
- Automation of the conversion process with task scheduler.
- Skins support.
Version restrictions:
- Due to trial version limitation, the Licensee is able to run the Software 10 times with full functionality then only 10 records from each table will be proceeded.