Data Export from SQL6.5 to 7.0

Hi all,

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 ?
LVL 8
stefanxAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
StangLadyConnect With a Mentor Commented:
Did you try scripting your tables and just doing an import on the data making sure to set the  ENABLE IDENTITY INSERT option?
0
 
ghimirenirajCommented:
great
0
 
stefanxAuthor Commented:
What kind of comment is that ?
0
What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

 
kubeerjaCommented:
Import/Export wizard will import Data only and create tables with basic structure only without creating constrains or indeces or keys.
Make a full script of your Database including constrains , inceces,foriegn keys and users.
Run it on the new server then import the data.
0
 
stefanxAuthor Commented:
OK thanks to everyone so far. I'll try this in the morning
0
 
rdrrichardsCommented:
The Import/Export wizard has the option of moving database objects too. Have you tried that?
0
 
stefanxAuthor Commented:
OK Stanglady and kubeerja - both of you are right. It just turns out that if you are importing using ODBC Driver from SQL 6.5 and OLEDB Driver to SQL7.0 and you are running enterprise manager from Windows 98, that the import/export wizard GPF's (I've done this from many machines now, and it always crashes). When doing it from NT, it is fine.

I think the points are going to Stanglady, purely because he/she answered first.

Thanks everyone else.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.