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

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

  Michelle T April 17, 2008 05:29

  - 0 +
• 
  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

  David Atkinson April 17, 2008 08:24

  - 0 +
• 
  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 16:26

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

  Gandalf April 17, 2008 16:31

  - 0 +
• 
  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.

  Michelle T April 18, 2008 06:23

  - 0 +
• 
  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.

  khaihoang January 05, 2010 02:38

  - 0 +

Add comment

Please sign in to leave a comment.