Downgrade a SQL Server 2008 data base to a SQL Server 2005 instance. RRS feed

  • 問題

  • Hello everyone!!

    I am in a project that initially  was developing in a sql server 2008 instance, but then the project was changed to sql server 2005.

    I need to “downgrade” the db from 2008 to 2005.

    I check the fills and everyone are compatible between version.

    I can’t restore a simple back up from 2008 to 2005.

    Any suggestion?



    2008年10月23日 下午 04:28


  • Create database and objects with script in sql2k5 then copy data from sql2k8 to sql2k5 with data import/export wizard.


    2008年10月23日 下午 04:43