• Home
• Products
• Omega Sync
• Version history

Version history

August 22, 2011
Omega Sync 2.22 released

1. Added support for SQL Server user-defined table types
2. Added sync between GUID and Oracle RAW datatype
3. Added per column collate
4. Added protection from SQL injection in custom WHERE clause

July 12, 2011
Omega Sync 2.21 released

1. Fixed nasty bug in console application which caused all tables existing in work and not in reference to be dropped, regardless of project settings

July 09, 2011
Omega Sync 2.20 released

1. We will now show warning if sync script log file is not valid
2. Added support for date milliseconds for SQL Server
3. Fixed sorting problem when comparing SQL Server with other databases

June 26, 2011
Omega Sync 2.19 released

1. User's part of WHERE clause is pushed to beginning of complete WHERE clause, so user can optimize it for optimal index utilization
2. Columns that have no default and that are not null can now be added to tables that contain data
3. Global where clause now gets saved even if compare is not performed
4. Fixed bug when reading schema from mysql server < 5.0.xx
5. Fixed bug when adding last mysql column in table

June 10, 2011
Omega Sync 2.18 released

1. Improved schema synchronization - when column with no default and NOT NULL property is being added for existing data, we will add temporary default value so column can be added
2. Fixed MySQL default values in alter statements
3. Fixed enum field values
4. Alter script identifier delimiters are now always present
5. Fixed MySQL column reordering
6. Removed dropping default value on column before whole column is dropped

May 19, 2011
Omega Sync 2.17 released

1. Added full support for SQL Server HIERARCHYID data type
2. Added extra check that splash screen is closed before continuing on startup to fix rare problem with scheduling
3. Fixed display of manually mapped tables in database tree
4. Fixed handling of MySQL ENUM when table had more than one ENUM column
5. Fixed handling of Access metadata

May 06, 2011
Omega Sync 2.16 released

1. Added ability to synchronize GUID columns with string columns
2. Fixed display of manually mapped tables in database tree

April 08, 2011
Omega Sync 2.15 released

1. Added proper return codes to console application
2. Many bug fixes in console application

March 09, 2011
Omega Sync 2.14 released

1. Updated project file to support Unicode characters for table and column names

February 19, 2011
Omega Sync 2.13 released

1. Updated GUI to auto-adjust to system where large fonts are used
2. Added support for multi-action Firebird triggers (for example after update+ after insert)
3. Fixed stored procedures updating in Firebird
4. Fixed Firebird view creation when column names are not explicit
5. Timestamp columns in SQL Server databases are now correctly handled if their equivalent in work database is missing

January 31, 2011
Omega Sync 2.12 released

1. Command line data synchronization speed improved 5x
2. Improved GUI after schema synchronization
3. Optimized SQL Server table schema fetching so server won't timeout with thousands of tables in a database
4. Optimized temporary file handling so large table names can no more create problems with storage
5. Scheduler now checks in advance if current user has required privileges to create scheduled tasks
6. Fixed Oracle schema synchronization
7. Fixed Oracle data sync when user defined types are used
8. Fixed case when missing objects were not displayed in the list of objects to synchronize
9. Fixed Firebird quoting for tables which require it in data synchronization
10. Fixed Firebird stored procedure comparison
11. Fixed SQL script generated for MySQL trigger synchronization

November 02, 2010
Omega Sync 2.11 released

1. Fixed infamous Invalid column name 'NaN' error

October 12, 2010
Omega Sync 2.10 released

1. Improved console mode error reporting
2. Improved comparison and synchronization memory handling with huge tables and databases
3. Improved display of schema differences in the objects list
4. Improved mapping handling when underlying table schema has been modified since project was saved
5. Default Oracle connection mode is now via Oracle Client Interface. Direct TCP/IP connection is still available.
6. Fixed synchronization log save in console mode
7. Fixed column constraints schema synchronization
8. Fixed update of identity fields which are not part of primary key
9. Fixed differences review grid's Save to File feature
10. Fixed uniqueness checking of manually defined comparison key
11. Fixed table selection when some tables are missing from the work database
12. Many smaller bugfixes

August 14, 2010
Omega Sync 2.9 released

1. Improved visual clue of databases used
2. Improved scheduler detection of lack of user permissions
3. Optimized disk handling for huge tables
4. Optimized disk handling for much faster work with details data grid
5. Fixed scheduled task execution when user is not logged on
6. Fixed check of custom comparison key uniqueness for multi-column keys
7. Many smaller bugfixes

July 13, 2010
Omega Sync 2.8 released

1. Added per-project selection of allowed data modification statements. This way you can have certain project only do SQL insert, for example.
2. Added per-project and per-table customer WHERE condition specification
3. Added timeout in seconds to options, so customers with huge databases can set the optimal value globally
4. Fixed data synchronization of SQL Server float values with differences at 16th decimal place
5. Fixed schema synchronization of MySQL float, double and enum table columns
6. Fixed parsing of MySQL default values

June 29, 2010
Omega Sync 2.7 released

1. Changed licensing to clear the confusion among users. Now all versions can sync schema and data, but only Pro version can sync databases of different kind.
2. Many bugfixes

June 17, 2010
Omega Sync 2.6 released

1. Initial Omega Sync release!
2. Large rewrite of the application
3. Added support for schema synchronization
4. Improved GUI to further simplify comparison and synchronization
5. Improved performance

March 16, 2010
Data Sync 2.5 released

1. Added a built-in scheduler

February 05, 2010
Data Sync 2.4 released

1. Improvements in handling huge tables

January 20, 2010
Data Sync 2.3 released

1. Massive speedup with opening and closing compare results grid
2. Improved Table Mappings and simplified creation of custom keys
3. Many bug fixes

November 18, 2009
Data Sync 2.2 released

1. Added a nice error dialog for connection errors which will enable less experienced users to get help when needed on our site
2. Improved connection error handling
3. Small bug fixes

September 02, 2009
Data Sync 2.1 released

1. Improved speed of comparison by 50%
2. Improved clarity of the synchronization process. You can now see exactly how many SQL commands will be issued for each database.
3. Lot of bug fixes through the application

July 13, 2009
Data Sync 2.0 released

1. Data Sync can compare and synchronize databases of unlimited size - the same technology used for our new Full Convert 5 was used to keep the high comparison speed
2. Expanded supported database list to: Access, SQL Server, MySQL, Interbase/Firebird, Oracle, PostgreSQL
3. Additionally, you can use any ODBC or OLEDB accesible database
4. You can even compare and synchronize databases of different kinds!
5. Incredible control - you can adjust not only where each record will go, you can even skip updating certain fields per each record, or move some fields in one direction, some in other
6. Load data from disk, or save cell values to compare them in your favorite diff tools
7. NULL values are displayed with a pattern background and easily distinguished from empty strings
8. You can choose to see only differences, or both equal records and differences

March 27, 2009
Data Sync 1.3 released

1. Added support for Interbase/Firebird database. You can now sync SQL Server, MySQL and Firebird databases, in any combination.
2. Improved display of table differences
3. Improved display of tables in Project Settings so you better understand which tables can't be synchronized and why
4. SQL Server timestamp datatype is now ignored and must have default value to be synced. If you have a matching column in other database you are comparing, both must have default values.
5. Simplified Project Settings wizard
6. Added ability to quickly change the sync direction for all rows in a table
7. Improved display of NULL values in the table details grid. NULL fields are now drawn with hatched background so you can easily know the difference between empty strings and NULL values.

February 18, 2009
Data Sync 1.2 released

1. Added support for MySQL database
2. Added support for cross-database comparison and sync! You can now sync SQL Server with a MySQL database.
3. Added support for MySQL database backup before sync
4. Massively improved speed of database metadata parsing and data comparison
5. Added command-line support and a special console build of DataSync
6. Added sync progress dialog
7. In case error occur during sync, you can view all the error after synchronization is completed
8. Many bugfixes

November 13, 2008
Data Sync 1.1 released

1. Added network selection protocol (Named Pipes, TCP/IP, Shared Memory)
2. Default project type changed from Comparison to Two-Way Sync

November 04, 2008
Data Sync 1.0 released

1. Initial release