Options

Moving columns without using migration scripts

MGibsonMGibson Posts: 15 Bronze 2
in SQL Source Control
What is the best way to move a column and preserver data without using migration scripts?
Tagged:
· Share on Twitter

Answers

  • Options
    Sergio RSergio R Posts: 610 Rose Gold 5
    If this is something that you need regularly I would advise switching to using SQL Change Automation.

    If this is something that you need infrequently then you can carry out this type of change by using a Pre or Post-Deployment script combined with a filter that excludes the table that you are changing.
    Sergio
    Product Support Engineer
    Redgate Software Ltd
    Please see our Help Center for detailed guides on how to use our tools
    · Share on Twitter
Sign In or Register to comment.