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@#.