General Discussion > Online Database synchronisation
Celona and GoldenGate both offer synchronisation, either forwards or reversed, these are high-end solutions though so I'm not sure if they will deliver what you need cost-wise.
A lot of the ETL vendors also offer CDC (Change Data Capture) so you could look at the major ETL and integration players but again the cost will be high.
If you are just performing a simple migration of data from a database to another with the same structures etc. in place then I'm sure there are lower cost solutions out there that could help, alternatively you could just place triggers and create an upsert process.
Does anyone else know of an online sync option for database level updates?
Dylan Jones (Founder)
What database you are migrating from? Look at Databasesync database replication software made by Wisdomforce. It can perform an incremental synchronization based on most recent transactions only.
Here is the link: http://www.wisdomforce.com/products-DatabaseSync.html
Hope it helps
Arnold
Arnold Fisher
Hello folks,
Please does any one know of any tool that enables online synchronisation of databases between source and target environments after database migration, at least during the transition period before moving all users/clients to the new environment. The intent is to ensure a consistent view of information irrespective of the environment where transactions occur.
Thanks for your help.