Competition: What’s your favorite Redgate tool? Enter now.

Another Trigger Question

Brian DonahueBrian Donahue Posts: 6,590 New member
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" <[email protected]> wrote in message
news:[email protected]
> This might be related to the post from [email protected]
>
> 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

  • Brian DonahueBrian Donahue Posts: 6,590 New member
    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" <[email protected]> wrote in message
    news:[email protected]
    > 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)" <[email protected]> wrote in message
    > news:UjWfL#[email protected]
    > > Hi Marc,
    > >
    > > I hate short answers, but, no, SQL Compare's migration SQL will
    always
    > > include the triggers.
    > >
    > > Regards,
    > > Brian Donahue
    > >
    > > "Marc Oliver" <[email protected]> wrote in message
    > > news:[email protected]
    > > > This might be related to the post from [email protected]
    > > >
    > > > 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.