Cmdline not detecting Index changes with /project switch
RyanSchneider
Posts: 3
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:
Running without the project, but passing the same parameters that the project saved works:
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?
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?
