locked
Restore Sql Server 2012 DB on to Sql server 2008 R2 ? RRS feed

  • Question

  • Hi, is it possible to Restore a Sql Server 2012 database on to Sql server R2 Server ?

    Thanks in Advance,
    San

    Wednesday, March 6, 2013 6:32 PM

Answers

  • it is not possible to restore a SQL Server 2012 database on SQL Server 2008 or any lower versions of SQL Server,

    additionally you can generate the script of table with database with SQL Server 2008 R2 as version and execute the script

    Seccond option

    use BCP to Export from SQL Server and Import it


    Ramesh Babu Vavilla MCTS,MSBI

    • Marked as answer by dotnetchef Wednesday, March 6, 2013 6:56 PM
    Wednesday, March 6, 2013 6:43 PM

All replies

  • it is not possible to restore a SQL Server 2012 database on SQL Server 2008 or any lower versions of SQL Server,

    additionally you can generate the script of table with database with SQL Server 2008 R2 as version and execute the script

    Seccond option

    use BCP to Export from SQL Server and Import it


    Ramesh Babu Vavilla MCTS,MSBI

    • Marked as answer by dotnetchef Wednesday, March 6, 2013 6:56 PM
    Wednesday, March 6, 2013 6:43 PM
  • Thank you Ramesh for the response.
    Wednesday, March 6, 2013 6:56 PM