Renaming table loses data

• 
  Hi Jeff,
  
  Thanks for your post.
  
  Regarding your query, the recommended way in SQL Source Control to avoid loss of data when renaming a table is to use a migration script.
  
  Please read the following for more detailed information:
  
  http://documentation.red-gate.com/displ ... on+scripts
  https://documentation.red-gate.com/disp ... +data+loss
  
  
  I hope this helps,

  Sergio R September 28, 2015 05:57

  - 0 +
• 
  Hi Sergio,
  
  Yes, I am looking for something like migration scripts. That would solve not only this issue but broader issues of adding new non-null columns to tables - which we do fairly frequently.
  
  However, we are using Git for source control and a shared database in our development. Will either of these be supported in V2 when it gets out of beta or other version in the foreseeable future? We need a solution we can use in our production work right away.
  
  Thank you in advance for your assistance.
  
  Jeff

  Jeff Clark September 29, 2015 13:46

  - 0 +
• 
  Hi Jeff,
  
  We are currently working on a new migration model and enhanced Git support will be one of the main features. Shared databases should continue to be supported.
  
  Thank you,

  Sergio R October 07, 2015 11:57

  - 0 +
• 
  Thanks, Sergio.
  
  I look forward to seeing what you come up with.
  
  Thanks,
  Jeff

  Jeff Clark October 14, 2015 19:06

  - 0 +

Add comment

Please sign in to leave a comment.