none
Synch changes from SSMS back to VS database project RRS feed

  • Question

  • In a perfect world we would make all changes in a VS (azure ops) database project and commit and push all changes back to the db.  However, the world is far from perfect and this will never work for us all the time.  I need to be able to, from time to time, run a diff checker to see what's different in a database and then select specific changes to pull back to the VS db project.

    i'm running VS 2019 team system and sql server 2014

    How can this be done?

    Thank you.

    Saturday, October 19, 2019 11:34 PM

Answers

  • Adding to Erland's answer, this is the link the SQL Server Data Tools forum. The schema compare feature included with VS 2019 is available from the Tools menu (Tools-->SQL Server-->New Schema Comparison). Open your solution, launch the tool from the menu, select your dev database connection as the source, database project as the target, and click the Compare button.

    The comparison results will show the diff which you can selectively apply to the target database project as desired. Be aware that reverse engineering changes assumes your team follows processes to ensure source control is the source of truth rather than the live database.


    Dan Guzman, Data Platform MVP, http://www.dbdelta.com


    Sunday, October 20, 2019 11:24 AM

All replies

  • You should be able to use the Schema Compare feature in Visual Studio for the comparison as such, I believe. For more accurate help, you should ask in a forum dedicated to SSDT.


    Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

    Sunday, October 20, 2019 10:37 AM
  • Adding to Erland's answer, this is the link the SQL Server Data Tools forum. The schema compare feature included with VS 2019 is available from the Tools menu (Tools-->SQL Server-->New Schema Comparison). Open your solution, launch the tool from the menu, select your dev database connection as the source, database project as the target, and click the Compare button.

    The comparison results will show the diff which you can selectively apply to the target database project as desired. Be aware that reverse engineering changes assumes your team follows processes to ensure source control is the source of truth rather than the live database.


    Dan Guzman, Data Platform MVP, http://www.dbdelta.com


    Sunday, October 20, 2019 11:24 AM
  • Hi moondaddy,

     

    Thank you for your issue.

     

    If you have post your issue  in the corresponding forum  SSDT Forum ,in order to close this thread, please kindly mark helpful replies or your own reply as answers. By doing so, it will benefit all community members who are having this similar issue.  Your contribution is highly appreciated.

     

    Best Regards,

    Rachel


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Monday, October 21, 2019 2:18 AM