Re: Replication of Partitioned Table

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@xxxxxxxxxxx> wrote in message
news:1169135380.823972.240550@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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?



.

Relevant Pages

  • Re: Setting On delete cascade on subscriber alone - Transactional Pull
    ... i do not replicate deletions on the tables. ... publishers will not have Delete cascade set on any of the replicated ... your subscriber, and the parent row will be deleted, then the cascade will ...
    (microsoft.public.sqlserver.replication)
  • Re: do I need Indexed Views for Replication
    ... the log reader will extract all the columns in a table which ... So if you replicate table 2 the commands written to the distribution agent ... It will have to join on table 1 in the subscriber to get this value. ...
    (microsoft.public.sqlserver.replication)
  • Failed to replicate row with geomentry column
    ... I have a problem with replicating table that have 1 geometry column. ... Publisher - MS SQL Server 2008 Standard ... Subscriber can replicate Delete operation and Update. ...
    (microsoft.public.sqlserver.replication)
  • Trans Replication Error 6401 - Spaces in Column names?
    ... I am looking to setup Transactional Replication between two servers. ... After configuring the Publisher, Distributor and Subscriber I want to ... to replicate via 'Queued Updating Subscribers' ...
    (microsoft.public.sqlserver.replication)
  • Re: Merge Replication - Insert Foreign Key Constraint Violation Conflict
    ... If I replicate data down to my subscriber, ... insert extra dependent rows -- but somebody on the publisher side ... The master record and the dependent rows that the publisher knew ...
    (microsoft.public.sqlserver.replication)