David Emerson
newsgrps at dalyn.co.nz
Wed Mar 2 18:46:52 CST 2011
Thanks. At 3/03/2011, Francisco Tapia wrote: >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>http://bit.ly/sqlthis | Tsql and More... > > > > >On Wed, Mar 2, 2011 at 4:34 PM, David Emerson ><<mailto:newsgrps at dalyn.co.nz>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 ><mailto:dba-SQLServer at databaseadvisors.com>dba-SQLServer at databaseadvisors.com >http://databaseadvisors.com/mailman/listinfo/dba-sqlserver ><http://www.databaseadvisors.com>http://www.databaseadvisors.com >