SQL Server 2005: Importing data from SQL Server 2000

Question

In SQL Server 2000, you have the "All Tasks... - Export Data" option. Where is this option the SQL Server 2005 Management Studio?

Or, is there a SQL Server 2005 way of doing this?

EDIT: I am using the Express edition.

EDIT: Joel's response answers my question but Mike's answer gives a great alternative to those of us using the Express edition (vote him up!!).

score 3 · Answer 1 · answered Sep 23 '08 at 15:58

You could use the excellent SQL Server Database Publishing Wizard.

http://www.microsoft.com/downloads/details.aspx?familyid=56E5B1C5-BF17-42E0-A410-371A838E570A&displaylang=en

It allows you to generate a script which contains data, schema, or both. The script can be targeted towards SQL 2000 or SQL 2005.

Some use it for web hosting environments. I use it to move data when I have no other option.

score 2 · Accepted Answer · answered Sep 23 '08 at 15:45

2

If you're using the express edition of management studio the Import and Export features aren't available.

answered Sep 23 '08 at 15:45

Joel Coehoorn

399,467
113
570
794

score 1 · Answer 3 · answered Sep 23 '08 at 15:44

1

DTS has been replaced by SSIS on the business intelligence end of things.

answered Sep 23 '08 at 15:44

Galwegian

41,475
16
112
158

No, sorry I responded before you mentioned you were using express. – Galwegian Sep 23 '08 at 15:49
"DTS has been replaced by SSIS on the business intelligence end of things." --- and his is quite unfortunate for everyone. – Taptronic Nov 03 '08 at 19:48

score 1 · Answer 4 · answered Sep 23 '08 at 16:11

1

Probably easiest to just do a backup in SQL 2000 and then import the backup into SQL 2005 using the restore. Those options are available in the Express Edition.

answered Sep 23 '08 at 16:11

Turnkey

9,266
3
27
36

score 0 · Answer 5 · answered Sep 23 '08 at 16:29

0

There is always the BCP option.

answered Sep 23 '08 at 16:29

Valerion

823
8
15

SQL Server 2005: Importing data from SQL Server 2000

5 Answers5

Linked