January 30, 2013 at 1:45 pm
SQL Server: SQL 2008 r2
1)
Is there a way to change the FileGroup for a sql table having 16m records from Primary to (for instance) FG_IT
If 1 is possible then i would need help on what will be the best approach for the following scenario:
Sever A:
It has an Indexed View for a base table that has a File Group IT_JJ. In the past we setup Indexed View replications BUT with with the source table having a file group pointing to Primary.
Using tsql for creating logbased replication there is an option in sp_addarticle @schema_option and use the following option (i have to yet try this option out..never done this)
0x40000 (Replicates filegroups associated with a partitioned table or index.)
Server B:
This has file group name FG_JJ
If 1. is true and i did change the filegroup on the Destination table, will replication break?
Help would be greatly appreciated.
January 30, 2013 at 3:27 pm
If the table has a clustered index on it you could rebuild the table, moving the clustered index to the new filegroup. That will move your data.
I would not think that replication will break but I would test this first.
Andrew
February 10, 2013 at 12:31 pm
Any luck with this?
Andrew
February 11, 2013 at 10:49 am
Thank you for the response Andrew.
There is no luck with indexed view replication. In order to have this working we went a different route.
* We did straight Table --> Table replication.
* On the destination created a view (with all the conversion date --> small datetime) on the destination table.
At this point we did not care on the performance and had to get data moving. Reason for not looking into performance is we are planning to upgrade the DW to SQL 2012 that way there are no legacy data types.
Thank you for looking into and throwing out suggestions....
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply