June 5, 2009 at 8:39 am
I am going to learn replication, but in our environment we have only one 2005 server and one 2008 server, and the book that I am learning replication is for 2005.
My questions are : is it possible to replicate from 2005 to 2008, as well as other way around - is it possible to replicate from 2008 to 2005 version ? And what is better for learning purposes ?
Thanks.
June 5, 2009 at 1:30 pm
http://vinay-thakur.spaces.live.com/blog/cns!645E3FC14D5130F2!177.entry
Check replication sites...
HTH
Vin
Thanx.
Vinay
http://rdbmsexperts.com/Blogs/
http://vinay-thakur.spaces.live.com/
http://twitter.com/ThakurVinay
June 9, 2009 at 9:36 am
The replication is possible between 2005 to 2008 and 2008 to 2005. They are almost the same. The difference is between 2000 and 2005.
I would say learn with the book you have. That should help. They have not changed much in replication between 2005 and 2008. Just made it more robust.
Just my 2 cents
-Roy
June 9, 2009 at 9:40 am
I also want to point out that it is possible for a Server Instance to replicate to itself, as long as it's a different database. In fact the first production replication environment that I setup and maintained 8 years ago was from one database to another on the same server instance.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply