none
Content database deployment from SQL Server 2017 to SQL Server 2016 RRS feed

  • Question

  • Development environment configuration : Project Server 2016 + SQL Server 2017

    Staging environment configuration: Project server 2016 + SQL Server 2016

    Now I am wanted to move content database from Development instance to staging server. But as the database version is not same, how can i do the deployment of database. 

    Sunday, April 5, 2020 11:25 AM

All replies

  • The way to migrate from dev to staging is quite involved.

    First, both environments, must be at the same SharePoint CU level.

    The general process for migrating is the following

    1) Backup DEV databases and copy to STAGE

    2) Deprovision both the project server (PWA) and SharePoint web application.  Basically you are breaking it all down.

    3) restore database to STAGE SQL server

    4) Rebuild the SharePoint web application and reprovision PWA.  Basically, its all the steps you went thru when creating your STAGE environment.

    Do as much as you can using PowerShell, and then the next time it will be easier.


    Michael Wharton, Past MVP, MBA, PMP and a Great Guy <br/> Website http://www.WhartonComputer.com <br/> Blog http://MyProjectExpert.com contains my field notes and SQL queries

    Monday, April 6, 2020 1:38 AM
    Moderator
  • I migration process is clear but database version on development is higher (SQL server 2017) than database version of staging (SQL server 2016)

    How to copy the restore database. 

    Monday, April 6, 2020 4:42 AM
  • In SQL 2017 there is a Compatibility Mode that can be dropped to SQL 2016.  

    Backup on 2016 to .BAK file, copy to SQL 2017 server and then restore on SQL 2017.  

    Or you could, detach database on SQL 2016, copy database to SQL 2017 and then attach to SQL 2017.  This process requires all the databases to be closed, when means shutting down SharePoint server, etc


    Michael Wharton, Past MVP, MBA, PMP and a Great Guy <br/> Website http://www.WhartonComputer.com <br/> Blog http://MyProjectExpert.com contains my field notes and SQL queries

    Tuesday, April 7, 2020 10:57 AM
    Moderator
  • Actually, the term is "compatibility level".   However, I don't think its required for SharePoint.

    https://sqlperformance.com/2019/01/sql-performance/compatibility-levels-and-cardinality-estimation-primer


    Michael Wharton, Past MVP, MBA, PMP and a Great Guy <br/> Website http://www.WhartonComputer.com <br/> Blog http://MyProjectExpert.com contains my field notes and SQL queries

    Tuesday, April 7, 2020 11:00 AM
    Moderator