What are the challenges you face when working across database platforms? Take the survey
Options

Cmdline not detecting Index changes with /project switch

RyanSchneiderRyanSchneider Posts: 3
edited January 20, 2011 1:19PM in SQL Compare Previous Versions
I have a Project setup to compare two databases. The only changes in the DB are indices.

Running the .scp from the GUI by double clicking it and hitting Compare finds the indices.

Running from the command line does not:
c:\RedGate_Projects>"c:\Program Files (x86)\Red Gate\SQL Compare 8\SQLCompare.exe" /verbose /project:*****.scp /scriptfile:out.sql /filter:*****.scpf

Running without the project, but passing the same parameters that the project saved works:
c:\RedGate_Projects>"c:\Program Files (x86)\Red Gate\SQL Compare 8\SQLCompare.exe" /verbose /scriptfile:out.sql /filter:*****.scpf /database1:***** /database2:***** /u1:**** /u2:**** /p1:***** /p2:***** /s1:****** /s2:******

I've tried this with 8.50.25.25 and 8.50.25.28. If I have other DDL changes, they are picked up, but Indices alone are not.

This is causing us major headaches as our Cruise Control nightly builds are not picking up indices. Any ideas why this isn't working?
Sign In or Register to comment.