October 3, 2012 at 10:19 am
What is "almost" live data? An hour, 5 minutes, a couple seconds behind?
If it's something like an hour would a snapshot of a mirror work? I'm guessing it's something a lot closer to < 1 minute though.
October 3, 2012 at 10:29 am
I have no experience with replicating partitioned tables but this article makes me believe it's possible.
http://msdn.microsoft.com/en-us/library/cc280940(v=sql.105).aspx
October 3, 2012 at 10:42 am
(almost) live means I could get through with being up to 10 minutes behind live, within 5 minutes would be good. < 1 min would be fantastic.
October 3, 2012 at 10:49 am
brendan woulfe (10/3/2012)
I have no experience with replicating partitioned tables but this article makes me believe it's possible.http://msdn.microsoft.com/en-us/library/cc280940(v=sql.105).aspx
Wow, thanks for that. If that is true, that totally solves it. cool.
I always thought replication was not supported for partitioned tables.
I'll build a lab tomorrow and try it. I'll let you know if it works.
October 3, 2012 at 10:51 am
I wasn't sure either, so I had to look. Yes, please let me know how it goes. I am curious.
October 12, 2012 at 4:21 am
Sorry for coming back so late on this.
Yesterday I finally had time to set up a lab and run some tests.
Here the findings:
- Yes, partitioned tables can be replicated. Works a treat!
- Partition switches can also be replicated, even switching from a replicated table into a non-replicated table (as long as the partition ranges are valid)
- Partition splits and partition merges are NOT replicated.
- One needs to be extremely cautious of the partitioning schemes of the replicated tables (and non-replicated, if switches into such happen). An errror in the switching-replication will stop the whole replication, and then you have the switch executed on the Source server, but not the target server and it's a pain to get them in sync again.
That said, I will not use the switch-replication, but have my on switching, splitting and merging logic on the target server.
Important thing is the replication of the data, and that works just fine and is enough for my use case.
Thanks again for the tip.
October 12, 2012 at 5:03 am
Hi, read this question with interest and was wondering if a copy only backup from your PROD server restored to your UAT server would do the job seeing as you don't need up to date data? Any thoughts?
email: info@weekendwebdesign.co.uk
Personal Website: http://markallen.co.uk/
Business Website: https://www.weekendwebdesign.co.uk
Viewing 7 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply