Running SQL code inside SQL Comparison SDK applications

Category: How do I?
Date: 03 Feb 2011
Product: SQL Comparison SDK
In some cases, you may want to augment the script produced by the SQL Compare or SQL Data Compare API with SQL code that you have written yourself.

SQL Comparison SDK can compare and synchronize schema and data between two instances of SQL Server, however the API is limited to executing the code produced by the API. For instance, an object called BlockExecutor can run the SQL commands contained in an ExecutionBlock object, but it cannot run a SQL statement that you have written yourself.

In order to execute these 'custom' SQL Scripts, the libraries provided by ADO .NET would be the choice for running your own SQL code. In the following example, a SqlCommand object is used to run a SQL command that will create a table in the WidgetStaging database.

[C#]
using System.Data.SqlClient;
...
CreateCommand("CREATE TABLE [test](id int, data varchar(50))", "Data Source=localhost;Initial Catalog=WidgetStaging;Integrated Security=SSPI");
...
private static void CreateCommand(string queryString,
string connectionString)
{
using (SqlConnection connection = new SqlConnection(
connectionString))
{
SqlCommand command = new SqlCommand(queryString, connection);
command.Connection.Open();
command.ExecuteNonQuery();
connection.Close();
}
}
[/C#]