Skip to content
← SQL Compare

How can we improve SQL Compare?

SQL Compare

Categories

JUMP TO ANOTHER FORUM

(thinking…)

Add "use <<Database>>" as an option for the sql

It would help to have "use <<database>", where <<database>> is the db where you intend to load the sql appear in the object sync script

1 vote
Vote

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
You have left! (?) (thinking…)
Anonymous shared this idea  ·   ·  Report…  ·  Admin →
completed  ·  Anonymous responded  · 

We already have an option for this: If you look at the Project Options and choose “Add USE statement” that should do the job!

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • philcart commented  ·   ·  Report

    David,

    This is primarily for quick hotfix type changes of which we run through several each day.

    At the moment I'm using powershell to pull changed files from TFS, then calling SQL Compare to perform a compare and generate a change script.

    This script is then used to deploy the changes to TEST, UAT and eventually Production environments. For TEST and UAT, we can supply an additional flag for the change script to be executed immediately.

    Cheers
    Phil

  • philcart commented  ·   ·  Report

    Is there any chance of getting this option via the command line?

  • Mary Hamlin commented  ·   ·  Report

    This isn't available through the SQL Compare command line, only through the SQL Compare gui.