Database Replication

[Dawn08]

Is it possible to make a replica of a database without replicating all of the tables. Thanks.

[Clunietp]

What good is a replicated database without any data?

[Dawn08]

Originally posted by Clunietp:
What good is a replicated database without any data?

It's a space issue. Only a few tables will actually will change. Those are the ones I want to replicate. My question is can you replicate specfic tables and not the whole database.

[JHausmann]

Yes.

[pardede]

yes it is possible,
you just set the replicable property of each table to true or false according to whether you want to replicate it or not..

but, first you have to define this property and append it to the tables

if you have books online, you can find explanation on this under 'replication'