DBSync for Firebird and MSSQL

The latest version of DBSync for Firebird and MSSQL is a very professional, efficient and practical database synchronization software. DBSync for Firebird and MSSQL latest version has speed conversion with batch and quantization features and can save data to Firebird dump. DBSync for Firebird and MSSQL Chinese version can also save data to MS SQL dump for export to MS SQL database, with the ability to select TCP/IP, PIPE, IPX/SPX communication protocols.

DBSync for Firebird and MSSQL software introduction

Our DBConvert for Firebird and MS SQL converters will also import your InterBase/Firebird databases to Microsoft SQL Server/Windows Azure SQL database. SQL dump files may be generated to bypass firewalls, for example if direct conversion cannot be used because you do not have access to the server. Firebird and MS DBSync for SQL supports bidirectional synchronization from Firebird to MSSQL databases and precise synchronization in the opposite direction. Windows Azure SQL databases can also be configured as replication nodes. This tool allows you to copy legacy InterBase database formats to modern SQL Server and Firebird formats and vice versa. Insert, update and delete synchronization implemented in our DBSync software keeps your database up to date.

DBSync for Firebird and MSSQL software features

​​ 1. DBSync for Firebird and MSSQL can more easily convert data

​​ 2. You can copy all the contents of the entire database, and you can search for conversion resources by logging in to the database.

3. The software supports logging into Firebird, and you can manually add data converted to mssql

​ 4. It also supports data table conversion, converting independent data tables to mssql

5. Field conversion is also supported, and fields in the database can be output independently.

​​ 6. Support index content conversion, simple data conversion, and easily transfer data to msSQL for use

7. The software provides guidance steps, follow the steps to select the data table

8. The operation process is simple, and every user can convert Firebird database resources

9. You can also use this software to convert msSQL data to Firebird.

DBSync for Firebird and MSSQL software features

​​ 1. All Firebird/InterBase versions are supported

2. Bidirectional synchronization between MS SQL, MySQL, Oracle and PostgreSQL

3. Speed ​​conversion with batch and quantization functions

4. Save data to Firebird dump

5. View the conversion and fallback support from MS SQL to MySQL and Oracle

​ 6. Amazon RDS SQL Server database instance support

7. MS SQL solution support

​ 8. Save data to MS SQL dump for export to MS SQL database

9. Able to choose TCP/IP, PIPE, IPX/SPX communication protocols

10.MS SQL Server(Express)2000/2005/2008/2008 R2/2012/2014/2016,SQLAzure support

DBSync for Firebird and MSSQL installation steps

​ ​ 1. Download the latest version of DBSync for Firebird and MSSQL software package from Huajun Software Park

​ 2. Unzip the DBSync for Firebird and MSSQL software and run the "EXE. file"

​ 3. Double-click to open, enter the DBSync for Firebird and MSSQL software interface, and click Next

​​ 4. Read the installation license agreement, click I agree, and click Next

5. Select the installation location and click Next

​​ 6. The installer is ready to install, click Install

​​ 7. Click Finish, the DBSync for Firebird and MSSQL software is installed successfully

How to use DBSync for Firebird and MSSQL

​​ 1. Open the DBSync for Firebird and MSSQL software and click try to try it out.

​ ​ 2. You can view the introduction of the software here, click next to proceed to the next step.

3. Here is the database selection interface, where you can select Firebird data. Below is the server login setting interface

​​ 4. You can also add local Firebird data files, or enter the password to log in to the database

5. Since the editor has not logged in to the Firebird database, I cannot perform the next step. Friends who have the database can download and test it themselves.

​​ 6. Follow the steps on the left to set up the data conversion plan, and click next to immediately proceed to the next step.

DBSync for Firebird and MSSQL usage instructions

Database options

When you click on the database itself, Database Options will appear in the right panel.

There is an option to "overwrite existing database". This option if the database being copied already exists

Specifies whether it will be overwritten (which will result in the loss of all data within it).

There is an option for quantification. If checked, synchronization of large databases will be faster. This is achieved by dividing the entire record set into parts.

There is an option for "Create Log". If you check this option, you can track everything that happens to your data during synchronization.

If you select the "Capture changes between source and target" checkbox, the log will be represented as a dump file

                                        Store the generated query.

​​  Checking the “Store dump for target database backup” option will create a dump file containing the reverse query. Data will be taken

The value before conversion.

You can change the data types of all databases here.

Some special symbols need not be used because they are reserved symbols

​​For MS SQL/Firebird internal purposes. Here you can replace all garbage symbols in the database. Click

The name of the database in the left panel. Database options appear in the right panel and you enter any special options

Symbols such as "'":/*<>-+" in fields "garbage symbol replacement/removal".

After pressing the "Replace All" button, you will receive a message prompting you to choose the correct name. You can confirm the provided name by clicking the "OK" button. If you click "Apply All", all unwanted symbols will automatically be replaced with the symbols entered in the "Replace with" field. If you click Cancel, the name will remain unchanged.

Field selection

When you click Fields, all fields contained in the table will be displayed in the right panel.

​​​Click on a specific field to view specific information about that field.

                                                                                                                                                                In the “Source Field Information” group, you can see the field information from the source field: name and field type.

​ ​ In "New Field Information" you can configure how this field looks in the results library. For example, you can rename the field.

​ ​ You can also change the data type of each field in the target database here.

​​Select the field in which you want to set the data type. All information about this field will reappear in the "New Field Information" group.

Click the arrow in the New Type edit box. In the drop-down list that appears, select the desired new data type.

                                                                                                                                                                                                                          . If checked, only (relationship) types that are similar to the source type are displayed in the New Type edit box.

All changes to the data mapping will be stored automatically immediately after creation.

DBSync for Firebird and MSSQL update log

The developer of GG said that there are really no bugs this time~