What's the best way to setup the system if I have one "main" MSSQL DB and another MSSQL DB on a remote ISP site with just a subset of tables of the main DB but with same "Insert/Update" capabilities? Do I need to abandon the use of the "Identity" column on each table as primary key since both DB "Inserts" that'll conflict? TIA.
It's "my" world. You're just living in it.