4 ms·
Maybe a column with a server id could work? Can you have a schema differing only in the default value for a server id column or would it be replicated as "inser
by crest 3y ago
Maybe a column with a server id could work? Can you have a schema differing only in the default value for a server id column or would it be replicated as "insert default value"?
- gregw2 3y agoNo need... here's a different twist on that .. make the integer primary key generation setup such that one server has odd IDs and the other even and they each increment by two. I did this for many years on Sybase and on SQL Server for active-active failover.