Settings and activity

  1. 108 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    28 comments  ·  SQL Prompt » Format SQL  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Brian Staton commented  · 

    Chiara, thank you for posting an update. In our team's case, we have multiple databases which were developed without SQL coding standards. We would like to be able to export the schema using SQL Compare (create a scripts folder), then run a command line tool to format all the files using a custom SQL Prompt style we've standardized on. Then we will update the databases using those scripts and update source control with the same scripts. That way going forward, all scripts and changes follow a standard and if we diff two files in source control, it's easy to see what's changed. If we format files as we change them, then it's not clear when you diff the files what changes are formatting changes and what changes are functional.

    I will ask our sales rep about SQP Prompt For Teams. Please contact me if you have additional questions.

    Brian Staton supported this idea  ·