[dba-SQLServer] Restore SQL2000 database to SQL2008 Express

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
>



More information about the dba-SQLServer mailing list