Tables missing after data sync
Brian Donahue
Posts: 6,590 Bronze 1
Hi Jordan,
There isn't any code in Data Compare that would delete a table -- even
if by accident. All that Data Compare can do is to insert, update, and
delete data. It can also drop and re enable foreign keys, primary keys, and
identity inserts.
How did you come to the conclusion that the tables got dropped? Were
they not listed in the table list the next time you started Data Compare
after a data synchronization? In that case, it's possible that the primary
key got dropped by Data Compare and not re-added. If primary keys don't
exist on both tables, they will not be visible in the 'choose tables'
wizard's table list.
Regards,
Brian Donahue
Red Gate Technical Support
"jordan paw" <jpaw@careplus.net> wrote in message
news:Ii5$Jj0fEHA.2312@server53...
> i'm not sure what to make of this but after synchronizing 2 databases
where
> the destination db has 6 more tables, it seems like the 6 tables in the
> destination got deleted.
> is this possible?
>
>
There isn't any code in Data Compare that would delete a table -- even
if by accident. All that Data Compare can do is to insert, update, and
delete data. It can also drop and re enable foreign keys, primary keys, and
identity inserts.
How did you come to the conclusion that the tables got dropped? Were
they not listed in the table list the next time you started Data Compare
after a data synchronization? In that case, it's possible that the primary
key got dropped by Data Compare and not re-added. If primary keys don't
exist on both tables, they will not be visible in the 'choose tables'
wizard's table list.
Regards,
Brian Donahue
Red Gate Technical Support
"jordan paw" <jpaw@careplus.net> wrote in message
news:Ii5$Jj0fEHA.2312@server53...
> i'm not sure what to make of this but after synchronizing 2 databases
where
> the destination db has 6 more tables, it seems like the 6 tables in the
> destination got deleted.
> is this possible?
>
>
This discussion has been closed.
