ssdt - Register Data-Tier Application - "Database source is not a supported version of SQL Server" error -

ssdt - Register Data-Tier Application - "Database source is not a supported version of SQL Server" error -

i have sql server express 2014 database. in ssms, whenever effort register database data-tier application, receive error "database source not supported version of sql server (localdb)\projectsv12 (microsoft.sqlserver.dac)". how resolve?

tmi:

i have ssdt project attempting write conditional scripts based on database version. instance, lookup script might like:

declare @version_source varchar(100) = (select type_version msdb.dbo.sysdac_instances database_name = db_name()); if @version_source null begin set identity_insert instructor_title on; insert instructor_title (id, name, description) values (1, 'instructor', null), (2, 'assistant professor', null), (3, 'associate professor', null), (4, 'professor', null) ; set identity_insert instructor_title off; end

when publish, check "register data-tier application" , works fine. when start debugging (which deploys (localdb)\projectsv12), logic fails. sql server express database won't register data-tier application. results in variable @version_source returning null, script status true. realize write idempotent or database state conditional script instead, sense database version conditional script best architecture decision.

you seek checking box "allow incompatible platform" can find clicking on "advanced..." button on "debug" tab of "project properties".

the other thing is: target platform? drop-down list in "project settings" tab of "project properties"? should set sql server 2014. if sql server 2014 not alternative should latest version of ssdt (though sure create scheme restore point before installing reason latest version (as of few months ago) trashed visual studio, wouldn't compile stuff, , wouldn't uninstall easily; , tips on s.o. or anywhere else vs 2013 , have 2012).

sql-server ssdt