FlySpeed DB Migrate to SQL Server is a powerful software that allows rapid migration of MS SQL database structure and data to any other database server, with support for ADO and ODBC. It enables transferring data to an existing structure and provides unmatched control over migration.
The software provides a seamless connection with the source database via ADO and ODBC – this is a unique feature that is not available in many other products. These features allow administrators to extract all the information about the structure of the source database. Furthermore, FlySpeed DB Migrate to SQL Server has a unique feature that enables direct connection to the source MS Access database, which makes the migration process faster. In this process, all images stored in BLOB-fields as OLE objects are extracted and transferred to MS SQL Server correctly.
Another advantage of FlySpeed DB Migrate to SQL Server is its ability to transfer data even in the absence of a target server connection. This feature generates an SQL script that can be run later. Migrating database structure is a complex process, and many experienced administrators choose to do it manually because the tools for automatic migration fail to offer them the required level of control and transparency.
With FlySpeed DB Migrate, the administrator has full control over the generation of an SQL script that creates the database structure on the target server. The software provides visual tools to customize the structure of the objects according to the user's requirements. In case of errors, the administrator can easily correct expressions that caused the error and continue running the script from where it stopped.
Overall, FlySpeed DB Migrate to SQL Server is a highly reliable and efficient software that can transfer database structures, data, and images across servers or within the same server with ease. It offers unique features such as ADO and ODBC support, direct connection to MS Access databases, synchronization, and script generation. These features make it an indispensable tool for database administrators.
Version 2.4:
- Ability to create portable installations is made.
- Task Scheduler: Ability to run the task once at scheduled time is added.
- Ability to create scheduled task on saving a project is made.
- Now it is possible to provide username and password for ODBC connections.
- Other minor improvements.
Version 2.0:
- Command line tool to automate data export process is made.
- FlySpeed Task Scheduler is added to automate export jobs.
- FlySpeed DB Migrate COM Server allows to run command-line tool programmatically.
- MS SQL Server 2008 is supported now.
- Other minor bug fixes and improvements.
Version 1.6:
- Ability to define additional SQL scripts to be executed on the Source and Target databases, Before the import process starts and After the import process has finished.
- Minor visual interface improvements were made.
- Several minor bugs were fixed.
Version 1.5:
- Ability to log the whole migration process is implemented;
- The new Global Options form is made;
- Indexes with identical names are processed correctly now.
- Other bugfixes and improvements