What are the challenges you face when working across database platforms? Take the survey
Options

Another Trigger Question

Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
edited December 17, 2002 9:34AM in SQL Compare Previous Versions
Hi Marc,

I hate short answers, but, no, SQL Compare's migration SQL will always
include the triggers.

Regards,
Brian Donahue

"Marc Oliver" <oliver@spam-this.com> wrote in message
news:qVLl5VgoCHA.1348@server53...
> This might be related to the post from M@
>
> Question -
> Is it possible to synchronize the tables on a 'server b' with the table
> definitions on a 'server a' without replacing or removing triggers setup
on
> 'server b'?
> i.e I want to update the tables on a customers server but I don't want to
> blow away my customers trigger's they have setup.
>
> By the way we are using version 1.61 of SQL Compare
>
>

Comments

  • Options
    Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    Marc,

    I'm afraid that's the truth. Triggers are scripted with the table they
    belong to. SQL Compare does not yet have the granularity to script triggers
    on their own.

    Regards, Brian Donahue

    "Marc Oliver" <oliver@spam-this.com> wrote in message
    news:1YwaMEtoCHA.544@server53...
    > Am I understanding you correctly- If I sync a table from another server I
    > can't just update the field names and types in a table? I must also accept
    > what triggers are set on the refrence table? Is this correct?
    >
    > "Brian Donahue (Red Gate)" <brian.donahue@red-gate.com> wrote in message
    > news:UjWfL#roCHA.1888@server53...
    > > Hi Marc,
    > >
    > > I hate short answers, but, no, SQL Compare's migration SQL will
    always
    > > include the triggers.
    > >
    > > Regards,
    > > Brian Donahue
    > >
    > > "Marc Oliver" <oliver@spam-this.com> wrote in message
    > > news:qVLl5VgoCHA.1348@server53...
    > > > This might be related to the post from M@
    > > >
    > > > Question -
    > > > Is it possible to synchronize the tables on a 'server b' with the
    table
    > > > definitions on a 'server a' without replacing or removing triggers
    setup
    > > on
    > > > 'server b'?
    > > > i.e I want to update the tables on a customers server but I don't want
    > to
    > > > blow away my customers trigger's they have setup.
    > > >
    > > > By the way we are using version 1.61 of SQL Compare
    > > >
    > > >
    > >
    > >
    >
    >
This discussion has been closed.