Solved

Data Export from SQL6.5 to 7.0

Posted on 2000-03-14
7
515 Views
Last Modified: 2008-03-10
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 ?
0
Comment
Question by:stefanx
7 Comments
 
LVL 3

Expert Comment

by:ghimireniraj
ID: 2619603
great
0
 
LVL 8

Author Comment

by:stefanx
ID: 2619859
What kind of comment is that ?
0
 

Accepted Solution

by:
StangLady earned 100 total points
ID: 2620023
Did you try scripting your tables and just doing an import on the data making sure to set the  ENABLE IDENTITY INSERT option?
0
Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

 
LVL 2

Expert Comment

by:kubeerja
ID: 2620525
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
 
LVL 8

Author Comment

by:stefanx
ID: 2621291
OK thanks to everyone so far. I'll try this in the morning
0
 
LVL 2

Expert Comment

by:rdrrichards
ID: 2627687
The Import/Export wizard has the option of moving database objects too. Have you tried that?
0
 
LVL 8

Author Comment

by:stefanx
ID: 2631090
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

Featured Post

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SQL date incremented 11 30
T-SQL: Episode III - Revenge of The Dude 24 53
Refresh Dev server with Production database 8 28
SQL Server 2012 - Merge Replication Issue 1 20
I wrote this interesting script that really help me find jobs or procedures when working in a huge environment. I could I have written it as a Procedure but then I would have to have it on each machine or have a link to a server-related search that …
Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

776 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question