May 2, 2012 at 3:01 pm
I'm in a situation where I could mute a bunch of aggravation by replicating a SQL 2008 database to it's 2005 equivalent.
We're in the middle of a "phased upgrade" of our servers to 2008. The phases were defined poorly, and the situation exists where there are 2 servers, both currently running 2005, and there is log shipping happening between them. The "source" server is getting upgraded to 2008 on a particular date, and a LOT of work needs to happen to the "target" of that log ship before it can be upgraded to 2008.
That means there will be a stretch of time where the source is 2008, and the target is 2005. I'm told that log shipping is NOT an option in this scenario.
Would replication between 2008 and 2005 boxes be possible? Anybody got another idea that doesn't involve gobs of development?
I found this article, but it doesn't really answer my question: http://www.sqlservercentral.com/articles/Replication/logshippingvsreplication/1399/.
Thanks SSC. You guys are the sh@#.
May 2, 2012 at 3:53 pm
Log shipping from SQL 2008 to SQL 2005 will not work.
However, replication from SQL 2008 to SQL 2005 will work. Check out the article below for the caveats.
May 2, 2012 at 3:59 pm
The distributor is usually the issue. It must be equal to the publisher, so from 2008 -> 2005, you need a 2008 distributor.
May 2, 2012 at 5:00 pm
Thanks fellas. This could really pay dividends. I've got it on my calendar to tie this thread off with my experience in 2 weeks.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply