Manipulate execution block

• 
  Hi Amir,
  
  As far as I am aware, you cannot make changes to the ExecutionBlock script and write it back. What you could do is to execute your own bespoke SQL code in-line with the SQL batches contained in the ExecutionBlock using a standard ADO .NET connection. Here is some sample code here that explains how to do it.

  Work w=new Work();
  bool quiet=false;
  w.BuildFromDifferences(diffs, options, true);
              if (!quiet) Console.WriteLine("Synchronizing database");
              SqlTransaction trans=null;
              int batNum = 0; // current batch number
                  conn.ChangeDatabase(databaseName);
                  cmd = conn.CreateCommand();
                  cmd.CommandTimeout = queryTimeout;
                  trans = conn.BeginTransaction(System.Data.IsolationLevel.Serializable, "MainTransaction");
                  cmd.Transaction = trans;    
  //Execute your own stuff before SQL Compare's stuff
                          cmd.CommandText = "UPDATE MyTable SET something=somethingelse";
                          cmd.ExecuteNonQuery();
                  for (batNum = 0; batNum < w.ExecutionBlock.BatchCount; batNum++)
                  {
                      Batch b=w.ExecutionBlock.GetBatch(batNum);
                      if (!b.Marker)
                      {
                          cmd.CommandText = b.Contents;
                          cmd.ExecuteNonQuery();
                      }
                      if (!quiet) Console.Write(String.Format("    \r{0}%\r", (int)((batNum / (double)w.ExecutionBlock.BatchCount) * 100)));
                  }
              trans.Commit();
              if (!quiet) Console.WriteLine("Synchronization successful");
  

  Note well: the synchronization script was produced with the option to produce transactional plumbing off, otherwise setting up the transactions using C# code will fail.

  Brian Donahue May 28, 2009 13:18

  - 0 +

Add comment

Please sign in to leave a comment.