Relocating users to a new SQL server

Ctrl + k

Published 3 years ago

Good morning-

I am moving our SQL database to a new SQL server, and am thinking about how I will have users update their data source configuration. I built a custom installer that includes only this new data source, but if a user is at the same version the custom installer will not proceed. Forcing people to remove RDM and reinstall is not a great option, so I am looking for something better.

I've started digging through the file system looking for an ini or cfg file that I could modify to change the hostname of the SQL server but so far have been unsuccessful. Where is the data source configuration stored on Windows clients?

What is the easiest method for our users to point to this SQL server?

Thanks,

Josh

Senior Infrastructure Engineer

How to Export and Import Data Sources Configuration

All Comments (5)

Samuel Dery

Published 3 years ago

Hello,

Thank you for reaching out to us regarding this,

I see, perhaps simply generating an export of the data source configuration which your users can import would work in your case?

We have the following knowledge base article regarding this: https://kb.devolutions.net/kb_import_export_data_sources.html

Let me know,

Best regards,

Samuel Dery

Josh

Published 3 years ago

I'm familiar with the import/export feature, but am hoping to avoid having to guide each user through the transition. That's why I was hopeful that I can find where the datasource configuration is stored on the endpoint and then push a change to each users configuration that will point them to the new SQL box. The SQL hostname is the only thing changing.

Thoughts?

Senior Infrastructure Engineer

Samuel Dery

Published 3 years ago

Hello Josh,

Thank you for your reply,

I see, from my understanding, the data source information is stored in the RemoteDesktopManager.cfg file under %LocalAppData%\Devolutions\RemoteDesktopManager by default, however, I do not believe it could be edited from there.

I'm afraid the only options in this would be to use the Custom Installer, generate and export of the data source configuration which the users can then import, or ask your users to manually edit the data source configuration.

Let me know if this helps,

Best regards,

Samuel Dery

Josh

Published 3 years ago

Bummer. I had reviewed that config file previously, and could not find any lines containing any information regarding data source. Is it possibly stored somewhere else?

Appreciate the help!

Josh

Senior Infrastructure Engineer

Samuel Dery

Published 3 years ago

Hello,

Thank you for your reply,

After discussing this with our engineering department it would seem the data source configuration is now stored in the RemoteDesktopManager.stv, however, I'm afraid this file cannot be manually edited.

While discussing your case, they suggested perhaps using a default.cfg file could work for you, to do so you can go under File – Options – Export Options and select the desired data source to include and Save the file with the name default.cfg.

Once done you can Move the default.cfg file in the installation folder of Remote Desktop Manager,

Let me know if this helps,

Best regards,

Samuel Dery