|
|
||||||
|
#1
02-15-05, 12:11 PM
|
|
|
|
|
We're trying to migrate servers and have around 100 DSN's setup
currently. Is there a way to migrate various data source names (e.g. Access, SQL Server and MySQL) from a source server to a target server keeping all of the information intact (e.g. username, password, DSN, description, etc)? Your help would be most appreciated! Thanks, Jason |
|
|
|
#2
02-15-05, 02:00 PM
|
|
|
|
|
"JasonK" <jkorkin> wrote in message
news:7490 > We're trying to migrate servers and have around 100 DSN's setup > currently. Is there a way to migrate various data source names (e.g. > Access, SQL Server and MySQL) from a source server to a target server > keeping all of the information intact (e.g. username, password, DSN, > description, etc)? > > Your help would be most appreciated! > > Thanks, > > Jason > Most of the information can get transferred by opening the Registry Editor (regedit.exe) and exporting the key(s) HKEY_LOCAL_MACHINE\Software\ODBC\ODBC.INI and HKEY_CURRENT_USER\Software\ODBC\ODBC.INI for each user. I would not recommend exporting the ODBCINST.INI keys because some components need to be registered and this would not do it. So, export the specified keys, install the drivers and import the keys. You should also copy the ODBC.INI file from the Windows folder. |
|
#3
02-22-05, 02:30 PM
|
|
|
|
|
JasonK,
Please try out our free ODBC manager (www.sqledit.com/odbc). The program allows you to audit local and remote data source definitions, remove DSNs and import definitions created on one of the computers on a remote system right from your workplace. J> We're trying to migrate servers and have around 100 DSN's setup J> currently. Is there a way to migrate various data source names (e.g. J> Access, SQL Server and MySQL) from a source server to a target server J> keeping all of the information intact (e.g. username, password, DSN, J> description, etc)? Igor Shekalev, http://www.sqledit.com, powerful database tools |
|
|
| Similar Threads | |
| Export big Public Folders from old server to a new server Hi, Can anyone help me with this? On our old server windows 2000 with exchange 2000 we have a big public folders (16GB) Does someone knows an easy way to 'copy' this public... |
|
| Can I share a Web Server certificate by export with provate key and import to another server Hi, I have two IIS server at two location , all having the same content . If I have a certificate on Server A , can I export both the certificate and its private key and... |
|
| Export data from SQL Server 2000 into SQL Server CE Hi, I am developing PPC application using SQL Server 2000 and SQL Server CE 2.0. I succeeded in getting/pulling data from handheld/sql server ce into sql server 2000 using... |
|
| Export from SQL Server to CSV I have an app that gets data from SQL Server and writes it to a csv file. My problem is that my query returns 25K + records. IE seems to 'hang' and the csv file never gets... |
|
| Only one NFS export on Mac OS X Server 10.3.2 possible (Bug?) Hi, We're running an Apple Xserve with attached RAID storage. The operating system is OS X Server 10.3.2 with updates from this morning. This server acts as an NFS server in... |
|
|
All times are GMT. The time now is 01:37 AM. | Privacy Policy
|
Way to Export DSN's From one server to another?