update script does not contain FK

Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
"HVE" <eylenh@hotmail.com> wrote in message
news:9ntc6b9q5ktz$.q0vpbcknc53r.dlg@40tude.net...
> Hi,
>
> it looks like SDC forgets to take FK constraints into account when
> synchronizing tables on two servers. The following is part of the proposed
> script :
>
> Note that this script will carry out all DELETE commands for all tables
> first, then all the UPDATES and then all the INSERTS
> It will disable foreign key constraints at the beginning of the script,
and
> re-enable them at the end
> */
> SET XACT_ABORT ON
> SET ARITHABORT ON
> GO
> -- Pointer used for text / image updates. This might not be needed, but is
> declared here just in case
> DECLARE @ptrval binary(16)
>
> BEGIN TRANSACTION
> DELETE FROM .....
>
> It references the FK constraints, but they are not in there.
> small bug?
>
> Best Regards
>
> Hans

Comments

  • Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    Hi Hans,

    When Data Compare generates a SQL script for one table, it does not take
    into consideration a foreign key constraint imposed on it by another table.
    For instance, if I want to migrate table A, which has an FK constraint
    referencing it from table B, Data Compare will only add the ALTER TABLE
    NOCHECK CONSTRAINT if I am scripting table A and B together. If I select
    only table A for migration, the script will not disable the foreign key and
    a failure might happen running the script.

    Yours,

    Brian Donahue
    Red Gate Technical Support

    "HVE" <eylenh@hotmail.com> wrote in message
    news:9ntc6b9q5ktz$.q0vpbcknc53r.dlg@40tude.net...
    > Hi,
    >
    > it looks like SDC forgets to take FK constraints into account when
    > synchronizing tables on two servers. The following is part of the proposed
    > script :
    >
    > Note that this script will carry out all DELETE commands for all tables
    > first, then all the UPDATES and then all the INSERTS
    > It will disable foreign key constraints at the beginning of the script,
    and
    > re-enable them at the end
    > */
    > SET XACT_ABORT ON
    > SET ARITHABORT ON
    > GO
    > -- Pointer used for text / image updates. This might not be needed, but is
    > declared here just in case
    > DECLARE @ptrval binary(16)
    >
    > BEGIN TRANSACTION
    > DELETE FROM .....
    >
    > It references the FK constraints, but they are not in there.
    > small bug?
    >
    > Best Regards
    >
    > Hans
This discussion has been closed.