Template:SQWareProduction sqwora PartialRefresh.ksh presentation: Difference between revisions

From Wiki_dbSQWare
Jump to navigation Jump to search
Exploit (talk | contribs)
m Updated by Expdbtools
 
m Updated by BatchUser
Line 2: Line 2:
<br>Actions:
<br>Actions:
* Makes export of distant tables to refresh by ssh (list contained in a file)
* Makes export of distant tables to refresh by ssh (list contained in a file)
* Retrieve dump file by scp
* Retrieve Dump file by scp
* Drop tables to refresh
* Drop tables to refresh
* Makes import
* Makes import
Line 8: Line 8:
* change of unix users target/source
* change of unix users target/source
* send email report of refresh
* send email report of refresh
* run shell script after load
* run shell script after Load

Revision as of 18:46, 5 April 2014


Refresh of a tables list for one schema by exp/imp
Actions:

  • Makes export of distant tables to refresh by ssh (list contained in a file)
  • Retrieve Dump file by scp
  • Drop tables to refresh
  • Makes import


The script can also:

  • change of unix users target/source
  • send email report of refresh
  • run shell script after Load