export from 2005 and import to 2000

Question

Post reply

export from 2005 and import to 2000

jgnimje

SSC Journeyman

Points: 89
More actions
February 16, 2010 at 7:16 am

#137290

Hi,
We are converting the database 'A' from 2000 to 2005 on one server. and there is another database 'B' on another server on sql 2000. I need to transfer the data based on some query from database 'A' to 'B'. EXPORT file created on database A (sql server 2005 ). export file created is attached herewith. table defination is as follows :
request_numberintno4
statusvarcharno15
application_codecharno3
standard_numbervarcharno11
standard_topicvarcharno50
exception_descvarcharno255
scopevarcharno255
business_casevarcharno255
risk_mitigationvarcharno255
created_ondatetimeno8
exception_start_datedatetimeno8
exception_stop_datedatetimeno8
next_recertify_datedatetimeno8
first_namevarcharno30
last_namevarcharno30
user_typevarcharno10
Any one can help me to import this file in sql server 2000. Is there any way to import the data in the sql server 2000.
Thanks in adv.
Regards,
Jayant

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

jgnimje SSC Journeyman Points: 89 More actions · Answer 1

Anybody who can help me to import the file ?

Thanks,

Jayant

Animal Magic SSChampion Points: 13964 More actions · Answer 2

Use SSIS (2005) or DTS (2000) to extract and load the data.

Or use BCP if you want too.

how much data are you moving, and whats the purpose of the move?

Lowell SSC Guru Points: 323518 More actions · Answer 3

I looked at your datafile,a nd because some records will contain multiple CrLf,s you will have to use SSIS or BCP, as suggested above.

on the SQL 2005 server, you will have to use BCP to create the format file . you will also need to export the table definition using SSMS (CREATE TABLE ....)

then use bcp to export the data, which from the file you posted, looks like you know how to do.

Finally on the 2000 server, you'll need to run the script to create the table, and then use bcp to import the file using the format file you created and dragged over from the 2005 server.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!