HP 3PAR StoreServ 7200 2-node HP 3PAR System Reporter 3.1.0 Software User& - Page 223
From SQLite to MS SQL
View all HP 3PAR StoreServ 7200 2-node manuals
Add to My Manuals
Save this manual to your list of manuals |
Page 223 highlights
• 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