Perfomance Question of Red Gate API

Forum for users of SQL Toolkit 3,4,and 5

Perfomance Question of Red Gate API

Postby sewuester » Mon Nov 05, 2007 2:54 pm

Hello,

I am working on a project wich is supposed to compare a few tables. On server 1 we have ca. 1500 tables and on server 2 we have 20. It takes a lot of time to register the server. Is there a possibility to speed this process up?

A part of my code:

[code]
Database db1 = new Database();
Database db2 = new Database();
TableMappings mappings = new TableMappings();
EngineDataCompareOptions test = new EngineDataCompareOptions(MappingOptions.None, ComparisonOptions.None, SqlOptions.None);
SqlProvider provider = new SqlProvider();

using (session = new ComparisonSession())
{
try
{
BlockExecutor rbxBlock = new BlockExecutor();
session.Options = mappings.Options;
mappings.FromOne("In1");
db1.RegisterForDataCompare(new ConnectionProperties(remoteServer, remoteDatabase,"user","password"));
db2.RegisterForDataCompare(new ConnectionProperties(mainServer, mainDatabase, "user", "password"));
// Create the mappings between a certain table
[/code]
...

Thanks,
Sewuester
sewuester
 
Posts: 1
Joined: Mon Nov 05, 2007 2:36 pm

Postby richardjm » Tue Nov 06, 2007 10:17 am

No, the registration is an atomic process and can't be broken up. We need all of the data about all the tables to create accurate dependency information so we know in which order we can use the tables.

HTH
Richard Mitchell
Project Manager
Red Gate Software Ltd
richardjm
 
Posts: 395
Joined: Fri May 20, 2005 9:44 am
Location: Red Gate Software Ltd


Return to SQL Toolkit Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests