Export Database Connections

[mango333]

This question is for Schema Compare, Professional Edition, Ver 4.0.32.

I've noticed that connections created in Connection Manager are user dependent. Is there a way to export those connections or copy them from a user folder and make them available for another user? We are using .scomp files as a way to provide consistent comparisons, regardless of the user, but these fail on the command line if both users don't share the connection named and created in the exact same way.

[alexa]

You can export the connections list by exporting the following system registry branch to a *.reg file:

Code: Select all

HKEY_CURRENT_USER\SOFTWARE\Devart\dbForge Common Settings\Connections\SQL Server

[mango333]

That's good to know if I need to migrate them from one machine to another. But I'm referring to multiple users on the same computer. If Johnny set up some connections on CompareServer, how does Becky get those same connections on CompareServer?

I've looked in the registry, I've looked in local data, documents, temp. I don't see anything that looks like a list or database.

[mango333]

I exported the desired connections out of the registry location listed. I then logged into the machine with the service account that will be running the comparisons and imported the registry file and everything is good now. I've never used an application like this before where connections were stored in this way; makes it a little harder to manage, but we've got it figured out now.

[alexa]

Thank you for updating us on this issue.

Additionally, you can add a suggestion on our UserVoice forum where other users can vote for it http://devart.uservoice.com/forums/1770 ... sql-server

We collect and analyze the information from this forum in order to make a proper roadmap for future product releases.