Access to MS SQL Server database converter performs MS Access to MSSQL and MSSQL server to MS Access conversions. Features: Unicode Support, Primary keys and Indexes conversion, Interactive (GUI) mode / command line mode, Built-in scheduler, Renaming of tables, fields, indexes before conversion. There is an ability to save data to MSSQL Dump file that allows you to get over the restrictions on access to MS SQL database if any.
Publisher description
DBConvert for Access & MSSQL is a database migration tool for data conversion from MS Access database (MDB file) to MS SQL Server and from MSSQL to Microsoft Access. You can convert databases simply by configuring several options through Wizard interface or in command line mode. Ability to organize application work using command line parameters is supplemented with a scheduler so you can run the program without user input after scheduling. If a direct access to your MSSQL server is denied (insufficient privileges) you can save your data into a MSSQL Dump file to overcome such restrictions. The primary function of the MSSQL privilege system is to authenticate a user connecting from a given host, and to associate that user with privileges to select, insert, update, and delete a database. The SELECT, INSERT, UPDATE, and DELETE privileges allow you to perform operations on rows in existing tables in a database. The privilege system ensures that all users may perform only the operations allowed to them. Thus in case you have any privileges to create or modify a database on the target MSSQL database there is an opportunity to save your data into a dump file. DBConvert for Access & MSSQL fixes the contents of the source database into a local dump file the MSSQL server directly. The destination file will consist of MSSQL statements to create all the tables and to fill them with the data. Using this dump file MSSQL server administrator will add data to your SQL database. One of the key things of database managing is the ability to filter data during conversion. Integrated data filters allow users to retrieve only specific data for converted tables according to defined filtering criterias (conditions). Filters give you more control on data migration process.
Related Programs
MSSQL-to-Access 4.5
convert MS SQL data into MS Access format
Access-to-MSSQL 4.5
moves MS Access databases to MSSQL server
DBSync for MS Access & MSSQL 2.0.0
Access to MSSQL Sync database Synchronizer.
MS Access Move to Another Access Database Software 7.0
Transfer tables between Access databases.
DBConvert for SQLite and MSSQL 1.0.0
SQLite to MS SQL Database Converter
