Advertisement
Guest User

Untitled

a guest
Nov 13th, 2012
49
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.58 KB | None | 0 0
  1. serverA = <server B>
  2. serverB = <server A>
  3.  
  4.  
  5.  
  6. for db in serverB
  7. // check if our db is in serverA or not
  8. if db is in serverA
  9. // attempt to transfer the data over to serverA either row by row or chunk by chunk
  10. for table in db
  11. if table is in serverA
  12. // loop over the table information and dynamically compare it to serverA
  13. if duplicate
  14. // skip
  15. else
  16. // attempt to insert
  17.  
  18. else
  19. // dump a backup schema and data of database, and directly copy it over to serverA
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement