SQL 2005 and SQL 2000, one Dev server, co-existence

I'm bit disappointed with lack of information about this topic. I would have thought most people will ask this question in the beginning before migrating.

Shinsoft at 2007-9-9 >

Your explanation is clear to me, however one thing isn't clear yet...

If I install only SQL 2005, can I support the SQL 2000 servers with it? e.g. Can I edit my 'old' DTS, my 'old' measures within MSAS, etc? Or do I need the SQL 2000 for these things?

Thanks in advance,
Marco.

MarcoL at 2007-9-9 >

Hello Dan,

I tried the copy database wizard between a SQL 2000 and a SQL 2005 server. I first registered the SQL 2000 on the SQL 2005 server. I could access all the tables and views.

Then I started the wizard and after a while a got the next message:

"The job failed. Check the event log on the destination server for details. (Copy Database Wizard"

In the event log I found two messages:

"Package CDW_SERVER1_SERVER2_1 failed" Event id 12291

and:

"SQL Server Scheduled Job 'CDW_SERVER1_SERVER2_1' (0x2c664338B69874418A6BE999ACBC972) - Status: Failed - Invoked on: 2005-11-11 10:05:39 - Message: The job failed. The job was invoked by User DEVELOP\Administrator. The last step to run was step 1 (CDW_SERVER1_SERVER2_1_Step)." Event id 208

So, still no database on the new server.

Any ideas?

Thanks in advance.

MarcoL at 2007-9-9 >