Monday, March 12, 2012

Migrate database from SQL2005 to SQL 2000 (or MSDE)

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
KrisHi
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

No comments:

Post a Comment