Command line scriptfile, no keys or indexes for tables
mbenson@frontporch.com
Posts: 12
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
SQLCompare /scripts1:C:\Source-Latest\RedGateScripts /scripts2:C:\Source-Previous\RedGateScripts /scriptfile:C:\Output\Upgrade.sql
Comments
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.
Redgate Software
Any update on this? I would really like to be able to use SQL Compare command line for our automated build system.
Let us know if you need anything further!
Redgate Software
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.
Kind regards,
David Atkinson
Product Manager
Red Gate Software
Product Manager
Redgate Software
It doesn't include the foreign keys in the generated upgrade script.