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