meta data for this page
  •  

Comparing databases using IBEBlock

  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