<< Copy table | IBEBlock | Data Comparer using cursors >>

Automatic database structure comparison with recompilation of triggers and procedures

 execute ibeblock
 as
 begin
   create connection MasterDB dbname 'localhost:c:\db1.fdb'
   password 'masterkey' user 'SYSDBA'
   clientlib 'fbclient.dll'; 

   create connection SubscriberDB dbname 'localhost:c:\db2.fdb'
   password 'masterkey' user 'SYSDBA'
   clientlib '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 ;

 input 'E:\CompRes.sql';

 execute ibeblock
 as
 begin
   create connection SubscriberDB dbname 'localhost:c:\db2.fdb'
   password 'masterkey' user 'SYSDBA'
   clientlib 'fbclient.dll';

   e=ibec_RecompileProcedure(SubscriberDB, '');
   e=ibec_RecompileTrigger(SubscriberDB,'')
   close connection SubscriberDB;
 end;

back to top of page
<< Copy table | IBEBlock | Data Comparer using cursors >>