Comments
Sort by recent activity
Unfortunately not. I was kind of hoping the Red Gate guys could shed some light on this issue. / comments
Unfortunately not. I was kind of hoping the Red Gate guys could shed some light on this issue.
The SQL Compare UI is much, much faster. Only taking +-2 sec. until comparison is complete.
That's why I think there is something I'm supposed to use as an option or so in the Register() method.
Here's the basic code I use:
RedGate.SQLCompare.Engine.Database ProductionDatabase = new RedGate.SQLCompare.Engine.DataBase( );
System.Data.SqlClient.SqlConnection connection = new System.Data.SqlClient.SqlConnection( "connectionString" );
System.Data.SqlClient.SqlConnectionStringBuilder connectionStringBuilder = new System.Data.SqlClient.SqlConnectionStringBuilder( connection.ConnectionString );
RedGate.SQLCompare.Engine.ConnectionProperties connectionProperties = new RedGate.SQLCompare.Engine.ConnectionProperties( connection.DataSource, connection.Database );
ProductionDatabase.Register( connectionProperties, Options.Default.Plus( Options.ForceColumnOrder ) );
and the references I added to the project:
RedGate.Shared.ComparisonInterfaces
RedGate.Shared.SQL
RedGate.SQLCompare.Engine
RedGate.Shared.Utils / comments
The SQL Compare UI is much, much faster. Only taking +-2 sec. until comparison is complete.
That's why I think there is something I'm supposed to use as an option or so in the Register() method.
He...