string ls_dmp = "DATEBASE.dmp";
string ls_log = "DATABASE.log";
string ls_name = "USRID"
string ls_pwd = "USRPWD"
string ls_tns = "TNS";
string ls_cmd = "exp "+ls_name+"/"+ls_pwd+ls_tns+" file="+ls_dmp+" log="+ls_log;
//开始创建文件
Process p = new Process();
p.StartInfo.FileName = "cmd.exe";
p.StartInfo.UseShellExecute = false;
p.StartInfo.RedirectStandardInput = true;
p.StartInfo.RedirectStandardOutput = true;
p.StartInfo.RedirectStandardError = true;
p.StartInfo.CreateNoWindow = true;
try
{
p.Start();
p.StandardInput.WriteLine(ls_cmd);
p.StandardInput.WriteLine("exit");
//string ls_ret = p.StandardOutput.ReadToEnd();

lab_ts.Text = "提示:数据库备份成功!";
Response.Write("<script>alert('"+lab_ts.Text+"');</script>");
p.Close();
}
catch(Exception err)
{
lab_ts.Text = "提示:数据库备份失败!"+err.Message;
Response.Write("<script>alert('"+lab_ts.Text+"');</script>");
}
string ls_log = "DATABASE.log";
string ls_name = "USRID"
string ls_pwd = "USRPWD"
string ls_tns = "TNS";
string ls_cmd = "exp "+ls_name+"/"+ls_pwd+ls_tns+" file="+ls_dmp+" log="+ls_log;
//开始创建文件
Process p = new Process();
p.StartInfo.FileName = "cmd.exe";
p.StartInfo.UseShellExecute = false;
p.StartInfo.RedirectStandardInput = true;
p.StartInfo.RedirectStandardOutput = true;
p.StartInfo.RedirectStandardError = true;
p.StartInfo.CreateNoWindow = true;
try
{
p.Start();
p.StandardInput.WriteLine(ls_cmd);
p.StandardInput.WriteLine("exit");
//string ls_ret = p.StandardOutput.ReadToEnd();
lab_ts.Text = "提示:数据库备份成功!";
Response.Write("<script>alert('"+lab_ts.Text+"');</script>");
p.Close();
}
catch(Exception err)
{
lab_ts.Text = "提示:数据库备份失败!"+err.Message;
Response.Write("<script>alert('"+lab_ts.Text+"');</script>");
}
本文介绍了一种通过CMD命令行工具实现数据库备份的方法。具体步骤包括设置备份文件名、日志文件名、用户名、密码及连接字符串,并构建备份命令,最后通过启动进程的方式执行该命令完成备份。
583

被折叠的 条评论
为什么被折叠?



