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

•
From SQLite to SQLite:
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
•
From SQLite to MySQL:
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
•
From SQLite to MS SQL:
sysbck -dbtype sqlite -db cliuser -dbouttype mssql -scripttype both -backupfilename
"c:/test/test_20100713_1322PM" -begintime "07/13/2010 12:45:00" -endtime
"07/14/2010" -inservname s074:s138
•
From SQLite to Oracle:
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
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 oracle -dbhost istat -db cliuser -dbpwfile dbpwfile -backupfilename
"c:/test/test_20100713_1322PM"
•
Backs up the entire database from MySQL:
sysbck -dbtype mysql -dbhost istat -db cliuser -dbpwfile dbpwfile -backupfilename
"c:/test/test_20100713_1322PM"
•
Backs up the entire database from SQLite:
sysbck -dbtype sqlite -dbhost istat -db cliuser -dbpwfile dbpwfile -backupfilename
"c:/test/test_20100713_1322PM"
•
Issuing sysbck without a system name (this will extract for all systems for the period July 13
2010 till July 14th 2010 00:00:00):
sysbck -dbtype oracle -dbhost istat -db cliuser -dbpwfile dbpwfile -backupfilename
"c:/test/test_20100713_1322PM" -dbouttype mysql -begintime "07/13/2010" -endtime
"07/14/2010" -inservname s074:s138 -scripttype both
230 Troubleshooting System Reporter