RedGate SQL Compare 9 command line - STATISTICS_NORECOMPUTE

Question

I can't seem to find the switch to ignore STATISTICS_NORECOMPUTE differences on PKs and INDEXES when scripting RedGate SQL Compare 9. Obviously something like /Options:ii will work but I want to compare the rest of the index.

Any ideas?

Many thanks

Brian Donahue · Accepted Answer · 2012-08-03T08:48:32.083

1

It's in project options under Ignore->STATISTICS_NORECOMPUTE property on indexes. If you don't see it you may need to upgrade. From the command line the switch is /isn

edited Aug 03 '12 at 08:48

answered Aug 02 '12 at 14:35

Brian Donahue

216
1
3

Thanks but thats through the UI. I'm looking for the scripting option. – Pixelated Aug 02 '12 at 14:37
/isn has done the trick. Many thanks! I dont know if you want to add the answer to your response and I'll mark it as correct? – Pixelated Aug 02 '12 at 14:59

RedGate SQL Compare 9 command line - STATISTICS_NORECOMPUTE

1 Answers1