Home > database >  To connect two database, copy one of the database information to another, to meet a can't repea
To connect two database, copy one of the database information to another, to meet a can't repea

Time:10-20

Two databases are oracle database and SQL database
The copy button code is int li_i
Int li_j
Li_j=dw_2. Rowcount ()
If li_j=0 then
Li_j=1
End the if
Li_i=dw_1. Rowscopy (1, dw_1 rowcount (), primary! Dw_2, li_j, primary!
If li_i=1 then
Messagebox (" prompt ", "copy failed!" )
The else
MessageBox (" prompt ", "copy success!" )
End the if

The save button code is int li_i
Li_i=dw_2. The update ()
If li_i & lt; 0 then
Messagebox (" prompt ", "save failed!" )
The else
Messagebox (" prompt ", "successfully saved")
End the if
Dw_2. Retrieve ()


Now the problem is you need to set up an oracle database to the SPL data replication of information, open again when copying other information has been copied information hidden copy not to be repeated again, what is the need to add any code or keywords, solving for great god teach ~

CodePudding user response:

This is the data synchronization algorithm, suggest you add a in table form the last modified time, then according to the time synchronization, such as the last synchronization to 11:30, the next time to retrieve data is set & gt; 11:30, direct synchronization
  • Related