SQL 2000 + SQL 2005 Express Compatibility

  • Thread starter Thread starter Marcel Stoop
  • Start date Start date
M

Marcel Stoop

Hi everyone

Sofar I have used SQL 2000 developer edition. So I was pretty happy that MS
jumped on the freeware train and gave us SQL 2005 Express Server.

In my opinion it has just just the same key feature as the SQL 2000
developer edition: for developers (simple applications) to use on one single
machine.

So I was pretty convinced that it would be easy to restore a new SQL 2005
Express DB with an existing SQL 2000 DB file.
Unfortunately I was not able to do this. So you can imagine I was pretty
disapointed. This would mean, that I still have to work with the SQL 2000
developer edition. (Is that the meaning of freeware)

So my Question is, did I overlook something, and the Restoring is still
afterall possible, or is it really impossible to restore a SQL 2005 Express
DB with an existing SQL 2000 DB file, which in my opionion would be a big MS
fault.
Backward compatibility?

Thanks for the Help
Marcel
 
I had same problem moving from 2000 to 2005 EE.
I dont remember all details, but I couldnt simply attach db files
to 2005EE before explicitely detaching it from 2000
(with sp_detach command).
 
Hi

Thanks for the answer.
Could you please explaine " before explicitely detaching it from 2000".
What do i have to do, to maker it work.

Thanks
Marcel
 
I mean - execute sp_detach_db at SQL Server 2000,
copy files to 2005 EE and try to attach it to 2005 EE
 
hey, microsoft is coming out with a patch for SQL 2005 operability via
Access Data Projects; but it is 2003 only.

And i've heard it will come with a crosstab query wizard

THANK GOODNESS MICROSOFT IS FINALLY TAKING US SERIOUSLY!!
 
Back
Top