January 11, 2021 at 9:11 pm
Hey guys, in the past there used to be an upgrade advisor for SQL Server 2016, which would do a code check, and see if anything is not compatible with the new version. Is there such a thing for SQL 2019, I can't seem to find it.
January 11, 2021 at 10:13 pm
Yep. It is called "Data Migration Assistant" and it applies to multiple SQL Server versions, not just 2019.
Something to note, it can be a bit of a resource hog if you have it analyze too many databases or too large of a database and I've had it crash on me multiple times. So I recommend doing a scan one database at a time which can be very time consuming for large databases.
Link - https://docs.microsoft.com/en-us/sql/dma/dma-overview?view=sql-server-ver15#:~:text=%20Overview%20of%20Data%20Migration%20Assistant%20%201,should%20be...%205%20See%20also.%20%20More%20
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
January 11, 2021 at 11:57 pm
Thanks for heads up. I've downloaded it, give it a test-drive tomorrow on a sandbox.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply