Activity overview
Latest activity by Bruno.Latte
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...
Database.Register() taking a long time
Hello,
(3th times the charm. Tried to post this earlier but it never got through)
When registering a database with default options, it takes a very long time (> 130000 ms).
Comparing a snapshot to ...
Database.Register() taking a long time
Hello,
When registering a database with default options, it takes a very long time (> 130000 ms).
Comparing a snapshot to a database with default options also takes a long time (> 10000 ms).
Is the...
Database.Register taking a long time
Hello,
When I register our database (+- 400 tables), using the Register() method with default options, it takes a long time ( > 100000 ms or time to get some coffee).
Comparing a DB to a snapshot t...