Red Gate forums :: View topic - Perfomance Question of Red Gate API
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Toolkit Previous Versions
SQL Toolkit Previous Versions forum

Perfomance Question of Red Gate API

Search in SQL Toolkit Previous Versions forum
Post new topic   Reply to topic
Jump to:  
Author Message
sewuester



Joined: 05 Nov 2007
Posts: 1

PostPosted: Mon Nov 05, 2007 2:54 pm    Post subject: Perfomance Question of Red Gate API Reply with quote

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
Back to top
View user's profile Send private message
richardjm



Joined: 20 May 2005
Posts: 359
Location: Red Gate Software Ltd

PostPosted: Tue Nov 06, 2007 10:17 am    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group