static OneDriveForBusinessBackend CrearConexionOneDrive() { var servidor = ConfigurationManager.AppSettings["Servidor"]; // "odb4://[]-my.sharepoint.com"; var rutaEnElServidor = ConfigurationManager.AppSettings["RutaEnElServidor"]; // "personal/[]_[]/Documents/duplicati"; var username = ConfigurationManager.AppSettings["Username"]; // ""; var password = ConfigurationManager.AppSettings["Password"]; // ""; var url = $"{servidor}/{rutaEnElServidor}"; //?auth-username={username}&auth-password={password}"; var options = new Dictionary <string, string>(); options.Add("auth-username", username); options.Add("auth-password", password); var server = new OneDriveForBusinessBackend(url, options); return(server); }
static void DoIt(OneDriveForBusinessBackend backend) { var connectionString = ConfigurationManager.ConnectionStrings["ConnString"].ConnectionString; // read backup folder from config file ("C:/temp/") var tempBackupfolder = System.IO.Directory.GetCurrentDirectory() + System.IO.Path.DirectorySeparatorChar.ToString(); var backupFolder = ConfigurationManager.AppSettings["BackupFolder"]; var sqlConStrBuilder = new SqlConnectionStringBuilder(connectionString); // set backupfilename (you will get something like: "C:/temp/MyDatabase-2013-12-07.bak") var tempBackupFileName = String.Format("{0}{1}-{2}.bak", tempBackupfolder, sqlConStrBuilder.InitialCatalog, DateTime.Now.ToString("yyyyMMdd-HHmmss")); Console.WriteLine("Creando backup desde la BD..."); using (var connection = new SqlConnection(sqlConStrBuilder.ConnectionString)) { var query = String.Format("BACKUP DATABASE {0} TO DISK='{1}'", sqlConStrBuilder.InitialCatalog, tempBackupFileName); using (var command = new SqlCommand(query, connection)) { connection.Open(); command.ExecuteNonQuery(); } } Console.WriteLine("bak file creado {0}", tempBackupFileName); Console.WriteLine("comprimiendo..."); var tmpZipfile = string.Format("{0}.zip", tempBackupFileName); using (ZipArchive zip = ZipFile.Open(tmpZipfile, ZipArchiveMode.Create)) { zip.CreateEntryFromFile(tempBackupFileName, System.IO.Path.GetFileName(tempBackupFileName)); } Console.WriteLine("zip file creado {0}", tmpZipfile); Console.WriteLine("borrando bak file"); System.IO.File.Delete(tempBackupFileName); Console.WriteLine("bak file borrado {0}", tempBackupFileName); // try { Console.WriteLine("subiendo {0}", tmpZipfile); backend.Put(System.IO.Path.GetFileName(tmpZipfile), tmpZipfile); } catch (Exception ex) { Console.WriteLine(ex.Message); } // var backupFileName = String.Format("{0}{1}-{2}.bak", backupFolder, sqlConStrBuilder.InitialCatalog, DateTime.Now.ToString("yyyyMMdd-HHmmss")); var zipfile = string.Format("{0}.zip", backupFileName); // movi Console.WriteLine("moviendo el zip file {0} : {1} ", tmpZipfile, zipfile); System.IO.File.Move(tmpZipfile, zipfile); Console.WriteLine("Fin"); }