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!