Migrate SQL Server to new Server

• 89netanel

  SSCrazy

  Points: 2130

  More actions

  November 1, 2017 at 4:01 am

  #409740

  Hello All,
  I would like to upgrade my SQL Server 2012 to SQL Server 2016.
  I created new machine and i would like to backup all the Databases and restore them on the new machine.
  I will use sp_help_revlogin in order to export and import the logins.
  In the end of the process i will change the Application connection string to the new machine name.

  My question is - what is the order of this process?
  Should i export and import the logins with sp_help_revlogin first and then to restore the databases?
  or should i restore the databases first and only than to  export and import the logins with sp_help_revlogin?

  Can you please advise?

  Thanks in advance!

• NorthernSoul

  SSCertifiable

  Points: 6869

  More actions

  November 1, 2017 at 4:23 am

  #1966144

  Duplicate post:

  https://www.sqlservercentral.com/Forums/1905528/Migrate-SQL-Server-to-new-server