Template:SQWareProduction sqwora PartialRefresh.ksh presentation

From Wiki_dbSQWare
Revision as of 20:29, 16 June 2014 by BatchUser (talk | contribs) (Updated by BatchUser)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search


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