Geek Answers Handbook

Visual Studio 2015 2 vs Sql Server 2016 Versions

I recently upgraded to Visual Studio 2015 Update 2, and everything went smoothly, now when I try to compare the schema from the data project with the Sql Server 2016 database, it shows that I need to create all the objects in the database, It was great before this update.

I get the following error when initializing the comparison:

An error occurred while trying to reverse-engineer elements of type Microsoft.Data.Tools.Schema.Sql.SchemaModel.SqlDatabaseCredential: Batch command during reverse engineer with error code: -2146232060 Line number: 2267 Error message: Invalid column name compression_delay. Invalid column name compression_delay.

Does anyone know what causes this problem? Thanks in advance.

+4
source share
2 answers

I'm not sure what caused this problem, but I ended up canceling all my databases, uninstalling SQL Server, and reinstalling. After that, all scripts and VS data are compared.

0
source

I had the same problem. I found an update / fix for updating VS 2015. 2. Applying the fix fixed the problem.

https://msdn.microsoft.com/en-us/library/mt695655.aspx#

0
source

More articles:


All Articles