c# - Unable to compare database schema using SSDT Visual studio 2012 "Unable to determine the database platform type. The database may be unavailable.." -


i have created database project in visual studio 2012 version 11.0.60610.01 update 3. using database project comparing , publishing database on sql server 2008 r2 version 10.50.4000.0

my database project target platform set sql server 2008.

my ssdt version 11.1.20627.00

now sql server version upgraded sql sever 2012 version 12.0.2000.8

after changed database project target platform sql server 2012.

but not allowing me compare database schema or publish database.

it throws following error

error 345 validation error in target: db_name unable determine database platform type. database may unavailable..

i have checked edit connection wizard using test connection button database connection successful.

can please me on this? there more configuration need set changing database platform type?

version 12.0.2000.8 of sql server means you're on sql server 2014. it's confusing sql server 2012 == version 11, sql server 2014 == version 12.

to resolve this, please update sql server tooling in visual studio 2012 sql server 2014 compatible per instructions here. vs2012 sql server updates aren't built-in, happily vs2013 onwards updates show automatically through visual studio update mechanism.


Comments

Popular posts from this blog

google api - Incomplete response from Gmail API threads.list -

Installing Android SQLite Asset Helper -

Qt Creator - Searching files with Locator including folder -