Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to save SQL Schema Compare options in VS 2012?

VS 2010 had a way to save Schema Compare options so that they will be applied to all schema compares.

VS 2012 seems to only persist the options for a single compare; once I close the window, all my options revert back to defaults.

How do I persist SQL Schema Compare options in VS 2012?

p.s. I ended up saving a Schema Comparison (.scmp) with my settings, and now I just open that file instead of creating a "New Schema Comparison". It's a shame that the feature from VS2010 did not make it to VS2012.

like image 448
roman m Avatar asked Dec 21 '12 20:12

roman m


1 Answers

Take a look at this MSDN thread:

http://social.msdn.microsoft.com/Forums/en-US/ssdt/thread/3110809b-fa51-485e-91cb-4f530f84c924

There are no global settings, but you can save a comparison as an .scmp file, which includes your comparison options. Also, if you create a Schema Compare file from the SQL menu (so it has no selected source or target), set the options you want and then save the file, you can create a template for future comparisons.

like image 94
Juan Mellado Avatar answered Sep 22 '22 15:09

Juan Mellado