[thelist] SQL Server and partial replication

[Chris Spruck]

-------Original Message-------
From: john at evolt.org.uk
Is it possible to keep a second copy of only part of a Microsoft SQL Server database, either in a second SQL Server or MS Access via ODBC, *and* have the master DB feed updates to the 'slave' live or near-live?
-------Original Message-------

John,

I haven't dealt with this myself (yet), but according to my SQL 2000 book, you can select tables and objects (stored procedures, views, etc.) from within a server to publish. There's a Create Publication Wizard where you'd have the chance to select what you want.

At a quick glance, you would create a "Publisher" as the master, then your "slave" would need to create a "Subscription" to the Publisher. There's probably lots of better info in the SQL Books Online that gets installed with SQL.

Not sure about this with Access, but I know you can pull things into Access from SQL Server through ODBC. Sounds like your friend needs "push" though.

HTH!

Chris