Database schema compare options in Visual Studio 2013 - where to set global options?

visual-studio-2013 database-project
Szymon picture Szymon · Nov 3, 2013 · Viewed 22.4k times · Source

I'm just in the middle of migrating my solutions from Visual Studio 2010 to Visual Studio 2013.

I have this (maybe) silly problem with database comparisons options. I would like to exclude certain object types from comparison globally so that I don't have to do this every time. In Visual Studio 2010 those options were available in Tools -> Options -> Database Tools -> Schema Compare.

I cannot find anything corresponding in Visual Studio 2013.

Answer

Josh M. picture Josh M. · Jul 24, 2014

Just to be clear (in case others are looking for it), the Schema Compare feature is now available for VS2013. Right-click your database project and choose "Schema Compare". Then, as Peter mentioned, you can save it and include it in your project. Not sure why it is not included by default.

Related questions

Visual Studio 2013: Database Project MSBuild error

I've got a database project as part of my solution in Visual Studio 2013. Been working perfectly for the last 3 weeks and now suddenly today it won't build and so I cannot publish any changes. I'm getting an MSBuild error: "C:\…

Read More
VS2013 Database Project fails to build

I created a new SQL Server Database Project in VS2013 (Update 3) and attempted to build but it fails. The only build output I receive follows: ------ Build started: Project: Database1, Configuration: Debug Any CPU ------ Creating a model to represent …

Read More
Visual Studio thinks correct SQL syntax is incorrect

In Visual Studio 2013, I have created a database project and imported an existing database. At first all was fine, and the project built and produced create scripts. However, now Visual Studio seems to think that there are SQL syntax errors, …

Read More