Options

Can I do this?

bcpreecebcpreece Posts: 47
edited June 28, 2007 1:39PM in SQL Compare Previous Versions
I am working on creating our Version Control and would like to have a way to use Compare 6 but have refractor layout the SQL too. Is there a way to combine these 2 operations?
· Share on Twitter

Comments

  • Options
    rszymanskirszymanski Posts: 6
    bcpreece wrote:
    I am working on creating our Version Control and would like to have a way to use Compare 6 but have refractor layout the SQL too. Is there a way to combine these 2 operations?

    I too am interested in this functionality.
    · Share on Twitter
  • Options
    bcpreecebcpreece Posts: 47
    Can someone at Red-Gate please speak to this?
    · Share on Twitter
  • Options
    Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    Hi,

    SQL Compare formats the SQL in the files being synchronized in a set way. It's not an option yet to apply any formatting options.

    SQL Refactor currently works inside Management Studio's query window. So there would need to be either a marriage between the two products, or a clever add-in that connects a .SQL file to a query window and invokes Refactor to fix the code and save it.

    It looks like a suggestion for a future version of SQL Compare!
    · Share on Twitter
  • Options
    bcpreecebcpreece Posts: 47
    Please add this to your board for Compare. It would be a huge success if we could do this with compare!
    · Share on Twitter
  • Options
    JonathanWattsJonathanWatts Posts: 418
    Hi there,

    Sorry about the delay. We will consider this for a future version of the product, but I cannot really say when this would be done.

    We are more likely to put a batch layout into SQL Refactor so that you can refactor your entire database in one shot and then use SQL Compare to synchronise this back to source control rather than combine SQL Refactor and SQL Compare.

    How does that sound?

    Regards,

    Jonathan
    Jonathan Watts

    -Project Manager
    -Red Gate Software Ltd
    · Share on Twitter
  • Options
    bcpreecebcpreece Posts: 47
    In the end all I want is to be able to refractor the whole DB. So any way you can get that done would be great!
    · Share on Twitter
  • Options
    JonathanWattsJonathanWatts Posts: 418
    Good news then, this is being "considered" for the next version of SQL Refactor. As it is a fairly popular request it has a good chance of making it, as long as it is technically possible to do this inside of SSMS.

    Regards,

    Jonathan
    Jonathan Watts

    -Project Manager
    -Red Gate Software Ltd
    · Share on Twitter
Sign In or Register to comment.