disregard and don't delete items in dest db not in source ?
Gandalf
Posts: 6
How can I tell the SQL Compare not to delete items in the object sync script, when the object is in the destination db but not in the source db ?
Comments
If you're using the UI, the easiest way to do this is to group by type of difference, then right-click on the 'objects that exist only in <destination database>' heading and select 'Exclude All Objects in this Group'.
Redgate Software
Can I ask whether exactly what you are looking for here? Are you referring to the command line or the UI?
Do you want only 'new' objects to be added to the target, or do you also want 'different' objects to be synchronized?
Also, would you want this to be a global option, or something that must be set on a per-object-type basis?
Thanks,
David Atkinson
Product Manager
Red Gate Software
Product Manager
Redgate Software
It isn't placing them in the objects that exist only in the destination database section.
If you're using the command line or the API, you can write the script out to a file instead of running it directly, allowing you to modify it before running it. The command line uses the /scriptfile option to do this. Using the API there are a range of methods on an ExecutionBlock for getting the script out in a variety of formats.
The Ignore Statistics option may also help you.
Redgate Software
Regarding to the feature of "disregard and don't delete items in destination db not in source" described previously. Is there new version of SQL Data Compare which includes that feature?
I am using SQL Data Compare 7.
Thank you.