data comparison

Brian DonahueBrian Donahue Posts: 6,590 New member
edited July 1, 2004 1:53PM in SQL Toolkit Previous Versions
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" <[email protected]> wrote in message
news:[email protected]
> 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.