a powerful synchronization tool designed for bi-directional conversion
BS Editor: 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.

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. you can free download DBSync for MS Access & MSSQL 3.3.3 now.