HP 3PAR System Reporter 3.1.0 Software User's Guide (QL226-96645, December 2012)

• 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
• Issuing sysbck without a begin and end date (this will extract for all data for system s138):
sysbck -dbtype oracle -dbhost istat -db cliuser -dbpwfile dbpwfile -backupfilename
"c:/test/test_20100713_1322PM" -dbouttype mysql -inservname s138 -scripttype
both
• Issuing sysbck without a begin and end date and dbouttype (Note this will extract for all
data for system s138; in this instance the extract will default to the MySQL extraction:
sysbck -dbtype oracle -dbhost istat -db cliuser -dbpwfile dbpwfile -backupfilename
"c:/test/test_20100713_1322PM" -inservname s138 -scripttype both
Extracting Data from the Database with sysbck 223