How can we help you today? How can we help you today?

Command line scriptfile, no keys or indexes for tables

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
mbenson
0

Comments

6 comments

Sort by
  • 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.
    James B
    0
  • mbenson
    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.
    mbenson
    0
  • 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!
    James B
    0
  • mbenson
    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.
    mbenson
    0
  • 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
    David Atkinson
    0
  • mbenson
    I just discovered another problem with the script compare.

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

Add comment

Please sign in to leave a comment.