ibec_CompareMetadata

Compares the metadata of specified databases and creates a script of all discrepancies.

This function compares the metadata of two databases (or scripts) and creates a discrepancy script.

Note: Object filtering was implemented in IBExpert version 2020.02.13. To exclude some database objects from the comparison it is necessary to process them in the callback block. For example see the IBEBlock page in the Database Comparer form.

 function ibec_CompareMetadata(MasterDB : variant; SubscriberDB :variant;
                             ScriptFile : string; Options : string;
                             CallbackBlock : variant) : string;

1. Comparing databases:

 execute ibeblock
 as
 begin
    create connection MasterDB dbname 'localhost:c:\MasterDB.fdb'
    password 'masterkey' user 'SYSDBA'
    clientlib 'C:\Program Files\Firebird\bin\fbclient.dll';

    create connection SubscriberDB dbname 'localhost:c:\SubscriberDB.fdb'
    password 'masterkey' user 'SYSDBA'
    sql_dialect 3
    clientlib 'C:\Program Files\Firebird\bin\fbclient.dll';


    cbb = 'execute ibeblock (LogMessage variant)
           as
           begin
             ibec_progress(LogMessage);
           end';

    ibec_CompareMetadata(MasterDB, SubscriberDB, 'E:\CompRes.sql', 'OmitDescriptions; OmitGrants', cbb);

    close connection MasterDB;
    close connection SubscriberDB;
 end
 

2. Comparing scripts:

 execute ibeblock
 as
 begin
   cbb = 'execute ibeblock (LogMessage variant)
          as
          begin
            ibec_progress(LogMessage);
          end';

   ibec_CompareMetadata('c:\myscripts\master.sql','c:\myscripts\subscriber.sql', 'E:\CompRes.sql','', cbb);
 end

3. Using the ServerVersion parameter:

 ibec_CompareMetadata(MasterDB, 
                      SubscriberDB, 
                      'E:\CompRes.sql', 
                      'OmitDescriptions; OmitGrants; ServerVersion=FB1x;', 
                      cbb);