I have a table partitioned in 2005 EE and also replicate it to other
SQL Server databases. There is a filter on the replication, so not all
the records are replicated. So, with the fewer number of records, I
don't want to include the partitioning on the subscriber databases.
Also, I'm not 100% positive all customers of the product use EE on the
subscribing databases. My question is: can I replicate the partitioned
table and not require it to be partitioned on the subscribing databases?
Its difficult to replicate a table partition's structure to the subscriber.
By default you will end up with a plain vanilla table on the subscriber.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Ken" <kenneth_hardy85@.hotmail.com> wrote in message
news:1169135380.823972.240550@.v45g2000cwv.googlegr oups.com...
>I have a table partitioned in 2005 EE and also replicate it to other
> SQL Server databases. There is a filter on the replication, so not all
> the records are replicated. So, with the fewer number of records, I
> don't want to include the partitioning on the subscriber databases.
> Also, I'm not 100% positive all customers of the product use EE on the
> subscribing databases. My question is: can I replicate the partitioned
> table and not require it to be partitioned on the subscribing databases?
>
No comments:
Post a Comment