disregard and don't delete items in dest db not in source ?

Gandalf · April 16, 2008 8:24PM

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 ?

Michelle T · April 17, 2008 5:29AM

There isn't an overall option for this yet (it's on our list of feature requests and I've added this forum thread to the feature request).

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'.

David Atkinson · April 17, 2008 8:24AM

Gandalf,

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

Gandalf · April 17, 2008 4:26PM

I've already followed Michelle's instructions but the problem I'm running into is that Red Gate wants to delete all the CREATE STATISTICS objects in the destination database.

It isn't placing them in the objects that exist only in the destination database section.

Gandalf · April 17, 2008 4:31PM

Is there a way I can edit the delta script generated by RedGate before it runs?

Michelle T · April 18, 2008 6:23AM

If you're using the UI, you can tell SQL Compare to run QA or SSMS with the script loaded rather than running the script itself (it's a radio button option on the last page of the synchronization wizard, and you can change which program it's trying to run from Application Options).

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.

khaihoang · January 5, 2010 2:38AM

Hi there,

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.

disregard and don't delete items in dest db not in source ?

Comments

Product Learning

Community Forums

Events & Friends

Simple Talk