Guest Dave Navarro Posted November 13, 2007 Posted November 13, 2007 Each time we add a new database to SQL and create an ODBC system connection, we have to re-create that connection on all of our servers so that scripts running on those servers can access the database. Is it possible to auto-migrate ODBC connections from one box to another and keep everything synched? --Dave
Guest Anthony Posted November 13, 2007 Posted November 13, 2007 Re: ODBC connection updates The ODBC connections are just registry keys, so you can export them and then apply them on other machines. You could also script it, as here: http://www.microsoft.com/technet/scriptcenter/resources/qanda/nov04/hey1110.mspx Hope that helps, Anthony, http://www.airdesk.co.uk "Dave Navarro" <dave@no.way.dude> wrote in message news:MPG.21a3a1e0111bcb3998968e@msnews.microsoft.com... > Each time we add a new database to SQL and create an ODBC system > connection, we have to re-create that connection on all of our servers > so that scripts running on those servers can access the database. > > Is it possible to auto-migrate ODBC connections from one box to another > and keep everything synched? > > --Dave
Guest Dave Navarro Posted November 28, 2007 Posted November 28, 2007 Re: ODBC connection updates In article <uknzqnkJIHA.4880@TK2MSFTNGP03.phx.gbl>, anthony.spam@spammedout.com says... > The ODBC connections are just registry keys, so you can export them and then > apply them on other machines. You could also script it, as here: > http://www.microsoft.com/technet/scriptcenter/resources/qanda/nov04/hey1110.mspx > Hope that helps, > Anthony, http://www.airdesk.co.uk > > > "Dave Navarro" <dave@no.way.dude> wrote in message > news:MPG.21a3a1e0111bcb3998968e@msnews.microsoft.com... > > Each time we add a new database to SQL and create an ODBC system > > connection, we have to re-create that connection on all of our servers > > so that scripts running on those servers can access the database. > > > > Is it possible to auto-migrate ODBC connections from one box to another > > and keep everything synched? Thanks for the link. So, what I need to do is write a script to synch the registry entries for ODBC connections between the servers and stick it in the scheduled tasks or something. This should be interesting. :) --Dave
Recommended Posts