Post reply

Workaround Needed to Replicate from Enterprise to Standard and Enterprise has Partitioning

  • July 20, 2012 at 6:51 am

    #276558

    We are working on a project where the Publisher DB is SQL Enterprise 2008 R2 and we want to replicate to SQL 2008 Standard AND the SQL Enterprise has table partitions. The 2 table which are partitioned have time series data and when we tried the replication without partitioning, queries using the table were 6 times slower. Issue is that Standard does not support table partitioning. What is the best approach to workaround the table partitioning on the subscribers and get the speed back :w00t:???? We have heard that using filtering and partitioned views their may be a way-any idea of how???? I would greatly appreciate any help!!:-D

  • July 20, 2012 at 7:59 am

    #1515538

    you can use a roll your own solution using partioned views http://msdn.microsoft.com/en-us/library/ms190019(v=sql.105).aspx, it may take some work to get the large table broken into the new tables but you can at least get a workaround for the partitioned table with a little work.

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply