SQL Server 2005: import data from SQL Server 2000

Question

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

Or is there a way SQL Server 2005 does this?

EDIT: I am using the Express version.

EDIT: Joel's answer answers my question, but Mike's answer provides a great alternative to those of us using the express version (vote!).

Answer 1

If you use the express version of the management studio, the import and export functions are not available.

Answer 2

You can use the excellent SQL Server Database Publishing Wizard.

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

script, , , . script SQL 2000 SQL 2005.

-. , .

Answer 3

DTS SSIS -.

Answer 4

, SQL 2000, SQL 2005 . Express Edition.

Answer 5

BCP.