sql server replication: You will be able to specify which tables you want to replicate.
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @ http://vyaskn.tripod.com/


[quoted text, click to view]
From the looks of other messages, I'm in the right place. I have a question
about the replication services in SQK2k. I work in a Realty Estate
management company where we use a management tool connected to a SQL2k DB.
I'm in the process of planning a move of our data to a third party
management
company. We will still need access to the database but they're going to do
the work for us. I know that SQL2k has the ability to replicate a database
to another such as MS SQL2k or Oracle(which is what I'll be replicating
too).
I need to know if it's possible to limit the individual tables that are
replicated. When I publish my db, will all the tables replicate to the new
server or just a group that I specify.

TIA,
Chris

From the looks of other messages, I'm in the right place. I have a question
about the replication services in SQK2k. I work in a Realty Estate
management company where we use a management tool connected to a SQL2k DB.
I'm in the process of planning a move of our data to a third party management
company. We will still need access to the database but they're going to do
the work for us. I know that SQL2k has the ability to replicate a database
to another such as MS SQL2k or Oracle(which is what I'll be replicating too).
I need to know if it's possible to limit the individual tables that are
replicated. When I publish my db, will all the tables replicate to the new
server or just a group that I specify.

TIA,