Free download Viobo Access to MSSQL Data Migrator Bus.

Viobo Access to MSSQL Data Migrator Bus.

1.0
Database schema/DDL, server-side logic(triggers etc) and Data transfer/migration
Free Download
User rating
0
0 votes
License
Shareware
OS
Windows
Developer
Version
1.0
File size
5.5 MB
Language
English
Release date
23 March 2011

Editor's review

This software tool can help with the migration of data from an Access database to the MS SQL Server.

Viobo Access to MSSQL Data Migrator is a data-migration tool between Access and MSSQL. The data migration will be accurate and you would not need a database administrator to get the job done. This software will work with most major versions of MSSQL and Access. That includes the SQL Server 2000 to SQL Server 2008 and Access 2000 to 2007, etc. All the connection types for the two databases are supported. The databases in Access and MSSQL are displayed as tree structured directories. You can simply drag and drop items between the two trees and a transfer will be done. This is true in multiple database situations too. There is no need to have the corresponding client software. Views, Indexes, Primary Key, Foreign Keys in Access can be operated without this client Software, and you can manage data structure in Access very simply.

This is a tool that can be handled by beginners, the new recruit to the IT depart, as well as experienced database administrators. While the beginner can take advantage of the Windows explorer like tree structure display of the database, and drag and drop the database files, an experienced administrator will be able to execute SQL script, run stored procedures and functions to harvest data from one system to the other. Tasks-queue and multi-thread management mechanism available in the tool can speed up migration, data integrity is not affected in the process. The task list can be sorted and otherwise modified. You start the process by first testing the connection to the data bases. The interface lets you get things easily done.

Publisher's description

Viobo Access to MSSQL Data Migrator is the simplest data-migrator between Access and MSSQL currently. It migrates data from Access to MSSQL 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 connection types 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 databases. Viobo Access to MSSQL 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 TEXT 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 Access to MSSQL Data Migrator can also process multiple tasks at the same time; export data to several frequently-used file formats, including Text-file, etc. The tool also helps user to define operation conditions to make the migrating tasks pertinent and make the result data optimal.
Viobo Access to MSSQL Data Migrator Bus.
Viobo Access to MSSQL Data Migrator Bus.
Version 1.0
Free Download

User comments

Rate this program