I need to replicate the ODBC drivers from one environment to another located on other server, the one that has the drivers I want to backup is running Windows Server 2012 Datacenter
and the other Windows Server 2016 Standard
(in case it matters). The problem is I don't figure a way out to backup/restore lots of ODBC drivers that the projects hosted on these servers need to work properly.
Are the drivers listed on the tabs System DSN,
User DSN
and File DSN
stored physically on any directory of the server?
What would the best practice to replicate/backup all the drivers listed from one server to the other so that I do not need to recreate them manually?
I would appreciate if there were a way of automating it by means of PowerShell script or something alike.