Nonstop Migrate multiple SqlAzure Databases PaaS [dbo] to Single PaaS Multi Schema.

Question

First, have a nice day/morning/evening.

I have a big problem. Could someone please help me out?

• I have 16 PaaS Sql Azure databases (5 of them are 24x7). They have the default schema [dbo].

What is the best tool or strategy to perform online sync

		Database.[dbo].Table -> DatabaseJoined.[schemaDest].Table

Important considerations:

• There are different ones that have the same table names but with different structures/fields.

From what I've read of data sync, it's not possible for that.

Example: Db1.[dbo].Requests

	 Db5.[dbo].Requests

	 Db7.[dbo].Requests

As it is 24x7, we can easily point to one base or another on the application side, the work of joining the schemas has already been "done in the cold". However, I can't just "turn the switch" without synchronization taking place. I cannot guarantee whether within the business flow data accessed/modified will be from today, yesterday or 1 year ago.

I need to have an idea of ​​how to sync. Even in a "wave process" (wave 1,..., wave N).

Answer 1

A commercial alternative you can test and will probably fit your requirements is Symmetric DS. It works very well with Azure SQL databases.