Tag Info

New answers tagged

1

Without an internet connection, you would be looking at merge or peer-to-peer replication. Neither of which can be implemented easily (google I seem to remember seeing a workaround somewhere) how you want with Express edition. If you had standard or better edition I would personally go with Peer-To-Peer as it negates the need for an additional column per ...


0

Take a look at existing technology: replication. As per the documentation (emphasis added): Replication is a set of technologies for copying and distributing data and database objects from one database to another and then synchronizing between databases to maintain consistency. Using replication, you can distribute data to different locations and ...


0

Since I know Powershell and VB much better than T-SQL, I would use one of those languages to pull new records from each database, loop through them, and insert them into the other database. The script would save a file that contained the timestamp of the last record from each database, which it would use the next time it ran to get the records newer than ...



Top 50 recent answers are included