Command line scriptfile, no keys or indexes for tables

mbenson@frontporch.com

On the command line, when comparing two script folders, the script that it generates does not contain any keys or indexes for tables. Am I doing something wrong? Here is the command line I am using:

SQLCompare /scripts1:C:\Source-Latest\RedGateScripts /scripts2:C:\Source-Previous\RedGateScripts /scriptfile:C:\Output\Upgrade.sql

James B

Hi,

Just to let you know I've logged you a support ticket to look into this and make sure nothing untoward is happening; we'll contact you directly shortly.

mbenson@frontporch.com

james.billings wrote:

Hi,

Just to let you know I've logged you a support ticket to look into this and make sure nothing untoward is happening; we'll contact you directly shortly.

Any update on this? I would really like to be able to use SQL Compare command line for our automated build system.

James B

I think my colleague passed on the patch that resolved this problem while I was away.
Let us know if you need anything further!

mbenson@frontporch.com

james.billings wrote:

I think my colleague passed on the patch that resolved this problem while I was away.
Let us know if you need anything further!

Thank you. I got the latest patch (8.2.1.63) and it is working well.

Any idea when that patch will be officially released? We don't want to use it in our build system until it is official.

David Atkinson

Hopefully, there will be a SQL Compare 8.5 due out by the end of the month.

Kind regards,

David Atkinson
Product Manager
Red Gate Software

mbenson@frontporch.com

I just discovered another problem with the script compare.

It doesn't include the foreign keys in the generated upgrade script.