Options
data comparison
Brian Donahue
Posts: 6,590 Bronze 1
Hi Richard,
Sure! You would need to change the SessionSettings enumeration to
SessionSettings.IncludeRecordsIn1. That's the same as the 'synchronize
additional records' setting in the GUI version of SQL Data Compare. If you
see this option only, it will produce a script of INSERTS to database B.
Regards,
Brian Donahue
Red Gate Technical Support
"Richard Khor" <richard.khor@tmasystems.com> wrote in message
news:SWxY$z4XEHA.2428@server53...
> I would like to compare database A and database B.
> Database A is the staging and database B is the production. Is it possible
> to only synch the data that does not exist in B but is in A and not remove
> any records that exist in B but not in A?
>
> Thanks for the help.
> Richard Khor.
>
>
Sure! You would need to change the SessionSettings enumeration to
SessionSettings.IncludeRecordsIn1. That's the same as the 'synchronize
additional records' setting in the GUI version of SQL Data Compare. If you
see this option only, it will produce a script of INSERTS to database B.
Regards,
Brian Donahue
Red Gate Technical Support
"Richard Khor" <richard.khor@tmasystems.com> wrote in message
news:SWxY$z4XEHA.2428@server53...
> I would like to compare database A and database B.
> Database A is the staging and database B is the production. Is it possible
> to only synch the data that does not exist in B but is in A and not remove
> any records that exist in B but not in A?
>
> Thanks for the help.
> Richard Khor.
>
>
This discussion has been closed.
