Ignore triggers and indexes

• 
  Hi,
  
  Sorry for the delay in getting back to you. There's no easy way of doing what you're asking, but I've discovered a way of achieving it by tricking the engine into thinking that the trigger is also in the source table. You need to do something like the following (this is C# but that's what I'm most familiar with)
  

  var sourceDatabase = new Database();
  var targetDatabase = new Database();
  
  sourceDatabase.Register(new ConnectionProperties("sourceServer", "sourceDatabase"), Options.Default);
  targetDatabase.Register(new ConnectionProperties("targetServer", "targetDatabase"), Options.Default);
  
  Differences differences = sourceDatabase.CompareWith(targetDatabase, Options.Default);
  
  foreach (var difference in differences)
  {
  	if (difference.Type == DifferenceType.Different && difference.DatabaseObjectType == ObjectType.Table)
  	{
  		var sourceTable = difference.ObjectIn1 as Table;
  		var targetTable = difference.ObjectIn2 as Table;
  
  		foreach (var trigger in targetTable.Triggers)
  		{
  			if (sourceTable.Triggers.Count(x => x.Name == trigger.Name) == 0)
  			{
  				sourceTable.Triggers.Add(trigger);
  			}
  		}
  	}
  }
  

  
  I think the VB code would be something like this -
  

  Dim sourceDatabase = New Database()
  Dim targetDatabase = New Database()
  sourceDatabase.Register(New ConnectionProperties("PS-ROBERTCSQL2014", "doc_breaker"), Options.Default)
  targetDatabase.Register(New ConnectionProperties("PS-ROBERTCSQL2014", "doc_breaker2"), Options.Default)
  
  Dim differences As Differences = sourceDatabase.CompareWith(targetDatabase, Options.Default)
  
  For Each difference In differences
  	If difference.Type = DifferenceType.Different AndAlso difference.DatabaseObjectType = ObjectType.Table Then
  		Dim sourceTable = TryCast(difference.ObjectIn1, Table)
  		Dim targetTable = TryCast(difference.ObjectIn2, Table)
  
  		For Each trigger In targetTable.Triggers
  			If sourceTable.Triggers.Count(Function(x) x.Name = trigger.Name) = 0 Then
  				sourceTable.Triggers.Add(trigger)
  			End If
  		Next
  	End If
  Next
  

  
  Then you can recompare sourceDatabase and targetDatabase to generate a deployment script which will no longer drop the tables. It's not an ideal way of doing things, but it seems to work.

  Rob C September 29, 2015 08:15

  - 0 +

Add comment

Please sign in to leave a comment.