/// <summary> /// 还原数据库 /// </summary> /// <returns>string</returns> private string doRestore() { string bakname = IRequest.GetFormString("BackUp_File"); string bakpath = Request.MapPath("~\\App_Data") + "\\" + bakname; if (dbtype.ToLower() != "dcsqlite") { SQLDMO.Restore oRestore = new SQLDMO.RestoreClass(); SQLDMO.SQLServer oSQLServer = new SQLDMO.SQLServerClass(); try { oSQLServer.LoginSecure = false; oSQLServer.Connect(conn, dbuser, dbpwd); oRestore.Action = SQLDMO.SQLDMO_RESTORE_TYPE.SQLDMORestore_Database; oRestore.Database = dbname; oRestore.Files = bakpath; oRestore.FileNumber = 1; oRestore.ReplaceDatabase = true; oRestore.SQLRestore(oSQLServer); return("还原成功!"); } catch (Exception ex) { return(ex.Message); } finally { oSQLServer.DisConnect(); } } else if (dbtype.ToLower() == "dcsqlite") { try { string sourcename = Request.MapPath("~/app_data") + "\\DcmsDataBase.db"; File.Copy(bakpath, sourcename, true); return("还原成功!"); } catch (Exception ex) { return(ex.Message); } } return("找不到源文件"); }
/// <summary> /// 还原数据库 /// </summary> /// <returns>string</returns> private string doRestore() { string bakname = IRequest.GetFormString("BackUp_File"); string bakpath = Request.MapPath("~\\App_Data") + "\\" + bakname; if (dbtype.ToLower() != "dcsqlite") { SQLDMO.Restore oRestore = new SQLDMO.RestoreClass(); SQLDMO.SQLServer oSQLServer = new SQLDMO.SQLServerClass(); try { oSQLServer.LoginSecure = false; oSQLServer.Connect(conn, dbuser, dbpwd); oRestore.Action = SQLDMO.SQLDMO_RESTORE_TYPE.SQLDMORestore_Database; oRestore.Database = dbname; oRestore.Files = bakpath; oRestore.FileNumber = 1; oRestore.ReplaceDatabase = true; oRestore.SQLRestore(oSQLServer); return "还原成功!"; } catch (Exception ex) { return ex.Message; } finally { oSQLServer.DisConnect(); } } else if (dbtype.ToLower() == "dcsqlite") { try { string sourcename=Request.MapPath("~/app_data")+"\\DcmsDataBase.db"; File.Copy(bakpath, sourcename, true); return "还原成功!"; } catch (Exception ex) { return ex.Message; } } return "找不到源文件"; }