Generate Smart Defaults, when Applicable, using SQL Management Studio

2
votes

I am currently working on a project to publish our database as a data tier application. The database is fairly complex and has required several parameters to be modified when either using SQLPackage.exe or publishing via Visual Studio.

One of the scenarios that is currently preventing me from setting my item to done is:

We have a non-nullable column being added to a table, we apply "SmartDefaults, when applicable" as true when publishing the dacpac to allow the dacpac to complete, this is working great.

What isn't working is:

When using the Upgrade Data-tier Application in SQL Management Studio. It doesn't allow me to specify the same option, which prevents the database from being upgraded correctly.

Has anyone been able to do this?

1
sql-serversql-server-data-toolsdacpacsqlpackage
What version of SQL Server Management Studio are you using? I just tried SSMS 2012 and you're right, the option isn't there. I'll see if I can install the 2014 client and see if they've added the option. - JamesQMurphy
Hi James, SSMS 2012 is the version I am using. From what I've read so far about 2014, I don't believe it will be included. I find it quite strange and it makes me think they will eventually bin SSMS if they aren't keeping up-to-date with these features. - Slavvy

1 Answers