2 Replies Latest reply on Apr 5, 2018 3:36 AM by [email protected]

    SQL Database Server Collation

    Thomas.Ebrecht@verdi.de Rookie

      We want to move our DSM-.Database (CMDB and Discovery) to a new Server. The old one ist a SQL server 2012, the new one ist SQL-Server 2016.

       

      On the SQL-Server 2012 there isthe folloing collation: SQL_Latin1_General_CP1_CI_AS, the Standard on a SQL-Server 2016 is Latin 1_General_CI_AS.

       

      What is the correct way to move the databases? Is backup and recovery the right way? Are the different collations a Problem?

       

      Thanks al lot.