We have number of triggers for synchronizing data between two databases in the same server. Due to concurrent users along with Two-way Sync, we faced deadlocks and missing INSERTS.
How can we overcome this issue? I meant to say any alternate approach for synchronizing tables data across databases in the same server using SQL Server..
I know that we have Replication mechanism, DB Mirroring and SSIS packages to try out this... But i would like to know what is better/best approach?