Replicator

Replicator's functionality has now been merged
into Full Convert Pro.

All Replicator releases

  • v21.04.1642
    April 8, 2021
    • - Oracle - fixed an error while converting to an empty database in some server versions
    • - Conversion - fixed index and foreign key creation
    • - Replication Logs
    • - added Diff log
    • - fixed some Replication Summary log data (added, table count)
  • v21.03.1640
    March 30, 2021
    • - Fixed some custom mapping problems
  • v21.03.1639
    March 29, 2021
    • - Replication - handled Timestamp with timezone to DateTime replication
    • - Connection - fixed so that the Project option timeout will not affect the connection timeout
    • - Scheduler - now recognizes tasks of all application types as valid
    • - Firebird - fixed the C library error
    • - Oracle - fixed some queries for specific server versions
    • - Installer
    • - fixed application remaining in the programs list on uninstall
    • - fixed remaining empty folders on uninstall
    • - fixed missing files after application upgrade in specific cases
  • v21.03.1637
    March 18, 2021
    • - Comparison - fixed review to correctly show tables in case some of the tables had errors
    • - Replication - fixed review to correctly show tables in case some of the tables had errors
    • - Connnection - clarified that SSH connections using Public Key Authentication needs a private key file
    • - Connnection - Connections report more meaningful error messages
    • MySQL
    • - fixed crash when index has a functional key part
    • - fixed target varbinary data format
    • - fixed target datetime precision truncating datetime(6)
    • 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
    • - ODBC - fixed missing DSN error when Connection string selected
    • - Paradox - fixed no data shown Browse source/target
    • - Scheduler - fixed not deleting old task on save
    • - SIARD - fixed encoding of table and column comments
    • - SQL Server - fixed loading of hierarchyid target type from text source
    • - Sybase Advantage - fixed 32-bit application assembly version mismatch
  • v20.10.1630
    October 26, 2020
    • - Fixed reporting the count of copied rows when custom WHERE clause is applied
    • - Project - you can now view error details while the project is running
    • - CSV - fixed charset dropdown
    • - Access - fixed a size 0 problem when loading variable length data in some projects
    • - Access - fixed a precision and scale problem with decimal types ("type 14") in some projects
  • v20.10.1629
    October 6, 2020
    • - Trial - changed that it is always the Utimate version
    • - Project review - Fixed clearing of errors and warnings on deselected tables
    • - NexusDB - fixed index and foreign key table operation errors when more than 1 worker
  • v20.10.1628
    October 1, 2020
    • - Comparison - fix crash when special Unicode characters in data
    • - Log SqlStatements - fix crash when special Unicode characters in data
    • - Fix error on certain databases missing metadata
    • - SSH - added SSH server port input in connection info
    • - Ingres - support for writing long byte type
    • - PostgreSQL - Limit batch size when geometry type in target table
  • v20.09.1627
    September 22, 2020
    • - Restart IDENTITY problem is now reported as warning
    • - Additional where clause fixes
    • - Scheduler - fixed arguments not valid error with a missing space
    • - DB2 - split into LUW and zOS databases
    • - InterBase - fixed compatibility with older database versions
  • v20.09.1625
    September 15, 2020
    • - Project - Reworked progress UI for clearer info
    • - Project - on open let source and target connection errors pass so they can be corrected
    • - Project options - fixed source and target where clause not applying
    • - Settings - added debug log option
    • - Scheduler - automatically add -actcode to arguments if selected user is not the current user
    • - CockroachDB - added to the list of DBs
    • - DB2 - FOR BIT DATA columns are now automatically mapped as blob type
    • - Greenplum- added to the list of DBs
    • - MariaDB- added to the list of DBs
    • - OracleRDB - moved to PRO+
    • - PostgreSQL - added support for geography data type
    • - SIARD - fix memory issues
    • - 32bit - Fix assembly version errors
  • v20.08.1624
    August 27, 2020
    • - License - fixed problem with activation of features in some cases
    • - License - engine list in Project Wizard will update depending on the license without app restart
  • v20.08.1623
    August 26, 2020
    • PostgreSQL - fix target crash
  • v20.08.1622
    August 25, 2020
    • - Localization - added localizations
    • - Firebird/Interbase - fixed reading "blob subtype 1" as encoded text
    • - MySQL - fixed/removed datetime precision for versions lower than 5.6
  • v20.08.1621
    August 20, 2020
    • - Project - added "Show last project run review"
    • - Project - added "Browse source" functionality
    • - Project options - fixed Log Autofill and Clear discards pending changes
    • - Project options - added comparison temp data folder location option as a PRO+ feature
    • - Table mapping - added case insensitive search if no table with correct project casing found
    • - Summary log - fixed and added more details for replication projects
    • - Replication review - removed explore differences (visible on comparison review only)
    • - Console app - clear project temporary files after project run
    • - Console app - added "-lw" option for logging warnings
    • - Console app - log locations are now inherited from the project file and can be overridden with arguments
    • - Excel - fixed error getting columns when there are multiple sheets in a workbook
    • - Postgres - display table sizes in bytes
    • - Progress OpenEdge - added table and column name literals if needed
    • - MSSQL - fixed network and local instance enumeration
  • v20.08.1619
    August 12, 2020
    • - Using DELETE statements instead of TRUNCATE statements to avoid referential integrity rules blocking the deletes
  • v20.08.1618
    August 6, 2020
    • - Fixed H2 BLOB data
    • - Revamped activation when no Internet connection
    • - Optimized project overview screen for very small screens
  • v20.08.1617
    August 4, 2020
    • - Fixed data replication scheduled tasks
  • v20.07.1616
    July 31, 2020
    • - Table differences by default no longer display matching records
    • - Limited the maximum space database name will take in the UI to avoid table list being pushed to the side
  • v20.07.1615
    July 30, 2020
    • - Comparison for a table now doesn't stop on the first error
    • - Table mapping - fixed not being able to exit the screen when no columns are present
    • - Table mapping - fixed column automatically selects when manual mode
    • - Validate table mapping - fixed not remapping tables when source database is changed
    • - Validate table mapping - fixed errors not removing when not present
    • - UI bugs fixes and improvements
    • - Added additional datetime parsing formats
    • - MySQL - added precision to datetime columns where versions is 5.6+
    • - MySQL - fixed comparison error when datetime column is part of a key
    • - MySQL - raised metadata read timeout
  • v20.07.1614
    July 28, 2020
    • - Fix TableMapping selection
    • - Fix Drop tables on target that do not exist
    • - Expand project opening and compare error logging
    • - ODBC - if no clustered index found use first unique index as primary key
  • v20.07.1613
    July 27, 2020
    • - Added delete if truncate fails
    • - Fixed ordering of tables by FK dependencies
    • - DB2 - fixed reading of index and foreign key metadata
    • - H2 - added reading of index uniqueness
    • - MySQL - fixed CHAR(36) column data requiring to be a valid GUID
    • - SQLite - fixed time comparison
    • - SQLite - datetime conversion now includes milliseconds
    • - SQLite - varbinary to BLOB conversion is now inserted as binary data not as a hex string
  • v20.07.1611
    July 16, 2020
    • - Remove extraneous options from replication projects
    • - Oracle version 8 and lower improvements
    • - Fix SQLite metadata read error
  • v20.07.1610
    July 16, 2020
    • - Oracle version 8 and lower improvements
    • - Fix assembly mismatch error
  • v20.07.1609
    July 15, 2020
    • - Added Update functionality
    • - Internal SQLite tables are now filtered out automatically
    • - SqlBase - Added reading of FK delete actions
    • - Added "Sort keys in memory" comparison option
    • - Fixed Oracle Server v.8 or lower connection
    • - Fixed manual table mapping existing case sensitive target columns
    • - Fixed SqlLog double logging of constraints
    • - Fixed Replicator 32-bit exe
  • v20.07.1608
    July 7, 2020
    • - Added support for InterBase/Firebird table/column comments
    • - Fixed Firebird parallel metadata operations errors
    • - 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
  • Omega Sync 3.4 released
    November 14, 2012
    • Fixed foreign key (cascade/restrict/not null/set default/no action) rule propagation
  • Sync Database MySQL Edition 3.4 released
    November 6, 2008
    • Complete redesign of user interface
    • 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
    • Many smaller bugfixes
  • Sync Database MySQL Edition 2.1 released
    August 31, 2005
  • Sync Database MySQL Edition 2.0 released
    June 9, 2005
  • Sync Database 1.1 released
    January 4, 2004
  • Sync Database - initial release
    December 5, 2003