If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)

Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

SQL Enterprise Manager

DannyBuoy · 2008-03-06 11:18:13

Hi, anyone out there know how to export a list of registered servers in Enterprise Manager to a new pc? I've got a user with about 80 different servers listed, I've replaced his pc but dont fancy the task of recreating each connection in turn. I've tried exporting reg keys but while the servers show in the registry of the…

Options

06-03-2008 12:18pm

#1

DannyBuoy

Registered Users Posts: 598 ✭✭✭

Join Date: December 2006

Posts: 569

Hi, anyone out there know how to export a list of registered servers in Enterprise Manager to a new pc? I've got a user with about 80 different servers listed, I've replaced his pc but dont fancy the task of recreating each connection in turn. I've tried exporting reg keys but while the servers show in the registry of the new pc, they dont show in Enterprise Manager. I'm thinking there must be a way but I cant find it.
Any help would save me hours of work, thanks.

0

Comments

Options
#2 08-03-2008 12:27pm
DannyBuoy

Registered Users Posts: 598 ✭✭✭

Join Date: December 2006

Posts: 569

<bump>

0
Options
#3 08-03-2008 12:54pm
JohnK

Registered Users Posts: 4,780 ✭✭✭

Join Date: December 2002

Posts: 4579

Have you tried this: http://www.sqlservercentral.com/scripts/powershell/62275/

0
Options
#4 08-03-2008 9:20pm
DannyBuoy

Registered Users Posts: 598 ✭✭✭

Join Date: December 2006

Posts: 569

Thanks JohnK, that looks to be exactly what I need, will give it a shot on Monday.

0