Last post Mar 16, 2021 01:53 PM by Mikesdotnetting
Mar 16, 2021 01:40 PM|demoninside9|LINK
We have converted a existing web application application from Asp.net Web forms to Asp.net MVC.
The existing web-application hosted in dedicated server and the new one we are moving to Ms Azure cloud.
On the development server we have Microsoft SQL Server 2012 - 11.0.2100.60 and in Azure cloud environment we have
Microsoft SQL Azure (RTM) - 12.0.2000.8.
In our development we have made some changes in existing tables (no of columns), procedures and datatype (columns) also we have created some new tables and procedures.
I just need that information that is there any tool or approach so that we can compare our existing tables , columns and datatype with the modified tables?
Or We have to do it manually by comparing one by one.
Mar 16, 2021 01:53 PM|Mikesdotnetting|LINK
Install/Enable SQL Server Data Tools in your Visual Studio
Note - if you didn't select the Data Storage and processing workload when you first installed, just check it and then uncheck the Azure Data Lake option. That will save you about 2GB of space and a lot of time. Unless you want to work with Azure Data Lake...
Then use them to do the comparison: