Using the DSN Migration tool

The DSN Migration tool can help you migrate the data sources from the OLE DB Driver Kit to the OLE DB Driver by Sybase.The dsnmigrate tool uses switches to control which DSNs are migrated. You need to enter the following from the command line:

dsnmigrate.exe [/?|/h|/help][/oledb]
[/l|/ul|/sl][/a|/ua|/sa] [[/dsn|/udsn|/sdsn]=dsn]
[/suffix=suffix]

For all OLE DB DSNs that are converted, the new Sybase DSNs will have the same name.


Conversion switches

The following table lists and describes the switches used in the conversion.

Table 13: Conversion switches

Switches

Description of results

/?,/h,/help

Displays this message. This message is also displayed if dsnmigrate is called with no command line arguments.

/oledb

Places dsnmigrate into OLEDB-mode. By default, ODBC DSNs are migrated.

/l

Displays a list of all OLE DB Driver Kit user and system DSNs.

/ul

Displays a list of all OLE DB Driver Kit user DSNs.

/sl

Displays a list of all OLE DB Driver Kit system DSNs.

/a

Converts all OLE DB Driver Kit user and system DSNs.

/ua

Converts all OLE DB Driver Kit user DSNs.

/sa

Converts all OLE DB Driver Kit system DSNs.

/dsn

Converts specific OLE DB Driver Kit user or system DSNs.

/udsn

Converts specific OLE DB Driver Kit user DSNs.

/sdsn

Converts specific OLE DB Driver Kit system DSNs.

dsn

The name of the DSN to be converted.

/suffix

An optional switch that changes the way DSNs are named. If this switch is used, the original DSN is retained and the new DSN is named “<dsn>-<suffix>.”

suffix

The suffix that is used to name the new DSN.