0

I need to run the upgrade advisor before migration, so my question is where to Run the upgrade advisor ? In the old server or after restoring the DB in new server ?

As I am new to migration so need help and what all things I should take care for Migration and step by step process would be helpful.

Improve this question
1
  • We're going to need a lot more information. You will run the upgrade advisor on the new server after you restore the old database to it and it upgrades it. This won't change your DB Engine level though. Please update with all the info that would be helpful, such as what the acceptable downtime is, what the acceptable data loss is, if we have a maintenance window, what the app is used for, how many databases there are, etc. Otherwise this is a simple google search for "SQL Upgrade checklist". Thomas LaRock has a pretty thorough one but it won't help you with the actual failover. Commented Aug 24, 2016 at 19:20

1 Answer 1

Reset to default
2

You can run upgrade advisor 2014 on a backup of your current to-be-migrated database which in your case is sql server 2008R2.

I have written detailed steps on migration here.

PowerShell based start-sqlmigration is what I highly recommend (I am using it quiet often to migrate server instances to new server) when you have to migrate your entire server instance.

e.g.

Start-SqlMigration -Source sql2008R2 -Destination sql2014 -BackupRestore -NetworkShare \nas\sql\migration

Make sure that the sql server service account has proper permissions on the NetworkShare

enter image description here

Improve this answer
0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.