Online Documentation for DB Comparer for InterBase/Firebird

Version history

 

 

 

Version 5.0.2

• Comparison of renamed objected added to the console version.
• Filter for compared objects improved.
• Batch or PowerShell file type can be now selected on saving the template.
• The issues of scaling the application window resolved.
• SSH passphrase prompt was missed in some cases. Fixed now.

 

Version 5.0.1

• Support for Windows 11 ARM implemented.
• Fixes in generating script for table privileges.
• Privileges for exceptions and generators are compared now.
• Some improvements in dark schema interface.
• Fixes for report printing.
• "Load last password for new projects" option was not saved in some cases. Fixed now.
• Minor improvements and fixes.

 

Version 5.0

• Support for dark visual scheme added.

 

 

• Added support for SSL connections.
• Work with objects filter considerably improved.
• Support for Unicode database names added.
• Excluded objects are saved to the template correctly now.
• Support of Ed25519 keys implemented for SSH connection.
• Many other fixes and improvements.

 

Version 4.2.3

• SSH settings are now saved correctly to a template file.
• Reports button added to the toolbar.
• The "Always exclude the following options" setting was not saved correctly. Fixed now.
• The "Add comments to generated script" option is now applied from program settings.
• Other minor fixes and improvements.

 

Version 4.2.2

• Support of connection to Firebird 4.
• OUT parameters in procedures are displayed correcty now.
• Language folders were not set to default on settings reset. Fixed now.
• Error window in SQL script editor keeps custom size now.
• Object Definition windows can be hidden\opened from the main menu now.
• Other minor fixes and improvements.

 

Version 4.2.1

• The buttons for easy moving between differences in DDL have been added.
• Fix of synchronizing return values for UDFs.
• Editor font was not applied correctly. Fixed now.
• Comments are now compared and synchronized as Unicode strings.
• Language settings were not restored on settings reset. Fixed now.
• Minor improvements in program interface.
• Other minor fixes.

Version 4.2

• Support for new Firebird 3.0 objects has been added.
• 'Show objects list' option didn't work properly sometimes. Fixed now.
• Subobjects were not ignored on disabling the object in the database tree. Fixed now.
• Minor fixes in SQL Script Editor.
• Other minor improvements and bugfixes.

 

Version 4.1.1

• Identical grants were detected as different. Fixed now.
• Field order was erroneously detected as different in some cases. Fixed now.
• The long prefix for temporary table field names has been shortened to avoid error on script execution.
• Now the cursor is focused at the end of the line in SQL Editor.
• Other minor improvements and bug-fixes.

 

Version 4.1

• Dependencies processing mechanism enhanced.
• In some cases the connection using SSH-tunneling could not be established. Fixed now.
• The comments of objects were synchronized incorrectly. Fixed now.
• The comparison of views fields is now improved.
• Added the detection of renamed Constraints.
• Lots of other improvements and bug-fixes.

 

Version 4.0

• Significantly improved algorithm of object comparison and script generation.

• Now it is possible to search and analyze renamed objects. The application analyzes databases and creates a list of objects that might have been renamed.
• Added wizard for project work.
• Advanced list of compared object properties allows to make database analysis more complete.
• Significantly improved work with object dependencies.
• Added support of new features of Microsoft Windows 7, Microsoft Windows 8/8.1: progress indicator at task pane and project jump list.
• Data types processing improved.
• Correct checks comparison with names generated by a server.
• Objects comments comparison added.
• Procedures, views and triggers bodies comparison improved.
• Fields, domains and functions parameters comparison is improved considering field charset and default database charset.
• Expression indices comparison added.
• 'Autoincrement' field property comparison added.
• Cyclic objects dependencies processing added.
• Other improvements and bug-fixes.

 

Version 3.2

• Database comparison speed is considerably increased.
• Other minor improvements and bug-fixes.

 

Version 3.1

 

• When comparing a Firebird 2.0 database with the one on the Firebird 2.1, identical views used to be marked as different. Fixed now
• The modifying script used to be generated twice for domains with different size of type. Fixed now
• When comparing databases on Chinese Windows localization, the "Error: RichEdit line insertion error" message used to appear. Fixed now
• Other minor improvements and bug-fixes

 

Version 3.0

• Comparing and synchronization of databases or schemas on different servers as well as on a single server
• Comparing all database objects or selected ones only. Comparing by all or selected properties of objects only
• Visual representation of the differences between databases with details and modification scripts for the different objects
• Ability to synchronize databases manually step by step or automatically
• Ability to generate reports with database differences. Ability to add custom reports
• Ability to automate the database comparison and synchronization using the Console Application
• Working with several compare projects simultaneously
• Saving and loading projects with all their parameters
• A wide variety of options for comparison and synchronization
• Built-in SQL Script editor with syntax highlight
• New state-of-the-art graphical user interface
• Latest Interbase/Firebird version support

Scroll to top

Version 2.2

• Added the ability to filter analyzed objects using regular expressions. This allows one to analyze only required objects, and increases the speed of comparing and analyzing processes
• Added the opportunity to connect via SSH tunnel
• Visual representation of definition differences implemented
• The 'Hide identical objects' option added. This option allows one to hide identical objects in the DB Tree
• Large databases are now compared faster
• Ability to refresh different types of objects separately implemented. This may be helpful when you synchronize databases in the step-by-step style
• Toolbar with list of working windows is added to the main program window
• The 'Synchronize databases after comparing in console mode' option added. This project option allows you to run the console application in synchronization mode by default (without defining the /E option)
• The 'Fill Table View on load' option added. This option can be used to increase the speed of comparing process and decrease memory usage
• The ability to set the default directories for grid exports and reports storage added
• No more delays occur while navigating DB Tree with large databases
• Fixed the saving passwords error
• Procedures were not compared correctly in some cases. Fixed now
• Functions were not compared correctly in some cases. Fixed now
• Sometimes an error occurred while refreshing databases. Fixed now
• Altering procedures scripts were generated incorrectly. Fixed now
• Fixed the error with comparing views

and other minor improvements and small bug-fixes.

Scroll to top

Version 2.1

• Now the direction of synchronization can be saved in the project file (also can be used by the Console application)
• Now it is possible to specify the client library
• Export to Excel, Text, XML and HTML formats is now available from the Grid view
• New, more detailed console application log is implemented
• Now it is possible to select fields from the list when creating user reports
• Hints for the objects in tree are now displayed correctly
• When creating a new report, its pages used to be missing. Fixed now
• When changing Compare Options for a project, the Access Violation error emerged. Fixed now

Scroll to top

Version 2.0

• Completely re-designed top-of-the-art user interface
• Ample opportunities for customizing your working environment
• New way of browsing differences between compared databases
• Easy viewing of all different properties of database objects
• Ability to print a pre-defined differences report or create a new one
• New advanced comparison options
• Improved sync script generation
• Multilanguage support
• A lot of other improvements and bug fixes

and more...

Scroll to top

Version 1.3

• Fixed a bug concerned with incomplete maximization of the main program window
• Some minor visual improvements and bug-fixes.

Scroll to top

Version 1.2

• Implemented the console version of the database comparison utility: now you can schedule your database structure synchronization routine using the database utility
• Now DB Comparer does not try to create a primary key if the table already has one. The utility drops the existing primary key and creates another one
• Using this version you can compare and synchronize primary keys regardless of key names.
• Now you can use the tool to compare names of fields and field order in views. Check the 'Names of Fields' and the 'Order of Fields' options within the Compare Options section of the Environment Options dialog
• Support of Firebird 1.5
• Now you can view project properties without actually loading the project file - just open it while holding down the Shift key
• We have implemented synchronous scrolling in the Master Definition and Target Definition windows
• Now project files are associated with particular database comparison utilities
• Some small improvements and bug fixes

Scroll to top

Version 1.1

• Significantly increased the comparison speed for the databases with large amount of objects
• Now the fields order is considered on comparing tables. You can enable or disable this feature by using the 'Field order' option available within the Compare Options tab of the 'Project Options' dialog
• Now you can view the project options just before the project loading. Check the 'Show Project Options before Loading' option available within the Project Options section of the Environment Options dialog to enable this feature
• Added two new options to the Project Options section of the Environment Options dialog - 'Enable Forward Navigation' and 'Enable Backward Navigation'. Using these options you can customize the navigation behavior. If the forward navigation is enabled, you can navigate between the generated SQL scripts by selecting the proper objects from object trees, and vice versa (if the backward navigation is enabled)
• Now you can copy the Object definition to the clipboard
• Some small improvements and bug-fixes

Scroll to top

Version 1.0

Basic features:

• Comparing databases on one server as well as on different servers
• Synchronous navigation between database objects with displaying the corresponding scripts for modifying databases
• Possibility of execution modification statements one by one or all together
• Possibility of editing modification statements and changing their order
• Built-in SQL Script Editor with syntax highlight
• An ability to work with several compare projects at once, as well as save and load projects with all their parameters
• Customizable and easy-to-use MDI Interface
• A wide variety of options for customization
• Keyboard templates for faster editing SQL scripts

and more...

Scroll to top

 

---