DBConvert/ DBSync for Access and Microsoft SQL Server are powerful cross

database migration tools for upsizing and synchronization of Access

x86/x64 data to MS SQL Server



Generally the number concurrent users for an Access database is limited

to maximum of 10-20 users. Access does not provide the level of security

and reliability that SQL Server does. Besides, Microsoft said, that the

MS Jet Database Engine that is used in MS Access, has entered a state of

functional deprecation. They recommend using MS SQL Server Express or MS

SQL Server Compact Editions instead for new database applications as a

backend



DBConvert for Access and MSSQL performs database conversion from Access

32/64 versions to Microsoft SQL Server/ Windows Azure SQL Databases and

inversely. Other migration combinations are supported as well. The tool

provides direct conversion but when you need to workaround firewalls MS

SQL Dump files may be generated



DBConvert software is able to convert MS Access queries to MS SQL Server

views automatically with no need to know about the differences between

SQL dialects



DBSync for Access and MSSQL is a powerful Sync tool designed for two-way

synchronization between Access and Microsoft SQL Server databases. Sync

of data from MS Access to SQL Azure and vice versa is possible as well

It is also appropriate for database replication between two MS SQL Server

databases. DBSync for Access and SQL helps to keep your Access, MS SQL

Azure SQL databases fresh and up-to-date satisfying all possible syncing

needs HOW TO INSTALL/RUN THIS RELEASE



o1 - Unpack the release into a directory of your choice

o2 - Run the installer and install it

o3 - Generate a key to unlock the software, but buy it if you will use it

o4 - As always, make sure to have a firewall to block outbound connections