I want to migrate the database from on-prem to cloud storage and then to cloud storage I do not want to use the database migration service. Here what is best option to migrate the database form Cloud storage to Cloud SQL. The database migration pattern from on-prem to cloud storage is already available. with me.
Hi,
You can refer to the following public documentation which describes the process for setting up replication when you have a dump file that you created from your external server (on-prem). Once replication is set up you can promote the replica to primary instance.
https://cloud.google.com/sql/docs/mysql/replication/configure-replication-from-external