Alter instead of drop and recreate

• 
  Is this SQL Change Automation project  in VS/SSMS or are you starting in a SQL Source Control project?
  

  way0utwest October 21, 2019 17:04

  - 0 +
• 
  SSMS
  

  Cat_Bill October 21, 2019 17:05

  - 0 +
• 
  Not directly. The tools work by looking for changes, and there isn't a way to detect that this is a rename v a drop and add, at least not easily. When you import the migration script, that is the time to change this. I'd take this script:

  
  

  

  And edit it to be this:

  

  
  

  As a side note, renaming objects is an anti-pattern that you should avoid where possible. That being said, it is necessary sometimes. While SQL Prompt has a smart rename to find references and ensure things are renamed, for tables/columns, you need to manually fix the migration script.
  

  way0utwest October 21, 2019 17:28

  - 0 +

Add comment

Please sign in to leave a comment.