I have 2 SQL server with both having a Production database on it.
I am looking to have the same data on both server using a merge replication.
I also want to use the database fail over connection system offer with ignition between the 2 SQL server having the replication.

Does someone have try this and does it create any problem?


This is a pretty generic question without any specifics on how to help you. I’m guessing you want to have mirrored databases, you can setup the failover in your ignition project. Depending on what db server you are using, to mirror them you could probably find easy with a google search. Good luck!