Americans spent $135.5 billion on back-to-school and back-to-college shopping in 2023, making the season a …
Maybe it is because your current database platform does not support the functionality you need for a big data project, or maybe you require features that are in a more recent database version. Whatever the reason, migrating a database is often a very valuable and necessary task that allows your business to both keep up with changing technology as well as lower the overall costs of running old systems.
However, if you maintain a very busy system with constant data movement, the thought of migrating to a new database version or a different database platform can seem especially daunting. With SymmetricDS, the process of migrating your busy system can be simplified as it allows you to move your data while still keeping it all in sync. This article will explain the basic steps of migrating your data while using SymmetricDS Pro. The steps for migration are as follows:
At this point, you have stopped SymmetricDS in your original server, disabled the channels, and cleared out the sym_data, sym_data_event, and sym_outgoing_batch tables. The reason that these steps are necessary is to guarantee that there will be no pending changes captured before the backup is created. This is important because it will guarantee that your backup does not include any pending data and will therefore safeguard your new database from duplicate data when it is finally synced with the original database.
At this point, you have your new database that you will eventually switch to from your old/original database. Your new database has all of the data from the original, minus the new changes that were captured at the point of starting up the Symmetric application. So, the next logical step from here is to sync up the old/original database to the new database.
At this point, you have what is called “parallel production” which means that two production servers are running at the same time and staying in sync with each other and the target nodes.
Over time you can migrate your target applications to point to the new database server and once all applications are redirected to point to the new database, then you can finally uninstall SymmetricDS and shutdown the old database.