October 8, 2008 at 9:28 am
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.
Is there an automated way to do this or do I have to do it manually for each publisher/subscriber?
In Management Studio 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 details if run on a different server but I am not sure. It would be way to simple just like that.
Does anybody know about this?
Don't just give the hungry man a fish, teach him how to catch it as well.
the sqlist
October 14, 2008 at 11:10 am
Yes, you can script these. Manually scripting 100 or so would be pretty monotonous. Why don't you write a little VB using the SQL Server API to script them all?
I found this on Google. http://www.databasejournal.com/scripts/article.php/1480331
I've never used it but might be worth while looking into.
Chris.
Chris.
October 14, 2008 at 1:50 pm
You are going to need a script but because you are in a "2005" forum and the suggested script above uses DMO I should warn you that you MUST use SMO instead!
good luck
* Noel
October 14, 2008 at 2:32 pm
How about the feature with right click and generate the script? Has anybody used that? As it seems the script does about just right in creating all the objects involved in the replication, including the jobs. My problem is that I have never tried such thing and I am not sure what the consequences would be in running that script on a different server.
Don't just give the hungry man a fish, teach him how to catch it as well.
the sqlist
October 14, 2008 at 2:54 pm
Yep, I've used that a lot.
Chris.
October 22, 2008 at 12:02 pm
I wonder if you could:
Name the new server the same as the old server (off the network until swap time)
configure distribution
copy the mdf and ldf files and attach
[Note-- I haven't done this.. just thinking]
Ben
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply