[thelist] RE: SQL Server and partial replication

[Ashok Hariharan]

This can be done through replication, by making your
parent server as a publisher and the server that you
want to maintain a copy in as subscriber.

However an easier option to use (in case the time lag is
not so critical) is to use Data transformation services (DTS)
and copy the table contents from one database to another
on a scheduled basis.
(DTS is the best option for sending feeds to ms-access)

>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?


--ashok