private void CreateBackupFile(DBDatabase database, string pathToFile)
{
var curDate = DateTime.Now;
using (var sqlFile = new StreamWriter(pathToFile))
{
sqlFile.WriteLine(database.GetCreationQuery());
sqlFile.WriteLine();
sqlFile.WriteLine($"USE [{database.Name}]");
sqlFile.WriteLine("GO");
sqlFile.WriteLine();
this.WriteSchemas(database.Schemas, sqlFile);
sqlFile.WriteLine();
this.WriteTablesCreation(database.Tables, sqlFile);
sqlFile.WriteLine();
this.WriteViews(database.Views, sqlFile);
sqlFile.WriteLine();
this.WriteSynonyms(database.Synonyms, sqlFile);
sqlFile.WriteLine();
this.WriteProcedures(database.Procedures, sqlFile);
sqlFile.WriteLine();
this.WriteFunctions(database.Functions, sqlFile);
sqlFile.WriteLine();
this.WriteSequences(database.Sequences, sqlFile);
sqlFile.WriteLine();
this.WriteTableData(database.Tables, sqlFile);
sqlFile.WriteLine();
this.WriteConstraints(database.Constraints, sqlFile);
sqlFile.WriteLine();
this.WriteTriggers(database.Tables, sqlFile);
sqlFile.WriteLine();
}
}