Home Forums SQL Server 2014 Administration - SQL Server 2014 Downgrading from SQL Server 2014 to SQL Server 2012 RE: Downgrading from SQL Server 2014 to SQL Server 2012

  • July 23, 2014 at 6:07 am

    #1731721

    pmscorca (7/23/2014)

    Hi,

    I need to know how I can downgrade to a SQL Server 2014 installation to SQL Server 2012.

    Thanks

    First suggestion would be to install the SQL 2012 alongside the SQL 2014, migrate the data and then remove the SQL 2014. For the migration, set the compatibility level to 2012, detach and attach to 2012 (simplified overview)

    😎