because of performance problems I want to put my SQL database on 3 SQL servers. 1 For Sales, 1 for Financials and 1 for an other department. I want them to exchange the data changes, so I tried merge replication. The problem is that the Distributor adds a unique identifier to all my tables.
Now my application doesn't work anymore because it does a nameless INSERT. The company that made the application refuses to change it.
The application also supplies the primary keys for all tables, so I also have the problems of duplicate keys because of the timeout between the snapshots.
Is there any other way to synchronise the databases (not via triggers) or is fragmentation possible? (the files for sales on 1 server, the files for Financials on the second server a.s.o.)