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

Syntax

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

Description

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.

Parameters

Examples of usage

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);

See also:
Comparing databases using IBEBlock
Comparing scripts with IBEBlock
Extract metadata using IBEBlock
IBEBlocks

back to top of page
<< ibec_CompareTables | IBEBlock | ibec_ExtractMetadata >>