How to make Sql Compare find differences in view definitions

• 
  Hi @CCdbs
  
  In order to view the data type differences, you would need to compare the original tables. 
  
  This is because a view is basically a select statement from a table and the columns are defined in the table, not in the view.
  
  

  DanC September 08, 2021 15:07

  - 0 +
• 
  Hi Dan
  Thank you for your answer, but my tables are alike. The problem occurs when you change the datatype of a column and refreshes the view in one db, when you compare the db to another db only the changes on the table is found! So I would like en option in Sql Compare saying "Compare view metadata"

  CCdbs September 10, 2021 08:16

  - 0 +
• 
  Hi @CCdbs
  
  In that case this would be a feature request and so I would advise posting the idea on the UserVoice here: https://redgate.uservoice.com/forums/141379-sql-compare

  DanC September 10, 2021 08:39

  - 0 +
• 
  Hi @CCdbs
  
  The view will not appear has different as the DDL for the view is unchanged.  Run the deployment process, remember to check the option to include dependencies and the deployment script will include the EXEC sp_refreshview to update the view.
  
  Many Thanks
  Eddie

  Eddie D September 10, 2021 14:23

  - 0 +
• 
  Hi @Eddie D
  Thanks, i will remeber to use "include dependencies" when ever it is possible.

  CCdbs September 17, 2021 09:51

  - 0 +

Add comment

Please sign in to leave a comment.