Ignoring Identity

Brian Donahue

Hi Michael,

If you try not including the identity column in the data comparison, the
comparison will still take place with the identity column if it is the
primary key, but it will probably skip that column when it goes to
synchronize.

Then again, the script might fail because Data Compare does a SET
IDENTITY INSERT OFF.

Regards,

Brian Donahue
Red Gate Technical Support

"Michael Clifford" <mjclifford@hotmail_nospam.com> wrote in message
news:faOIScCDEHA.1216@server53...
> I have the latest version of SQL Data Compare. The scenario is typical:
> Migrating changes from Test to Production. However, I do not need the
> Identity in the synch script and it's a pain to manually remove them in
the
> scripts.
>
> How can I get the Compare to generate scripts w/o the field and the
literal
> identity value? Please advise.
>
> Regards,
>
> Michael Clifford
>
>

Neil Davidson

Michael,

In the second screen of the comparison wizard you can access drop down a
list box in the 'columns' column. You can choose to ignore a column from
there.

Yours,

Neil
"Michael Clifford" <mjclifford@hotmail_nospam.com> wrote in message
news:c0hjM1nEEHA.2884@server53...
> Brian,
>
> <If you try not including the identity column in the data comparison>
>
> Could you please tell me how to do this? I just went through all menus
> (again) and could not find the option. Please advise.
>
> Regards,
>
> Michael
>
> ---
>
> "Brian Donahue (Red Gate)" <brian.donahue@red-gate.com> wrote in message
> news:SR43d7dDEHA.1520@server53...
> > Hi Michael,
> >
> > If you try not including the identity column in the data comparison,
> the
> > comparison will still take place with the identity column if it is the
> > primary key, but it will probably skip that column when it goes to
> > synchronize.
> >
> > Then again, the script might fail because Data Compare does a SET
> > IDENTITY INSERT OFF.
> >
> > Regards,
> >
> > Brian Donahue
> > Red Gate Technical Support
> >
> > "Michael Clifford" <mjclifford@hotmail_nospam.com> wrote in message
> > news:faOIScCDEHA.1216@server53...
> > > I have the latest version of SQL Data Compare. The scenario is
typical:
> > > Migrating changes from Test to Production. However, I do not need the
> > > Identity in the synch script and it's a pain to manually remove them
in
> > the
> > > scripts.
> > >
> > > How can I get the Compare to generate scripts w/o the field and the
> > literal
> > > identity value? Please advise.
> > >
> > > Regards,
> > >
> > > Michael Clifford
> > >
> > >
> >
> >
>
>