Triggers

Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
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

"M@" <Not@Submitted> wrote in message news:1QMhwoJoCHA.2664@server53...
> 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?
>
> M@
>
>

Comments

  • Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    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

    "M@" <Not@Submitted> wrote in message news:JzaTfiUoCHA.1152@server53...
    > 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.
    >
    > M@
    >
    > "Brian Donahue (Red Gate)" <brian.donahue@red-gate.com> wrote in message
    > news:Yu8QYAUoCHA.1428@server53...
    > > 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
    > >
    > > "M@" <Not@Submitted> wrote in message news:1QMhwoJoCHA.2664@server53...
    > > > 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?
    > > >
    > > > M@
    > > >
    > > >
    > >
    > >
    >
    >
This discussion has been closed.