XComparer - Firebird Database Synchronization

for Firebird RDBMS v2.5, V3.0

SUPPORTED FUNCTIONS

Save and load project options.

Table column rename.

Save difference SQL script in file.

Execute SQL script on old database.

Firebird 2.5, 3.0 compatible SQL script.

SUPPORTED FEATURES

OBJECT

CREATE

ALTER

DROP

SET

Handled data type





Blob, Char, Date, Decimal, Double precision, Float, Numeric, SmallInt, Time, TimeStamp, VarChar, BigInt, Array, Boolean





Domain

X

X

X


Exception

X

X

X


Table, 

Global Temporaly Table

X

X

X


Table column

X

X

X


Table calculated column

X

X

X


Table constrain

X


X


Table and column check

X


X


Table index

X


X


Table primary key

X


X


Table foreign key

X


X


Table unique

X


X


Table trigger

X

X

X


Table column not null



X


View

X

X

X


View column

X

X

X


View calculated column

X

X

X


View trigger

X

X

X


Procedure

X

X

X


Procedure in, out param

X

X

X


Procedure param default

X

X

X


Procedure declare

X

X

X


Procedure body

X

X

X


Procedure recursive

X

X

X


User Defined Function (UDF)

X

X

X


User Defined Filter

X


X


Database Trigger

X

X

X


Trigger declare

X

X

X


Trigger body

X

X

X


Role

X


X


User

X

X

X


Collation

X


X


Sequence

X


X

X

Firebird v3.0 support

Boolean data type

X

X

X


SQL Function

X

X

X


External procedure

X

X

X


External function

X

X

X


External trigger

X

X

X


DDL triggers

X

X

X


Identity table column

X

X

X


NULL/NOT NULL column


X



NULL/NOT NULL domain


X



Package header

X


X


Package body

X

X

X


UnSUPPORTED FEATURES

Objetc comments

Database create, alter and drop

Grant, Revoke

Quoted string object name

Table column drop not null on Firebird 2.5

System generated object names: RBD$xxx