Change of column from Date To DateTime with change to column name fails

• 
  @duncanbatchelor
  
  I may have missed some detail but I think you could have kept the data in the table if you had written  written your script to first add the new columns, after that put the data in those new columns and only as a third step you would alter the table to add the default constraint.
  Then you could remove the old columns from both the table and the view and make the view use the new columns.

  Diogo March 12, 2019 16:32

  - 0 +
• 
  Diogo, I appreciate your response. The issue is that there should be a mapping facility during the migration process, rather than having to jump through hoops. We achieved the result, but the question was posted here to see if there is a SIMPLE way to make the required change as there is in the VS Studio database projects. Thank you for your time and consideration in posting though.

  duncanbatchelor March 13, 2019 07:44

  - 0 +
• 
  In your Compare project, you can set up a table mapping, and inside that map the source and target columns. Compare will then understand that the correct scripting behaviour is to rename the column and then change the column type (rather than doing a drop and recreate, with resulting data loss)

  Julia.Hayward March 13, 2019 14:22

  - 0 +
• 
  Thanks you Julia, but this is in Source Control rather than a Schema or Data Compare, so wanted to find an answer for Source Control changes like this. But thank you.

  duncanbatchelor March 13, 2019 14:25

  - 0 +
• 
  Hi @duncanbatchelor!
  
  I realize this would also be a workaround rather than a built-in SQL Source Control option, but I think adding a default constraint could also help.

  Jessica R March 18, 2019 23:40

  - 0 +
• 
  Hi Jessica
  
  Thank you, and as a workaround this may work. The point is a bit moot now as we have resolved this manually. It would be appropriate to have this sort of feature built in for future users though.
  
  Kind regards
  
  Duncan

  duncanbatchelor March 19, 2019 07:45

  - 0 +
• 

  Hi @duncanbatchelor,

  We have a feature request for allowing users to define a default value when attemping to add a NOT NULL column to a table, logged with reference SC-1428. There's no ETA for this as of yet, but I've +1'd it with your details.

  Thanks for your feedback!

  Jessica R March 19, 2019 17:50

  - 0 +
• 
  great .. thanks
  ______________________
  

  Desain Website

  Jasa Desain Website

  deproajah March 22, 2019 09:50

  - 0 +

Add comment

Please sign in to leave a comment.