beautypg.com

HP 3PAR System Reporter Software User Manual

Page 229

background image

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