Hi Team,
I tired using the Database migration tool for migrating the database. But it does give the option to transfer the data all at once. The only option shown is continuously, may i know how to get the one-time option in the Database migration.
2 Likes
With many applications you may have active use of the source database, so by the time you complete the copy more transactions would have occurred. One option would be to stop your application, then copy the data, but the database migration service gives you more flexibility, instead the service transfers the current data and then additionally tracks ongoing transactions to ensure the destination always has the latest view, allowing you to keep the source application running while migration occurs. Take care to read the migration fideltity section for more details:
https://cloud.google.com/database-migration/docs/postgres/migration-fidelity
However once you are ready to switch over to the new destination, you can ‘promote’ the migration job, this will terminate any replication and disconnect the source. See:
https://cloud.google.com/database-migration/docs/postgres/promote-migration
Hope that helps,
Alex
1 Like