Oracle - fixed some database queries for older versions
PostgreSQL
- fixed a replication index and primary key problem
- fixed replication and comparison of TIMESTAMP and SQL Server DATETIME2 columns
Siard - fixed project wizard review workers bug
v21.03.1636
March 4, 2021
- Project wizard - optimized metadata read
- Open project - optimized metadata read
- Project options - optimized metadata read
- Connection - show all error messages when not able to connect
- Task scheduler - fixed a bug with the task selection
- Azure SQL - added include views as tables
- Derby - fixed reading of blob data types
- H2 - fixed a memory leak
- ODBC - fixed slow connecting to database
- MySQL - fixed column comments warning
- MySQL - fixed reading of primary key columns metadata
- MySQL - support for reading columns with GEOMETRY and GEOGRAPHY data types
- SIARD - fixed creating foreign keys
- SIARD - fixed row counts for tables
- SIARD - fixed nullability for columns
v21.01.1634
January 18, 2021
- Optimize on demand metadata get and project validation
v21.01.1633
January 13, 2021
- Project wizard - optimized workflow
- Project run - fixed disconnect error
- Project options - added table and column mapping (* is a wildcard, equals, starts*, *ends, *contains*, ordered by input (new line), first case insensitive match wins, eg, starts*=changedName)
- MS Access - fix when defaults leading with equality symbol "="
- Removed official support for FileMaker and QuickBooks
v20.12.1632
December 14, 2020
- Fix settings page not going back
v20.12.1631
December 9, 2020
- Comparison - optimized when only looking for inserts (and key is integral)
- Comparison - added Project option to ignore null characters (enabled by default)
- Comparison - fixed XML comparison (sometimes reported false difference)
- MySQL - fixed reading table comments when more than 10 tables are selected for conversion
- Fixed Firebird server connection (always used embedded server)
- Fixed Derby connections auto commit error
- Fixed datetime comparison - milliseconds were ignored
- Fixed added and deleted rows replication
v20.07.1607
July 1, 2020
- First Replicator release with the new, more powerful engine
- Redesigned user interface
v20.01.447
January 20, 2020
- Improved temporary file management
v20.01.446
January 16, 2020
- Improved handling of tables where columns have the same name in a different case
v20.01.445
January 10, 2020
- Added support for VistaDB 6
v20.01.444
January 8, 2020
- Fixed the Firebird driver registration
v19.12.443
December 27, 2019
- Updated handling of MySQL zero dates for the new database driver
v19.12.442
December 5, 2019
- Fixed reading of dBase IV memo files
- Fixed handling of MySQL zero dates
v19.11.442
November 2, 2019
- Updated MySQL driver
- Optimized reading of MySQL constraints
- Fixed mapping of ENUM and SET datatypes
v19.10.441
October 24, 2019
- Removed the DB2 driver which bombs in a 32-bit version
v19.10.440
October 22, 2019
- Fixed in-place changing of the Unicode data for SQL Server target
v19.10.439
October 7, 2019
- Added side panel hiding when the project is loaded to increase space to view tables
v19.10.438
October 7, 2019
- Changed the table list section - it now resizes with the screen
v19.05.436
May 28, 2019
- Removed check for key nullability when unnecessary
v19.05.435
May 24, 2019
- Updated visual components library
v19.05.434
May 22, 2019
- Fixed Oracle connection broken in the last build
v19.05.433
May 21, 2019
- Fixed error messages of the scheduled tasks
v19.05.432
May 21, 2019
- Fixed missing email reporting of mapping errors
v19.05.431
May 21, 2019
- Updated icons throughout the application
v19.05.430
May 16, 2019
- Updated MySQL driver in the console application
v19.05.429
May 14, 2019
- Updated MySQL database driver
- Updated SQL Server Compact database driver to v4.0 (old v3.5 databases can be upgraded in-place)
v19.04.428
April 16, 2019
- Added an option to treat empty text and NULL as the same thing - on by default when Oracle is used.
v19.03.427
March 1, 2019
- Re-added project information to the summary log
- Added missing datatype information to the table mapping screen when application is just open
v19.02.426
February 28, 2019
- Fixed working with Advantage in Direct mode
v19.02.425
February 28, 2019
- Adjusted overly enthusiastic searching for tables to map. We no longer go across schemas.
v19.02.424
February 28, 2019
- Adjusted hardware fingerprinting on non-English Windows versions to avoid occasional deactivation via scheduled tasks
v19.02.423
February 19, 2019
- Added reporting of crashes to the emails sent from the console
v19.02.422
February 19, 2019
- Added support for mixed Sybase Advantage databases (DBF/ADT)
v19.02.421
February 12, 2019
- Fixed the error handling certain Postgres domains
v19.02.420
February 8, 2019
- Added reporting of the table deselection due to the table structure change in the console (affecting scheduled tasks)
- Improved logging to include timestamps and duration of comparison and synchronization stages
v19.02.419
February 6, 2019
- Revamped Advantage connection screen and updated its database provider
- Fixed the statistics display for the total processed record count
- Fixed console error email notification
v19.02.418
February 5, 2019
- Added an option to skip equal data - handy for comparison of 10M+ record tables to save on drive space and time
- Cleaned up the project wizard UI
- Changed the order of change command execution to account for the case when unique values are replaced
- Fixed the console bug crashing due to certain project settings
v19.01.417
January 22, 2019
- Added primary key detection for Progress OpenEdge database
v19.01.416
January 11, 2019
- Fixed support for Firebird user roles
v18.12.415
December 12, 2018
- Fixed MySQL/MariaDB SSL connections
v18.12.414
December 6, 2018
- Add missing libraries for our latest databases
v18.12.413
December 5, 2018
- Changed application icon
- Updated UI components and database providers
- Optimized handling of interface element lists
v18.11.412
November 5, 2018
- Fixed handling of DOUBLE datatype when displaying differences
v18.10.411
October 19, 2018
- Added Teradata support
- Fixed reading meta-data for MySQL
v18.10.410
October 16, 2018
- Changed MySQL database provider to provide compatibility with all MySQL Servers versions (3.23 and later)
v18.10.409
October 5, 2018
- Fixed a rare case in which reading MySQL index columns crashes our software
v18.09.408
September 28, 2018
- Upgraded NexusDB database provider
v18.09.407
September 20, 2018
- Fixed issue with float replication when differences are after 3rd fractional digit
- Temporarily downgraded Postgres database provider as some users reported problems with the new one
v18.09.406
September 13, 2018
- Added TABLES parameter to console application
v18.09.405
September 6, 2018
- Upped .NET Framework requirement to version 4.6.1 or later (Microsoft's limitation due to the fact we are migrating most of our projects to be cross-platform for upcoming cloud solutions)
v18.09.404
September 6, 2018
- Updated supporting libraries
- Align SIARD 2.1 support to the specification for storing string data containing single or multiple consecutive space characters
v18.09.403
September 5, 2018
- Upgraded PostgreSQL database component
v18.09.402
September 5, 2018
- Added a missing DLL
v18.08.401
August 20, 2018
- Added support for Amazon RedShift
v18.08.400
August 16, 2018
- Fixed our build process that could have left some DLLs stale
v18.08.398
August 3, 2018
- Updated internal Microsoft .NET Framework assemblies
v18.07.397
July 18, 2018
- Added an option to ignore added records
v18.07.396
July 2, 2018
- Improved support for Ingres blank date configuration setting, again
v18.06.395
June 28, 2018
- Improved support for Ingres blank date configuration setting
v18.06.394
June 19, 2018
- Added support for Ingres blank date configuration setting
v18.06.393
June 19, 2018
- Fixed PostgreSQL bytea loading in single-record insert mode
v18.06.392
June 18, 2018
- Preserved table mapping customizations when changing project options while creating new project
- Added prompt for the user to save project file before creating schedule
- Rereading source database's metadata after editing source connection
v18.06.391
June 5, 2018
- Fixed Interbase connector having a missing DLL
v18.06.390
June 5, 2018
- Added support for Pervasive bit datatype
v18.03.390
March 28, 2018
- Fix Oracle BLOB reading memory leak
v18.03.389
March 20, 2018
- Added email "from" option
v18.03.388
March 6, 2018
- Improved certain error messages for unexpected errors in console application
v18.03.387
March 5, 2018
- Improved certain error messages for unexpected errors
v18.02.386
February 20, 2018
- Improved support for Oracle float with binary precision
v18.02.385
February 14, 2018
- Improved fallback to embedded Firebird server
v18.02.384
February 14, 2018
- Improved support for ODBC drivers using old ODBC specification
v18.02.383
February 9, 2018
- Fixed detection of system hard drive
v18.02.382
February 8, 2018
- Allow multiple emails to be specified for the console notifications
v18.02.381
February 8, 2018
- Made the email notification SMTP server authentication optional
v18.02.380
February 7, 2018
- Changed email sending component for improved reliability
v18.02.379
February 5, 2018
- Added console application email notifications to project options
v17.12.378
December 29, 2017
v17.12.374
December 29, 2017
Replicator 17.11 released
November 20, 2017
- Added embedded Firebird servers to be able to open all Firebird files even when user has no Firebird server installed.
v17.11.373
November 28, 2017
v17.11.372
November 22, 2017
v17.11.371
November 20, 2017
v17.11.370
November 20, 2017
v17.11.369
November 20, 2017
v17.11.368
November 13, 2017
v17.11.367
November 13, 2017
v17.11.366
November 13, 2017
v17.11.365
November 10, 2017
v17.11.364
November 10, 2017
v17.11.363
November 10, 2017
v17.11.362
November 10, 2017
Replicator 17.10 released
October 11, 2017
- New versioning scheme. Taken from Ubuntu Linux: Year.Month.Build. It makes much more sense with our continuous , almost daily, deployment of features.
- Oracle views can now be read as tables
- We can now read SQL script files and directly replicate the data from them to target databases. Table selection, column mapping etc. are fully supported.
v17.10.361
October 20, 2017
v17.10.360
October 18, 2017
v17.10.359
October 18, 2017
v17.10.358
October 17, 2017
v17.10.357
October 14, 2017
v17.10.356
October 12, 2017
v17.10.355
October 11, 2017
v17.10.354
October 10, 2017
v17.10.353
October 10, 2017
v17.10.352
October 9, 2017
v17.10.351
October 9, 2017
Replicator 4.5 released
July 31, 2017
- Rewritten and simplified schema mapping
- Added comparison difference specification export in JSON format
- Improved comparison of values of different types
v4.5.348
October 9, 2017
v4.5.346
September 28, 2017
v4.5.345
September 21, 2017
v4.5.344
September 5, 2017
v4.5.343
September 5, 2017
v4.5.342
September 5, 2017
v4.5.340
August 28, 2017
v4.5.338
August 28, 2017
v4.5.337
August 22, 2017
v4.5.336
August 18, 2017
v4.5.335
August 14, 2017
v4.5.334
August 11, 2017
v4.5.333
August 10, 2017
v4.5.332
August 1, 2017
v4.5.331
August 1, 2017
v4.5.330
July 31, 2017
v4.5.329
July 31, 2017
Replicator 4.4 released
July 21, 2017
- Intuit QuickBooks supported for reading via its QODBC driver
v4.4.328
July 31, 2017
v4.4.327
July 30, 2017
v4.4.326
July 30, 2017
v4.4.325
July 28, 2017
v4.4.324
July 27, 2017
v4.4.323
July 21, 2017
Replicator 4.3 released
July 14, 2017
- Added full support for Vertica as source and target database
- Added Sybase SQL Anywhere and Sybase IQ view reading as if they are tables
- Added Sybase ASE view reading as if they are tables
v4.3.322
July 19, 2017
v4.3.321
July 14, 2017
v4.3.320
July 14, 2017
v4.3.319
July 14, 2017
Replicator 4.2 released
April 4, 2017
- updated internal structures to improve performance
- automatically add new tables to project and remove deleted ones on project load
v4.2.317
July 14, 2017
v4.2.315
July 14, 2017
Replicator 4.1 released
December 1, 2016
- all known bugs fixed
v4.1.314
July 5, 2017
v4.1.312
June 23, 2017
v4.1.311
June 19, 2017
v4.1.310
June 12, 2017
v4.1.309
June 5, 2017
v4.1.308
June 5, 2017
v4.1.307
May 19, 2017
v4.1.306
May 9, 2017
v4.1.305
May 5, 2017
v4.1.304
May 2, 2017
v4.1.303
April 27, 2017
v4.1.302
April 27, 2017
v4.1.301
April 26, 2017
v4.1.300
April 25, 2017
v4.1.299
April 17, 2017
v4.1.298
April 8, 2017
v4.1.297
April 6, 2017
v4.1.296
April 6, 2017
v4.1.295
April 6, 2017
v4.1.294
April 4, 2017
v4.1.293
March 30, 2017
v4.1.292
March 29, 2017
v4.1.291
March 29, 2017
v4.1.290
March 24, 2017
v4.1.289
March 21, 2017
v4.1.289
March 21, 2017
v4.1.288
March 21, 2017
v4.1.287
March 20, 2017
v4.1.286
March 17, 2017
v4.1.285
March 16, 2017
v4.1.284
March 15, 2017
v4.1.283
March 15, 2017
v4.1.282
March 14, 2017
v4.1.281
March 10, 2017
v4.1.280
March 9, 2017
v4.1.279
March 8, 2017
v4.1.278
March 6, 2017
v4.1.277
March 2, 2017
v4.1.276
March 2, 2017
v4.1.275
February 14, 2017
v4.1.274
February 13, 2017
v4.1.272
February 9, 2017
v4.1.271
February 7, 2017
v4.1.270
February 7, 2017
v4.1.269
February 7, 2017
v4.1.264
January 13, 2017
v4.1.263
January 11, 2017
Replicator 4.0 released
January 22, 2016
Complete rewrite in a new technology. Omega Sync changes name to Replicator.
Added support for following databases:
- IBM DB2
- Derby
- H2
- HSQLDB
- NexusDB
- Pervasive PSQL
- Progress OpenEdge
- Sybase Adaptive Server Enterprise
- Sybase SQL Anywhere
- VistaDB
v4.0.232
September 23, 2016
v4.0.231
September 14, 2016
v4.0.230
September 9, 2016
Omega Sync 3.9 released
November 13, 2013
Added support for PostgreSQL
Omega Sync 3.8 released
April 25, 2013
Significantly improved database metadata analysis time
Added database identifying information during metadata analysis
Improved table mapping
Omega Sync 3.7 released
April 9, 2013
Fixed a bug where Oracle tables without tablespace were hidden
Fixed a bug reading Oracle metadata
Fixed a bug reading ODBC data chunks
Omega Sync 3.6 released
January 28, 2013
Improved user interface during sync to make it more obvious what is being synced
Omega Sync 3.5 released
January 10, 2013
Fixed a bug causing Unlimited version being able to select SQL Server only
Added quoting of field names when specifying field reordering
Fixed error parsing key names larger than 50 characters
Omega Sync 3.3 released
October 15, 2012
You can now ask Omega Sync to give you intended SQL synchronization statements without actually synchronizing databases by specifying -ls flag without -s flag in command-line mode
Sync Database MySQL Edition 3.3 released
February 28, 2008
Added automatic replacing of source database qualification into target database in the view definitions
Added recognition of USING HASH in indexes
Added support for foreign keys referencing columns in other databases
Fixed interpreting of NOT NULL values for MySQL4 databases
Fixed occasional incomplete metadata retrieval
Omega Sync 3.2 released
October 1, 2012
Bugfixes
Sync Database MySQL Edition 3.2 released
April 23, 2007
Fixed bug handling fulltext indexes
Fixed bug handling auto_increment columns
Fixed bug that dependant constraint was not dropped before dropping the key
Omega Sync 3.10 released
March 24, 2014
64-bit version
Implemented metadata caching. It enables you to skip reloading database metadata when loading data synchronization projects.
Omega Sync 3.1 released
August 30, 2012
Bugfixes
Sync Database MySQL Edition 3.1 released
March 12, 2007
Fixed default values where functions were used
Fixed bug clearing sync actions on save
Omega Sync 3.0 released
May 7, 2012
GUI overhaul, we now use wizard to create project
Rewritten Interbase code, now completely separate from Firebird code
Removed full synchronization mode, so we could make optimal user interface for each mode (schema/data)
Bugfixes
Sync Database MySQL Edition 3.0 released
January 30, 2007
Added support for stored procedures, functions and views
Improved and simplified user interface
Added built-in difference viewer
Added command-line support
300% increases database parsing and comparison speed
Omega Sync 2.9 released
August 14, 2010
Improved visual clue of databases used
Improved scheduler detection of lack of user permissions
Optimized disk handling for huge tables
Optimized disk handling for much faster work with details data grid
Fixed scheduled task execution when user is not logged on
Fixed check of custom comparison key uniqueness for multi-column keys
Many smaller bugfixes
Omega Sync 2.8 released
July 13, 2010
Added per-project selection of allowed data modification statements. This way you can have certain project only do SQL insert, for example.
Added per-project and per-table customer WHERE condition specification
Added timeout in seconds to options, so customers with huge databases can set the optimal value globally
Fixed data synchronization of SQL Server float values with differences at 16th decimal place
Fixed schema synchronization of MySQL float, double and enum table columns
Fixed parsing of MySQL default values
Omega Sync 2.7 released
June 29, 2010
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.
Many bugfixes
Omega Sync 2.6 released
June 17, 2010
Initial Omega Sync release!
Large rewrite of the application
Added support for schema synchronization
Improved GUI to further simplify comparison and synchronization
Improved performance
Sync Database MySQL Edition 2.5 released
June 16, 2006
Sync Database MySQL Edition 2.4 released
February 24, 2006
Sync Database MySQL Edition 2.3 released
December 22, 2005
Omega Sync 2.22 released
August 22, 2011
Added support for SQL Server user-defined table types
Added sync between GUID and Oracle RAW datatype
Added per column collate
Added protection from SQL injection in custom WHERE clause
Omega Sync 2.21 released
July 12, 2011
Fixed nasty bug in console application which caused all tables existing in work and not in reference to be dropped, regardless of project settings
Omega Sync 2.20 released
July 9, 2011
We will now show warning if sync script log file is not valid
Added support for date milliseconds for SQL Server
Fixed sorting problem when comparing SQL Server with other databases
Sync Database MySQL Edition 2.2 released
September 13, 2005
Omega Sync 2.19 released
June 26, 2011
User's part of WHERE clause is pushed to beginning of complete WHERE clause, so user can optimize it for optimal index utilization
Columns that have no default and that are not null can now be added to tables that contain data
Global where clause now gets saved even if compare is not performed
Fixed bug when reading schema from mysql server < 5.0.xx
Fixed bug when adding last mysql column in table
Omega Sync 2.18 released
June 10, 2011
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
Fixed MySQL default values in alter statements
Fixed enum field values
Alter script identifier delimiters are now always present
Fixed MySQL column reordering
Removed dropping default value on column before whole column is dropped
Omega Sync 2.17 released
May 19, 2011
Added full support for SQL Server HIERARCHYID data type
Added extra check that splash screen is closed before continuing on startup to fix rare problem with scheduling
Fixed display of manually mapped tables in database tree
Fixed handling of MySQL ENUM when table had more than one ENUM column
Fixed handling of Access metadata
Omega Sync 2.16 released
May 6, 2011
Added ability to synchronize GUID columns with string columns
Fixed display of manually mapped tables in database tree
Omega Sync 2.15 released
April 8, 2011
Added proper return codes to console application
Many bug fixes in console application
Omega Sync 2.14 released
March 9, 2011
Updated project file to support Unicode characters for table and column names
Omega Sync 2.13 released
February 19, 2011
Updated GUI to auto-adjust to system where large fonts are used
Added support for multi-action Firebird triggers (for example after update+ after insert)
Fixed stored procedures updating in Firebird
Fixed Firebird view creation when column names are not explicit
Timestamp columns in SQL Server databases are now correctly handled if their equivalent in work database is missing
Omega Sync 2.12 released
January 31, 2011
Command line data synchronization speed improved 5x
Improved GUI after schema synchronization
Optimized SQL Server table schema fetching so server won't timeout with thousands of tables in a database
Optimized temporary file handling so large table names can no more create problems with storage
Scheduler now checks in advance if current user has required privileges to create scheduled tasks
Fixed Oracle schema synchronization
Fixed Oracle data sync when user defined types are used
Fixed case when missing objects were not displayed in the list of objects to synchronize
Fixed Firebird quoting for tables which require it in data synchronization
Fixed Firebird stored procedure comparison
Fixed SQL script generated for MySQL trigger synchronization
Omega Sync 2.11 released
November 2, 2010
Fixed infamous Invalid column name 'NaN' error
Omega Sync 2.10 released
October 12, 2010
Improved console mode error reporting
Improved comparison and synchronization memory handling with huge tables and databases
Improved display of schema differences in the objects list
Improved mapping handling when underlying table schema has been modified since project was saved
Default Oracle connection mode is now via Oracle Client Interface. Direct TCP/IP connection is still available.
Fixed synchronization log save in console mode
Fixed column constraints schema synchronization
Fixed update of identity fields which are not part of primary key
Fixed differences review grid's Save to File feature
Fixed uniqueness checking of manually defined comparison key
Fixed table selection when some tables are missing from the work database