Geek Answers Handbook

Registering a Data Tier Application - Error "Database source is not supported by SQL Server version"

I have a SQL Server Express 2014 database. In SSMS, whenever I try to register a database as a data-level application, I get the error "Database source is not supported by SQL Server version (localdb) \ ProjectsV12 (Microsoft.SqlServer .Dac). " How do i allow it?

TMI:

I have an SSDT project where I am trying to write conditional scripts based on the database version. For example, a search script might look like this:

DECLARE @version_source AS VARCHAR(100) = (SELECT type_version FROM msdb.dbo.sysdac_instances WHERE database_name = DB_NAME());

IF @version_source IS NULL
BEGIN
    SET IDENTITY_INSERT instructor_title ON;

    INSERT INTO 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

, " ", . ( (localdb)\ProjectsV12), . SQL Server . , @version_source NULL, script . , idempotent script, , script .

+4
1

" ", , "..." "" " ".

: ? " " " "? SQL Server 2014. SQL Server 2014 , SSDT ( - ( ) ) Visual Studio, , SO - VS 2013, 2012).

+2

More articles:


All Articles