Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I have just got SQL Server Mgmt Studio 2008 installed on my machine. Previously I was working with SQL Server Mgmt Studio 2005. I had stored a number of databases under Registered Servers in 2005. I am able to export these to a .regsrvr file from 2005. But I don't see any option in 2008 to import these.

Can you please advice on how the registered servers can be imported into SQL Mgmt Studio 2008?

Thanks :)

share|improve this question
add comment

1 Answer 1

up vote 1 down vote accepted

Open the registered servers window (View > Registered Servers) open Database Engine. Right click on Local Server Groups, then select Tasks then Import.

share|improve this answer
    
Yes, thanks. But I can't import the file exported from 2005 to 2008 as the xml formats are very different. –  Rashmi Pandit Aug 2 '11 at 3:38
    
Do you still have access to the machine which had SQL 2005 on it? Can you upgrade that machine to SQL 2008? Or are you trying to do all this on one machine. –  mrdenny Aug 2 '11 at 7:27
    
One machine. I have several servers registered, so I am just trying to migrate the registrations rather than re-creating all of them in 2008. –  Rashmi Pandit Aug 2 '11 at 8:36
    
You should be able to right click on "Local Server Groups" select "Tasks" then "Previously Registered Servers" and it should import the information from the old registry keys. –  mrdenny Aug 2 '11 at 23:25
    
Yes! Thanks mrdenny :) This has saved a lot of my time :D –  Rashmi Pandit Aug 3 '11 at 3:25
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.