Seamless data migration from mssql to access.
Viobo mssql to access data migrator is the simplest data-migrator between mssql and access currently. It migrates data between mssql and access database system accurately and perfectly, with no database administrator experience required. The tool is compatible with most major versions of mssql and access, including sql server 2000 to sql server 2008, access 2000 to 2007, etc.
The tool needs odbc or oledb database provider without official client software. The data migrator supports the all kinds of connection type of mssql and access very well. It can excute sql script, stored procedure and function of your database system in conditions test simply; and help you administrate storage system.
Viobo mssql to access data migrator display databases as tree-structure. Users can drag and drop objects between two tree-form to operate data in multi-dababases from one to another. User can operate views, indexes, primary key, foreign keys in access without other client software, and can manage data structure in access simply.
The user-friendly interface helps user operate the data of databases easily and get its effect in real time. The user can also backup the data of access. Mdb file into data-files with the script (txt) format in user defined directory. Tasks-queue and multithread-management mechanism of the tool can enhance speed of migrating and keep integrality of the mass data.
In the tasks list, user can sort, delete, stop/start and clear all waiting tasks. Beginner of database can operate databases like operate files in resource explorer in microsoft windows. A database expert can define the sql script, stored procedure and function himself to complete the advanced migration operations.
Viobo mssql to access data migrator can also process multiple tasks at the same time; export data to several frequently-used file formats. The tool also helps user to define operation conditions to make the migrating tasks pertinent and make the result data optimal.