public void CreateAllObjects(IDatabaseSource conn, ISqlDumper dmp, ISqlDialect dialect) { var dbmem = new DatabaseStructureMembers { TableList = true, TableMembers = TableStructureMembers.AllNoRefs, DomainList = true, DomainDetails = true, SpecificObjectList = true, SpecificObjectDetails = true, LoadDependencies = true, IgnoreSystemObjects = true, }; var dbs = new DatabaseStructure(conn.InvokeLoadStructure(dbmem, null)); var props = new CreateDatabaseObjectsProps { CreateDomains = Domains, CreateFixedData = FixedData, CreateSchemata = Schemata, CreateSpecificObjects = SpecificObjects, CreateTables = Tables }; IMigrationProfile profile = dialect.CreateMigrationProfile(); dialect.MigrateDatabase(dbs, profile, null); dmp.CreateDatabaseObjects(dbs, props); }
public virtual void CreateDatabaseObjects(IDatabaseStructure db, CreateDatabaseObjectsProps props) { if (Dialect.DialectCaps.Domains && props.CreateDomains) { foreach (var domain in db.Domains) { try { CreateDomain(domain); } catch (Exception err) { ProgressInfo.RaiseErrorEx(err, "DAE-00244 " + Texts.Get("s_error_creating$domain", "domain", domain.FullName), "DOMAIN"); } } } if (Dialect.DialectCaps.MultipleSchema && props.CreateSchemata) { foreach (var schema in db.Schemata) { try { CreateSchema(schema); } catch (Exception err) { ProgressInfo.RaiseErrorEx(err, "DAE-00245 " + Texts.Get("s_error_creating$schema", "schema", schema.SchemaName), "SCHEMA"); } } } var refsToCreate = new List <IForeignKey>(); if (props.CreateTables) { foreach (var tbl in db.Tables) { ITableStructure tbl2 = tbl; if (!Dialect.DialectCaps.UncheckedReferences) { var newtbl = new TableStructure(tbl); foreach (ForeignKey fk in new List <ForeignKey>(newtbl.GetConstraints <ForeignKey>())) { newtbl._Constraints.Remove(fk); fk.SetDummyTable(tbl.FullName); refsToCreate.Add(fk); } tbl2 = newtbl; } Logging.Debug("Creating table {0}", tbl2.FullName); SetCurWork(String.Format("{0} {1}", Texts.Get("s_creating_table"), tbl2.FullName)); if (m_props.DumpWriterConfig != null && m_props.DumpWriterConfig.IncludeDropStatement) { DropTable(tbl2, DropFlags.TestIfExist); } try { CreateTable(tbl2); } catch (Exception err) { ProgressInfo.RaiseErrorEx(err, "DAE-00246 " + Texts.Get("s_error_creating$table", "table", tbl2.FullName), "TABLE"); } } } if (props.CreateFixedData) { foreach (var tbl in db.Tables) { this.UpdateData(tbl, DbDiffTool.AlterFixedData(null, tbl.FixedData, null, new DbDiffOptions()), null); } } foreach (var fk in refsToCreate) { CreateConstraint(fk); } if (props.CreateSpecificObjects) { foreach (var obj in db.GetSpecObjectsOrderByDependency()) { SetCurWork(String.Format("{0} {1}", Texts.Get("s_creating_object"), obj.ObjectName)); if (m_props.DumpWriterConfig != null && m_props.DumpWriterConfig.IncludeDropStatement) { DropSpecificObject(obj, DropFlags.TestIfExist); } try { CreateSpecificObject(obj); } catch (Exception err) { if (ProgressInfo != null) { ProgressInfo.LogMessage("s_create_object", LogLevel.Error, Texts.Get("s_error_creating_object$name", "name", obj.ObjectName) + ": " + err.Message); } Logging.Error("Error creating object:" + err.ToString()); } } } }