Hi,
first let me explain the situation. I hav a database which contains more
than 500 tables ... now we are setting up another server and the requirment
is like i want to replicate the data of 5 tables with the new server. i dont
want to replicate the entire database ... plz guide me for this situation ...
plz dont say NO coz i know that there will be some way to achive this ...
waiuting for ur response ...
thanks in advance
Deepson Thomas
Deepson,
this is possible using replication. Is the flow of data in one direction
only? If so, then transactional replication would almost certainly be the
route to go down. Have a look at the book in my signature below and BOL for
further details.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment