I have two same database on two different server, and I want to synchronize both database.
For example, If I do any process like Insert, Update, Delete, Alter, Drop, etc it also reflect on other database automatically.
I had tried it on my local server, but every time I have to do it manually.
Is there any way to do it automatically, suppose I Insert a record and it automatically inserted into other database.
解决方案
What you're talking about is called 'Replication'.
If you are going to be making changes to both databases and expect it to show up in the other, you need a Master/Master pair.