Data Export from SQL6.5 to 7.0
Posted on 2000-03-14
I've recently had to move data from a SQL6.5 to SQL7.0 database. I did this with the Import/Export wizard and connect through SQL Server OLEDB Driver to SQL7.0 and the SQL Server ODBC Driver to SQL 6.5. All seems to work well, except that the consraints on the individual tables (for example the identity field) was not preserved. Is there a way to ensure that the identity and other constaints, as well as the indices are successfully recreated during the import? AM I missing something in the import wizard ?