Can anyone assist?
I am trying to transfer a SQL6.5 database to a SQL 7.0 database using the
DTS wizard unfortunately the wizard does not migrate table indexes, identity
columns and defaults.
I was not expecting any issues with migrating from 6.5 to 7.0
Maybe I'm doing something wrong
Source: Microsoft ODBC driver for SQL server on a remote server
Target: : Microsoft OLE DB provider for SQL server on a local server
I have used both TC/IP sockets and named pipes with no difference.
Surely this is a standard request for at least SQL 6.5 to 7.0?
Does this mean I need to script it all?