Sync servers

[Heer]

Hi

What is the best way to sync ODBC connections and drivers between two servers? I.e., export the connections from one server and import to another. How to do this?

[fmvizcaino]

Hi @Heer ,

You can export the connections from the registry. Here is how. https://smallbusiness.chron.com/open-ldb-file-windows-7-63711.html

Best,

Fernando Vizcaino

[Heer]

I dint understand? What is that file? Also im asking about Alteryx connections. Not Access database

[fmvizcaino]

Hi @Heer ,

I sent you the wrong link. Here it is. https://www.itprotoday.com/windows-and-user-productivity/how-do-i-migrate-odbc-data-sources-one-serv...

This is to move your ODBC drivers and DSN connections.

If your question is related to the Gallery Data Connections, if I`m not mistaken, you will have to do it manually.

Best,

Fernando Vizcaino

[Heer]

Thanks a lot. That worked and was helpful. Any idea how i can sync the drivers?

[fmvizcaino]

The last part of this tutorial can help you. I`m not very experienced with this part so not sure if this will move all of your drivers entirely or only parts of it.

https://community.progress.com/s/article/6951

Best,

Fernando Vizcaino