We are excited to announce that the ASP.NET Forums are moving to the new Microsoft Q&A experience. Learn more >
How to compare development and production server database tables schema[Answered]
1 reply
Last post Mar 16, 2021 01:53 PM by Mikesdotnetting
Participant
1446 Points
2839 Posts
How to compare development and production server database tables schema
Mar 16, 2021 01:40 PM|demoninside9|LINK
Hello Everyone,
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.
Kindly suggest
Thank you
All-Star
194850 Points
28099 Posts
Moderator
Re: How to compare development and production server database tables schema
Mar 16, 2021 01:53 PM|Mikesdotnetting|LINK
Install/Enable SQL Server Data Tools in your Visual Studio
https://docs.microsoft.com/en-us/sql/ssdt/download-sql-server-data-tools-ssdt?view=sql-server-ver15
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:
https://docs.microsoft.com/en-us/sql/ssdt/how-to-use-schema-compare-to-compare-different-database-definitions?view=sql-server-ver15