November 6, 2007 at 8:23 am
I'm new to table partitioning and have a job to partition a table that's being replicated to a reporting server. I remember reading that you cannot use the ALTER TABLE...SWITCH command with replicated tables. So, what are my options? Do I just need to remove the table as an article from replication, perform the partition, then add it back? Also, do I need to do the same thing on the reporting server?
Thanks,
Brent
November 6, 2007 at 3:03 pm
You are correct on the SWICHT statement. It is not possible to use it because it is supposed to be a minimally logged opperation which LogReader can't understand, like Truncate Table.
If you need to have the partitions then you are forced to remove that table from the publication do the partitioning opperation and add it back. If you specify the schema options
0x40000 + 0x80000 + 0x100000 on the article when you run the snapshot agent the "partitioned scheme the index and the filegroup should be replicated.
I have not done that in the past but I am considering it now.
Let us know how it goes for you 🙂
* Noel
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply