MS SQL Server - Migrate database from SQL2005 to SQL 2000 (or MSDE)

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Migrate database from SQL2005 to SQL 2000 (or MSDE)

Kris

2005-07-04, 9:23 am

Hi,

Is it possible to do? (how to do it)
I've tied to do backup and thet to restore it but it hasn't work.

Regards
Kris

Mike Epprecht (SQL MVP)

2005-07-04, 9:23 am

Hi

No, the backup and data files are not compatible when going from 2005 to 2000.

You have to script the schema and data out and run it against 2000.
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

"Kris" wrote:

> Hi,
>
> Is it possible to do? (how to do it)
> I've tied to do backup and thet to restore it but it hasn't work.
>
> Regards
> Kris

Sponsored Links