To generate deployment scripts using Redgate SQL Compare while excluding queries about constraints a

thaoWFO24_

To generate deployment scripts using Redgate SQL Compare while excluding queries about constraints and indexes. How to do it?

DanC

Hi,

Are you asking how to generate a deployment script which will ignore constraints and indexes?

If that's the case, you can make use of the SQL Compare Options

https://documentation.red-gate.com/sc/using-the-command-line/options-used-in-the-command-line

For example there's

• Ignore system named constraint and index names

• Ignore indexes
  

• Ignore constraint and index names