Equivalent to sqlpackage option
Rjb23
Posts: 6
Hi,
I'm using the comparison sdk to generate a change script from a dacpac, and would really like to be able to have default values generated if no default value is specified on a non null column, the option in sql package is GenerateSmartDefaults. Is there an option in the comparison sdk that is equivalent to this?
I'm using the comparison sdk to generate a change script from a dacpac, and would really like to be able to have default values generated if no default value is specified on a non null column, the option in sql package is GenerateSmartDefaults. Is there an option in the comparison sdk that is equivalent to this?
Comments
Unfortunately we don't have an option to do this at the moment. If this is something you'd like to see then I recommend you vote for this request on our UserVoice site and add any comments that you wish to add - https://redgate.uservoice.com/forums/14 ... on-null-fi
Sorry.
Redgate Software
I have a follow up question though, maybe I should start a new topic for it but here goes. I am seeing once I unpack the dacpac and do a compare and deployment that the comments are missing out of the changes, I have checked to make sure that IgnoreComments is not checked. Any ideas why this may be?