Options within a project - how to use them globally?
PBuxton
Posts: 3 New member
in SQL Compare
I commonly need to ignore constraint names, extended properties...
Unless I missed it, It doesn't seem that I can set these to be remembered OUTSIDE of a project as a global setting?.
Unless I missed it, It doesn't seem that I can set these to be remembered OUTSIDE of a project as a global setting?.
Tagged:
Answers
Hi Paul
Unfortunately, SQL Compare does not provide a global setting to remember the ignored constraint names or extended properties outside of a project.
However, you can create a project file in SQL Compare and save the settings for ignored constraint names and extended properties within that project. This will allow you to reuse the same settings in future comparisons without having to manually configure them each time.
To create a project file, simply open SQL Compare and select "File" > "New Project". Then, choose your source and target databases, and configure the options as desired, including the ignored constraint names and extended properties. Once you have configured the project, save it as a project file for future use. You can open the project file and run a comparison to use the same settings. Hopefully this will save you time and effort in manually configuring the options each time you run a comparison.
Appreciate this isn't exactly the solution you were asking for, if this isn't sufficient for you I would suggest raising this request on the UserVoice site, votes on these suggestions can help prioritise future features!
Tom Claringbold | Redgate Software
Have you visited our Help Center?