Replication between SQL2k and Oracle

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
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/
"Chris" <Chris@.discussions.microsoft.com> wrote in message
news:7990EECE-3C1E-45A4-AE77-4FF9E8A59142@.microsoft.com...
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