Solved

Distribution server migration

Posted on 2008-10-08
7
439 Views
Last Modified: 2013-11-30
Hi fellow experts,

I have a question for you:

I have a SQL server that is used as a distribution server for all our replications. We have about 100 publishers and at least the same subscribers each with many articles. I want to move/migrate from this server, which is a  2k SQL server on an older box to a newer one with 2k5 SQL server.

Ist there an automated way to do this or do I have to do it manually for each publisher/subscriber?
0
Comment
Question by:Zberteoc
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
7 Comments
 
LVL 60

Accepted Solution

by:
chapmandew earned 500 total points
ID: 22669398
is it possible that the new 2005 machine be named the same as the old 2000 machine ?  I am not sure there is a good way to do this, but it would make sense that you could stop all of your agents, backup and restore the dist. db to the new 2005 server, rename the old server to something else, and give the 2005 server the name of the older server.  I would think once everything is restore that the replication would now point to the 2005 machine.  Make sense?
0
 
LVL 27

Author Comment

by:Zberteoc
ID: 22669525
It surely makes sense , the problem is I've never done this and I need to make sure that it will work.

ANother question is if I stop the distibution on the old server for the move purpose what happens with the changes that happen to the publishing databases meanwhile? Will I need to restart the distribution on the new server by pushing a new snapshot for each publisher?
0
 
LVL 60

Expert Comment

by:chapmandew
ID: 22669735
You may need to reinitialize the publications...which kinda sucks.

Im not a server/hardware guy, so I can't say for sure for the rename.  I would think that it would work though. If you have some extra servers lying around, it might make sense to try to recreate the scenario first.
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 27

Author Comment

by:Zberteoc
ID: 22669921
I just found in Management Studio that if you right click on Replication folder and click on Generate Script it builds a script that pretty much looks like it will create all the distribution detailes if run on a different server but I am not sure. It would be way to simple just like that.

Does anybody know aboiut this?
0
 
LVL 60

Expert Comment

by:chapmandew
ID: 22730771
Is that what you ended up doing..the server rename?
0
 
LVL 27

Author Comment

by:Zberteoc
ID: 22730811
Not yet, we'll see about this as we haven't actually took the migration step yet. Thanks for your suggestions.
0
 
LVL 60

Expert Comment

by:chapmandew
ID: 22730830
Very welcome...
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question