Is it possible to restore a SQL 2000 database backup onto a SQL 7 box?
I tried and it quite rightly complained about database structure versions are different.
Is there a way to backup SQL 2000 in such a way that only SQL 7 features are preserved? and thus can be restored on to a SQL 7 box.
The database it self is really quite simple. Just tables (plus data) and SPs.No you can't restore a 2K database onto a 7 box. You can use DTS to move data OR BCP the data out of the 2K box and into the 7 box.
No comments:
Post a Comment