InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 20 Jun 2013 06:15:00 GMT20http://www.sqlservercentral.com/Forums/Topic1413762-391-1.aspxThank 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.... Mon, 11 Feb 2013 10:49:26 GMTsaqlainkhanhttp://www.sqlservercentral.com/Forums/Topic1413762-391-1.aspxAny luck with this?AndrewSun, 10 Feb 2013 12:31:57 GMTAndrew Pruskihttp://www.sqlservercentral.com/Forums/Topic1413762-391-1.aspxIf 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.AndrewWed, 30 Jan 2013 15:27:29 GMTAndrew Pruskihttp://www.sqlservercentral.com/Forums/Topic1413762-391-1.aspxSQL 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_ITIf 1 is possible then i would need help on what will be the best approach for the following scenario:[b]Sever A:[u][/u][/b]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.)[b]Server B: [u][/u][/b]This has file group name FG_JJIf 1. is true and i did change the filegroup on the Destination table, will replication break?Help would be greatly appreciated.Wed, 30 Jan 2013 13:45:38 GMTsaqlainkhan