after i rename a column on a dev machine and i compare the structure to a production machine, sql compare generates a script to drop the old column and add a new column. my idea: add an option to sql compare to select 2 columns and say "these where the same column so you just need to rename"
DanAvni
0

Comments

2 comments

  • Linda Hawksworth
    This has already been requested by a number of customers and is logged in our tracking system. I have added your ticket number to the issue and this will be considered for a future release of SQL Compare although I cannot guarantee if/when this will be added.
    Linda Hawksworth
    0
  • David Atkinson
    DanAvni wrote:
    after i rename a column on a dev machine and i compare the structure to a production machine, sql compare generates a script to drop the old column and add a new column. my idea: add an option to sql compare to select 2 columns and say "these where the same column so you just need to rename"

    SQL Refactor has a Smart Rename feature that generates a script to rename a column. If you run this prior to SQL Compare, it should hopefully solve your issue.

    Thanks,

    David Atkinson
    Red Gate Software
    David Atkinson
    0

Add comment

Please sign in to leave a comment.