Triggers

Brian DonahueBrian Donahue Posts: 6,590 New member
edited December 17, 2002 9:38AM in SQL Compare Previous Versions
Hi,

My name is Brian Donahue and I am a support engineer with Red Gate
Software. I believe that triggers were supported in version 1.61 and up.
There is an option to ignore/script triggers in View->Options, and again
when you select a database object in the comparison window, there is an
option to show/hide triggers in the migration SQL.

Regards,
-Brian Donahue

"[email protected]" <[email protected]> wrote in message news:[email protected]
> I am running version 1.51of SQL Compare and have been unable to find any
> options for scripting table triggers. This seems to be odd considering
that
> triggers are an important part of any large database. Am I missing
something
> or does it not handle them at all?
>
> [email protected]
>
>

Comments

  • Brian DonahueBrian Donahue Posts: 6,590 New member
    Matt,

    The comparison grid does not show differences in triggers as such.
    Different, missing, and additional triggers show up as differences in the
    table. You have to go into the details of the table to see how the triggers
    are different.

    Regards,
    Brian Donahue

    "[email protected]" <[email protected]> wrote in message news:[email protected]
    > OK. Thanks. Apparently this version does not have those options. I see the
    > "Include Triggers" in options under the Objects tab, but even when I
    check
    > it, it completely misses trigger changes. I even tried scripting it,
    > thinking that the comparison grid may just not display triggers, but it
    did
    > not script any triggers. I will download the newest evaluation and see if
    it
    > does what I need.
    >
    > [email protected]
    >
    > "Brian Donahue (Red Gate)" <[email protected]> wrote in message
    > news:[email protected]
    > > Hi,
    > >
    > > My name is Brian Donahue and I am a support engineer with Red Gate
    > > Software. I believe that triggers were supported in version 1.61 and up.
    > > There is an option to ignore/script triggers in View->Options, and again
    > > when you select a database object in the comparison window, there is an
    > > option to show/hide triggers in the migration SQL.
    > >
    > > Regards,
    > > -Brian Donahue
    > >
    > > "[email protected]" <[email protected]> wrote in message news:[email protected]
    > > > I am running version 1.51of SQL Compare and have been unable to find
    any
    > > > options for scripting table triggers. This seems to be odd considering
    > > that
    > > > triggers are an important part of any large database. Am I missing
    > > something
    > > > or does it not handle them at all?
    > > >
    > > > [email protected]
    > > >
    > > >
    > >
    > >
    >
    >
This discussion has been closed.