I want to migrate all data from an sql database (database 1) to another database (database 2, likely sql based). After migrating the data, I want to synchronize or set a schedule for data transfer to database 2 for new data coming into database 1.
I will be using google cloud platform for database 2. How should I go about this? Are there specific tools available?