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.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 How to save Enterprise Manager profile

Author  Topic 

asialili
Starting Member

1 Post

Posted - 2005-12-21 : 13:03:06
Hi everyone,

Do someone know how to save enterprise manager profile to save all the registered servers list -> to install on another computer ? (I have a big server list)

I've didn't find an *.ini file, and i've tried to export Windows Registry keys, but I cannot import them into the second computer.
config : SQL2k - sp4 on Windows 2K

Thanks a lot
asia

surendrakalekar
Posting Yak Master

120 Posts

Posted - 2005-12-22 : 03:23:40
You can find out those entries in registry...
HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\80\Tools\SQLEW\Registered Servers X

But I don't think so it is possible to import it..... Find out whether some external tool for this is available or not.


Surendra
Go to Top of Page

ddustin585
Starting Member

1 Post

Posted - 2006-01-07 : 11:00:10
Right click on the Registered X folder in the registry and choose Export to save to a .reg file. Copy the .reg file to the desired machine and double-click on it to write it to the registry.
Go to Top of Page

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2006-01-07 : 12:15:22
quote:
Originally posted by ddustin585

Right click on the Registered X folder in the registry and choose Export to save to a .reg file. Copy the .reg file to the desired machine and double-click on it to write it to the registry.



that doesn't work these days. I think MS changed things around SQL 7 sp2 or so and now the information in tht registry key is encrypted.

I posted about a method to export/import the registrations a while back. I'll dig for it and link to this thread.



-ec
Go to Top of Page

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2006-01-07 : 12:16:51
check this thread out http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=59133



-ec
Go to Top of Page
   

- Advertisement -