[dba-SQLServer] Restore SQL2000 database to SQL2008 Express

Francisco Tapia fhtapia at gmail.com
Wed Mar 2 18:42:21 CST 2011

you can always restore up, you can't restore down... that is

2000 to 2005
2000 to 2008
2005 to 2008

are all acceptable.  what you can't do is restore a newer database to an
older engine.  If you have functions or use special undocumented features in
your stored procedures you will find that these items simply do not work on
the newer engine, but so far I have not seen too many features that are
deprecated and no longer work in the newer engines, it's just frowned upon
to continue using them.

that being said, I like the features of datafields in 2008 vs those only
available in 2000 case in point varchar(max) vs using text

http://bit.ly/sqlthis   | Tsql and More...

On Wed, Mar 2, 2011 at 4:34 PM, David Emerson <newsgrps at dalyn.co.nz> wrote:

> Team,
> I can't find anything on the net about this.  Does anyone know if a
> database developed on SQL2000 can be restored on SQL2008 Express?  Are there
> any problems?
> I have a client that only has SQL2008 Express.  I already have SQL2000 and
> SQL2005 installed on my development machine but am reluctant to add another
> version.  If I can get away with developing in what I am familiar with and
> restoring to the newer version I would be a happy camper.
> Regards
> David Emerson
> Dalyn Software Ltd
> Wellington, New Zealand
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com

More information about the dba-SQLServer mailing list