Full Convert fullconvert Tutorials

Convert Firebird to SQL Server database

Here is how Full Convert Enterprise converts Firebird to SQL Server (both databases are supported natively and you won't need to install any drivers.)

Please read on to learn how Full Convert can help you migrate Firebird to SQL Server database.

Target database is also known as MS SQL Server, MSSQL Server, Microsoft SQL Server, SQL, MSSQL (related files: mdf, ldf, bak)

Firebird

Firebird is an open source SQL relational database management system that runs on Linux, Windows, and a variety of Unix. The database forked from Borland's open source edition of InterBase in 2000, but since Firebird 1.5 the code has been largely rewritten.

Wikipedia

SQL Server

Microsoft SQL Server is a relational database management system developed by Microsoft.

Wikipedia

Download Trial Buy Now
30 Day Money-Back Guarantee!

First look at Full Convert

The conversion of Firebird to SQL Server using Full Convert is simple and has to do a few quick steps:

  • Connect to your source target databases
  • Optional: Choose which tables you want to convert (all are selected by default)
  • Start the conversion, sit back and enjoy
  • Optional: Explore your new data in the target database using a built-in database explorer

When we start Full Convert, you will notice a welcome panel with links for common tasks. Let's start a new conversion.

Click the Create new conversion link or click the New button in the ribbon above.

Connection to source Firebird database

Initial screen shows you that Full Convert will automatically detect your database if you don't know which one do you have. Of course, if you do know your database, do select it from the list on the left.

We will choose Firebird from the list of available database formats.

In the server field we need to type the name or IP address of the Firebird server. If you have Firebird installed on the local machine, where Full Convert is running, you can leave the server field blank. Username and password we don't need to touch in most cases as Full Convert pre-fills the "magic" values which opens all Firebird databases.

If Firebird is on this machine, we can now simply click ellipsis (...) button to select FDB database file. If the file is on remote machine, you need to type the path to the file as remote server sees it. So, if the file is in C:\t\ folder on your server, you need to write the full path, for example: C:\t\filename.FDB.

Connection to target SQL Server database

List on the left shows all the databases which can be filled with your source database data. Select the one you need and fill-in required parameters.

From the list of available target database engines, we'll choose SQL Server. Depending on the SQL Server installation, we need to specify the server name, or server\instance name in the Server field. Note: for SQL Server Express, instance is required, like this: servername\SQLEXPRESS

We have Windows authentication here, so all we need to do is select our desired database from the drop-down list.

Table selection

We will select all source tables for conversion by default. In case you only need some tables, simply deselect the ones you don't need - or deselect all, then select just the tables you do need.

Review

Here you can see how many tables will be converted. To start conversion right away, click on the Convert! button. To show contents of target database without converting, click on the Explore button. Use that to inspect target database prior to conversion, or to save the conversion project for later before even converting the first time.

Click the Convert! button to get started.

Conversion progress

Conversion is highly-optimized to run as fast as possible, yet provides top-notch reliability. Huge tables are converted in small chunks at a time, preserving memory and ensuring that your computer stays fast and responsive.

  • Running your custom pre-conversion SQL scripts, if any
  • Creating all selected tables in your target database
  • Copying data
  • Applying indexes
  • Applying foreign key constraints
  • Running your custom post-conversion SQL scripts, if any

Firebird to SQL Server conversion summary

Here you will see basic conversion statistics, such as number of tables and records copied to target database.


If there were any warnings or errors during conversion, you will be able to examine them in detail.

Finally, complete SQL log is available for you if you need it. This feature can be enabled in options dialog.

Conclusion

This small tutorial shows how easy it is to convert Firebird to SQL Server using Full Convert Enterprise.

If you like what you see, please purchase Full Convert at our site. Delivery is instant via email, and with 30 day money-back guarantee there is no risk in purchasing.

Also, if you want to make sure our applications fits your needs before buying, you can download free trial version.

Download Trial Buy Now
30 Day Money-Back Guarantee!