Perfomance Question of Red Gate API

sewuester

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:

                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 

...

Thanks,
Sewuester

richardjm

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