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

Question

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.

score 28 · Answer 1 · answered Jul 24 '14 at 13:55

28

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.

answered Jul 24 '14 at 13:55

Josh M.

26,437
24
119
200

1

Cheers. Your post helped me me finding the option. – Hamid Shahid Sep 06 '14 at 20:51

score 10 · Accepted Answer · answered Nov 04 '13 at 01:51

10

There isn't a corresponding option with the SSDT framework (what replaced DB Projects). The best you can do is save your schema compare, then include it in the project. (It doesn't get included by default, even though the file itself is saved.) That will save your options so you can easily get them back. Not as convenient in some ways, but it does work. I miss being able to set the defaults as well.

answered Nov 04 '13 at 01:51

Peter Schott

4,521
21
30

2

OK, thanks. I wonder why they got rid of that. That was very convenient. – Szymon Nov 04 '13 at 01:54
1

They're slowly working on feature parity. I think it wasn't until Dec 2012 that Data Compare was brought back. – Peter Schott Nov 04 '13 at 23:18

score 3 · Answer 3 · answered Jan 22 '16 at 10:13

Just a note that in VS2013 (Premium), you can access the tool to schema compare two databases on your network from Tools-SQL Server-New Schema Compare. No need for a project.

I went through some searching which referred to a Data menu item, which was present in earlier VS versions but not in VS2013. So hopefully this can save people some time if using VS2013

score 1 · Answer 4 · answered May 18 '16 at 21:58

1

Direct to the point:

Go to a solution > Add New Project > "SQL Server Database Project".

Now right click the project and select SCHEMA COMPARE...

answered May 18 '16 at 21:58

alansiqueira27

8,129
15
67
111

score 0 · Answer 5 · answered Jun 29 '15 at 18:29

0

on the top of each of your *.scmp file window, there is an 'options' icon. click that.

answered Jun 29 '15 at 18:29

martial

3,773
8
33
43

score -1 · Answer 6 · answered Mar 18 '14 at 09:20

-1

In VS2013 you can get rid of that on project basis, in the SQL -> Options -> Object Types, you can exclude some objects for the current Database Project.

answered Mar 18 '14 at 09:20

Daniele

1,938
16
24

This is not what I want. I want to persist the options I select and not select them every time. I stated that in my question. – Szymon Apr 09 '14 at 05:45

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

6 Answers6

Linked