2 min read

Recently I wrote about ignoring comments in SQL Compare. That seems like something I want to do in all my projects, so I went looking for how to set this as a default. It wasn’t obvious to me, but since I can ping the Redgate Software developers and support staff, I found an answer for this post.

If I start SQL Compare by clicking a project, it opens and my settings are there. When I start SQL Compare, it brings up the New Project dialog, shown here:

2020-12-01 10_01_10-New project_

However, if I don’t want a new project, and close that, I have a basic interface. Going through the menus, I don’t see any way to set global options.

2020-12-01 10_02_01-SQL Compare

There are Application Options, but these aren’t anything to do with projects.

2020-12-01 10_02_09-Application options

However, I realized that I missed something a support person pointed out to me. On the options tab for any project is a button that says “Save as my defaults”.

2020-12-01 10_03_55-(local)_SQL2017.SimpleTalk_1_Dev v localhost.SimpleTalk_1_Dev.scp

I can set things from any project, or I can click the “My Projects” button in the toolbar, which gives me a list of projects (I don’t save many).

2020-12-01 10_03_38-Microsoft Edge

At the bottom of this is an “edit” button, which opens the familiar project dialog. I can click Options from there and see options.

2020-12-01 10_08_22-(local)_SQL2017.SimpleTalk_1_Dev v localhost.SimpleTalk_1_Dev.scp

When I do that, I can now set the items that I care about. The Ignore Comments is one, but there a few others I think cause issues. I do want to ignore encryption objects. I shouldn’t have the same ones  in dev as prod, so I’ll check that. Others:

  • Use database compat level (likely better than server version these days)
  • Online = ON
  • Ignore identity seed and increment (this could get changed)
  • Ignore WITH ENCRYPTION

I can then click the “Save as my defaults”. This will ensure new projects have these options. If I have old projects I want to update, I can always click the “My defaults” in the project to load what I’ve saved. This animation shows how the button works.

compare_options

Now I can easily ensure that projects work as expected on my machine. Unfortunately, these defaults are stored in the registry, so this is a client by client basis, but you can ensure all your projects are set up the same by default.

SQL Compare is a fantastic product to make it easy to see what has changed in a database. If you’ve never used it, give it a try today.

The post Setting Defaults for New SQL Compare Projects appeared first on SQLServerCentral.