SQL server consolidation for distributed system

[rashmiee]

The following is showing the basic architectural plan of the system. I want to have 2 databases using a single instance of SQL Server. if one of the databases updated, another one needs to update immediately. (as using trigger) I found that I can do it with consolidation but I don't have any proper way to get it done. what would be the steps to implement that concept?

[b6]

As I understood your question, I think you need to sync 2 databases (A & B) in one SQL server (localhost:3306). I don't know why you need to implementing this. But anyway If you are considering any performance issue, I prefer you to go with database replication.

Anyhow, For your question refer this https://solutioncenter.apexsql.com/how-to-automatically-keep-two-sql-server-database-schemas-in-sync to get more details.

[rashmiee]

That article is more helpful! thank you so much!