HP 3PAR System Reporter Software - Manual (Page 360)

11.10 Extracting Data from the Database with sysbck
3PAR System Reporter User’s Guide System Reporter 2.8
■ From SQLite to SQLite:
■ From SQLite to MySQL:
■ From SQLite to Oracle:
The following examples show how to use sysbck without any optional parameters (Note this
will extract .ins data in the mySQL format).
■ Backs up the entire database from Oracle:
sysbck -dbtype sqlite -db cliuser -dbouttype sqlite -scripttype both -
backupfilename "c:/test/test_20100713_1322PM" -begintime "07/13/2010
12:45:00" -endtime "07/14/2010" -inservname s074:s138
sysbck -dbtype Sqlite -dbhost istat -db cliuser -dbpwfile dbpwfile -
dbouttype mysql -scripttype both -backupfilename "c:/test/
test_20100713_1322PM" -begintime "07/13/2010 12:45:00" -endtime "07/14/2010"
-inservname s074:s138
sysbck -dbtype sqlite -db cliuser -dbouttype oracle -scripttype both -
backupfilename "c:/test/test_20100713_1322PM" -begintime "07/13/2010
12:45:00" -endtime "07/14/2010" -inservname s074:s138
sysbck -dbtype oracle -dbhost istat -db cliuser -dbpwfile dbpwfile -
backupfilename "c:/test/test_20100713_1322PM"