Copy data from 2000 to 2005 using Express Edition

Hi all

I am using Windows XP Prof, SP2 and having Sql Server 2000, SP4 and SQL Server 2005 Express Edition with Advanced Services SP1, and SQL Server 2005 Express Edition Toolkit SP1 installed. The toolkit is the one which created me the DTS folder in the root with this applicattion:

C:\Program Files\Microsoft SQL Server\90\DTS\Binn\DTSWizard.exe

I start now this Wizard and choose from Sql server - which is my 2000 version and to my sql express version, id/pw or windows authentication. I receive then the message:

Cannot continue for the following reason:

1) You have chosen a server that does not contain any packages.

2) The server you have chosen is neither a sql server 2000 nor sql server 7

The SSIS Migration Wizard can only load packages from those servers.

Nice. I am having Sql server 2000 and want to go to 2005.

What I am doing from ? Do I need to create some packages on Sql server 2000 to be able to proceed this task ?

Regards

Chrs

hi,

while SQL Server 2005 SSIS supports for sure older SQL Server versions, probably the DTS wizard is not supported for SQL Server 2005 scenarios, as lot of changes has occured in the metadata of SQL Server's handling...

you have to migrate your data to SQLExpress "the hard way", that's to say without designer support..

you can so use INSERT ... SELECT statements to move data from a linked SQL Server 2000 server (http://msdn2.microsoft.com/en-us/library/ms190479.aspx) or the like...

regards

|||

I finaly removed the express edition and downloaded the trial version. Here all is working fine. I will get the developer edition to test my issues and to learn more about the server. I think the express edition is really only for users with a small db and only connecting with a application, but nothing to learn or really work with.

Regards

|||

You can also just simply detach your file from SQL 2000 and then attach it to SQL 2005. The file will automatically be upgraded and you can start using it.

Mike