CODEWITHSUNDEEP
sql-serversql-server-2005synchronization
Uffe
Uffe

Reputation:

synchronize two sql server 2005

I need to synchronize two sql server 2005 instances between intranet and extranet (through a firewall). Synchronization will be initiated from the intranet. What solutions do I have at my disposal?

intranet db: table t1 -> extranet db: table t1

intranet db: table t2 <- extranet db: table t2

i.e. intranet t1 content should be pushed out to extranet t1 and intranet t2 content should be fetched from extranet t2.

We intend to sync every hour.

Upvotes: 0

Views: 460

Answers (1)

Cade Roux
Cade Roux

Reputation: 89651

Replication, log-shipping, backup/restore, export/import. All depending on your requirements.

Based on just shipping tables, I would just use SSIS.

Upvotes: 3

Related Questions