August 15, 2017 at 10:58 am
Hello,
We are considering an upgrade from a very old version of an application to a new version of an application. The new version will have new tables, fields, and data type and length changes. Since the system has over 1300 tables and over 2200 Stored Procedures, I am looking for the best way to compare all database object differences.
Is there an easy way to contrast all database objects between two different databases?
August 15, 2017 at 11:12 am
I'm sure there are some free tools, but I recommend RedGate's SQL Compare for that task.
I used it when we were upgrading a system recently and found it to be quite beneficial.
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.
August 15, 2017 at 12:02 pm
I believe certain editions of Visual Studio have a schema comparison tool as well, I've always used the RedGate tool mentioned by BMG though.
https://www.visualstudio.com/vs/ssdt/
August 18, 2017 at 6:54 am
Try SQL idera .I used it long back. Has many features.Try evaluation.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply