HP 3PAR System Reporter Software User Manual
Page 229
NOTE:
The -dbouttype parameter is optional; by default, the extract database is MySQL.
•
From MySQL to Oracle:
sysbck -dbtype mysql -dbhost istat -db cliuser -dbpwfile dbpwfile -dbouttype
oracle -scripttype both -backupfilename "c:/test/test_20100713_1322PM" -begintime
"07/13/2010 12:45:00" -endtime "07/14/2010" -inservname s074:s138
•
From MySQL to MS SQL:
sysbck -dbtype mysql -dbhost istat -db cliuser -dbpwfile dbpwfile -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 MS SQL to SQLite:
sysbck -dbtype mssql -dbhost istat -db cliuser -dbpwfile dbpwfile -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 MS SQL to MySQL:
sysbck -dbtype mssql -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 MySQL to MySQL:
sysbck -dbtype mysql -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 Oracle to SQLite:
sysbck -dbtype oracle -dbhost istat -db cliuser -dbpwfile dbpwfile -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 Oracle to MySQL:
sysbck -dbtype oracle -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 Oracle to Oracle:
sysbck -dbtype oracle -dbhost istat -db cliuser -dbpwfile dbpwfile -dbouttype
oracle -scripttype both -backupfilename "c:/test/test_20100713_1322PM" -begintime
"07/13/2010 12:45:00" -endtime "07/14/2010" -inservname s074:s138
Extracting Data from the Database with sysbck 229