Global update of multiple tables -- sql server replication

Jaco
8/11/2005 2:27:39 AM

Hi

I need to globally update certain tables over multiple databases. I have
about 300 tables in each database and only a handfull will be the same.
Can I do this with replication? Can you setup replication for only certain

Jaco
8/11/2005 4:48:10 AM

Thanks Paul

[quoted text, click to view]

Paul Ibison
8/11/2005 12:02:03 PM

Jaco,
replication is seldom all the tables in a database - mostly a publication
contains a small subset of the tables. I'd recommend having a good look a
BOL (books on line) and the book in my signature below.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server replication

sql server replication : Global update of multiple tables