FlySpeed DB Migrate to SQL Server

Frequently Asked Questions

This page contains answers to the most frequently asked Technical questions about FlySpeed DB Migrate to SQL Server. To find answers to your Pre-sales questions or to learn more about Maintenance program, please visit the Common F.A.Q. page.

Technical Questions

How can I connect to my source MySQL, Firebird or PostgreSQL database?

A: First, I recommend you to choose ODBC connection type on the second step of the Wizard to achieve maximum transfer speed, to extract full information about your database structure and to avoid various problems you may have while working through the OLE DB Provider for ODBC.

To get connected to your source database through ODBC, you should install an appropriate ODBC driver for your database. Below are the links where you can download latest versions of ODBC drivers for your database:

MySQL: http://dev.mysql.com/downloads/connector/odbc/
PostgreSQL: http://pgfoundry.org/projects/psqlodbc/
Firebird: http://www.firebirdsql.org/ or http://www.ibphoenix.com/

I have an Access database that has an OLE object field used to store JPEG pictures. I want to convert JPEG pictures into the SQL Server table as Binary Data. Is it possible to perform such conversion with the help of your tool?

A: Yes, our tool allows extraction of JPEG and BMP pictures from OLE object fields. You should set the "Extract pictures (BMP, JPG) from MS Access OLE Object fields" option on the Step 11 "Data Copy Options" of the Wizard to enable this feature.

I have about 50 tables in my source SQL Server database and I need to synchronize their data with the same SQL Server tables every week. Can I automate this process?

A: Yes, you can use the Data Import Projects for this purpose. Click the "Save Data Import Project" button on the Step 8 to save your current settings to a file. Next time, simply click the "Load Data Import Project" button on the Step 1 to restore your settings.

My source database contains data in UTF8 character set. I want to migrate to SQL Server and I need to save my string data correctly. How can I do it?

A: You should use type 'nchar' or 'nvarchar' for string fields in your SQL Server database and set the "Database character set" option for the source database to "UTF8" on the Step 11 of the Wizard.

Didn't find the answer to your question here? Submit a Request via our Support Center.