1 # Region/* Backup and restoration operations */
/// <Summary>
/// Backup
/// </Summary>
/// <Param name = "username"> User Name </param>
/// <Param name = "PWD"> password </param>
/// <Param name = "dbserver"> database </param>
/// <Param name = "pathname"> path </param>
/// <Param name = "databasefilename"> Backup file name </param>
/// <Param name = "appendcommand"> Backup parameter </param>
/// <Param name = "LOGNAME"> log file name </param>
/// <Returns> </returns>
Public bool backuporacledatabase (string username, string PWD, string dbserver, string pathname, string databasefilename, string appendcommand, string LOGNAME, string sqltextconfig)
{
This. sqltextfilename = pathname + "\" + sqltextconfig;
# Region/* xmlsql corner generation */
If (file. exists (sqltextfilename ))
{
File. Delete (sqltextfilename );
}
// Backup database information
Dbentity = new dbentity ();
Dbentity. dbserver = dbserver;
Dbentity. Username = username;
Dbentity. Pwd = PWD;
Writexmluserspaceconfig (dbentity );
# Endregion
// Exp userid = system/zhice @ JC full = y indexes = n grants = y rows = y compress = n file = D: \ demo. DMP log = D: \ demo. log
String loginstring = string. Format ("userid = {0}/{1} @ {2}", username, PWD, dbserver );
String filename = "exp ";
String arguments = string. format ("{0} full = y file = {1} log = {2}", loginstring, pathname + "\" + databasefilename, pathname + "\" + LOGNAME );
String backupcommand = string. Format ("{0} {1}", filename, arguments );
Try
{
System. Diagnostics. Process bakupprocess = new system. Diagnostics. Process ();
Bakupprocess. startinfo. filename = filename;
Bakupprocess. startinfo. Arguments = arguments;
Bakupprocess. Start ();
Return true;
}
Catch (exception ex)
{
System. Diagnostics. Debug. writeline (Ex );
Return false;
}
}
/// <Summary>
/// Restore
/// </Summary>
/// <Param name = "username"> User Name </param>
/// <Param name = "PWD"> password </param>
/// <Param name = "dbserver"> database </param>
/// <Param name = "pathname"> path </param>
/// <Param name = "databasefilename"> Backup file name </param>
/// <Param name = "appendcommand"> Backup parameter </param>
/// <Param name = "LOGNAME"> log file name </param>
/// <Returns> </returns>
Public bool imporacledatabase (string username, string PWD, string dbserver, string pathname, string databasefilename, string appendcommand, string LOGNAME, string sqltextconfig)
{
This. sqltextfilename = sqltextconfig;
# Region/* xmlsql corner execution */
// Backup database information
Dbentity = new dbentity ();
Dbentity. dbserver = dbserver;
Dbentity. Username = username;
Dbentity. Pwd = PWD;
If (file. exists (sqltextfilename) & sqltextfilename! = String. Empty)
{
Exeuserspacesql (dbentity );
}
# Endregion
// Imp userid = system/zhice @ JC ignore = y rows = y indexes = N full = y file = D: \ demo. dmp log = D: \ demo. Log
String loginstring = string. Format ("userid = {0}/{1} @ {2}", username, PWD, dbserver );
String filename = "Imp ";
String arguments = string. format ("{0} full = y file = {1} log = {2}", loginstring, pathname + "\" + databasefilename, pathname + "\" + LOGNAME );
String backupcommand = string. Format ("{0} {1}", filename, arguments );
Try
{
System. Diagnostics. Process bakupprocess = new system. Diagnostics. Process ();
Bakupprocess. startinfo. filename = filename;
Bakupprocess. startinfo. Arguments = arguments;
Bakupprocess. Start ();
Return true;
}
Catch (exception ex)
{
System. Diagnostics. Debug. writeline (Ex );
Return false;
}
}
# Endregion
