Another Trigger Question

Brian Donahue

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

Brian Donahue

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