Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
vishal.todkar
Starting Member
20 Posts |
 Posted - 2009-11-25 : 07:54:56
|
| Hi Guys.We have Sites running under Merge and Transactional Replication. These are using SQL Server 2005 SP3 Standard edition on Windows Server 2003 machines.Our new requirement is migrating setup From Windows 2003 Server – SQL Server 2005 SP3 Standard Edition To Windows 2008 Server R2 64 bit– SQL Server 2008 64 bit SP1 Standard EditionCould you please provide me necessary steps, suggestions, do’s and don’t? Thanks in advance.Vishal |
|
|
rajdaksha
Aged Yak Warrior
595 Posts |
Posted - 2009-11-25 : 08:10:39
|
| Hi vishal.todkarThe first thing that you need to do following an upgrade is to update the statistics on every table in every database that you upgraded. It also wouldn't hurt to rebuild the indexes as well. That is not just your databases, but the distribution database as well.subscriber database aslo-------------------------R... |
 |
|
|
vishal.todkar
Starting Member
20 Posts |
Posted - 2009-11-25 : 23:28:18
|
| Hi R.I appreciate your reply and inputs. Thanks for your assistance.I want to know the exact process like, how I can move the databases from Win2K3 to Win2K8 and then Replication Agent Jobs etc.One of the thing I am aware is,Upgrade needs to perform in following order. Distributor, Publisher, and then SubscriberReason: The Distributor must be at the same or greater version than the Publisher to receive changes. The Subscriber must then be equal to or less than that of the Publisher.Vishal |
|
|
|
vishal.todkar
Starting Member
20 Posts |
Posted - 2009-11-30 : 23:57:07
|
| Any suggestions guys ?Vishal |
|
|
|
rajdaksha
Aged Yak Warrior
595 Posts |
|
|
|
|
|
Migrating Replication setup from 2005 to 2008