How to compare development and production server database tables schema RRS feed

  • Question

  • User1052662409 posted

    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

    Tuesday, March 16, 2021 1:40 PM