public static void Main(string[] args) { try { if (!ReadSettings(args)) { Console.ReadKey(); return; } string[] tableNames = Parameters.Singleton.Tables; /*new[] { * "ce1bp01.2016", "ce1bp01.2017", "ce2bp01.2016", "ce2bp01.2017", "cobk.2016_001", "cobk.2017_001", "coep.2016_001", "coep.2017_001", * "faglflexa.2016_001", "faglflexa.2017_001", "faglflext.2016", "faglflext.2017", * "tvkot", "tvtwt", "tvkbt", "tvgrt", "t171t", "tbrct", "t179t", "t001w", "csks", "cskst", "t001", "t001b", "cska", "csku", "skat", * "cepct", "setheader", "setheadert", "setnode", "setleaf", "fagl_011pc", "fagl_011zc", "fagl_011sc", "fagl_011qt", "aufk", "mara" * };*/ IOutputWriter writer = new SingleFileWriter(Parameters.Singleton.CreateFileName, Parameters.Singleton.InsertFileName); foreach (string tableName in tableNames) { Console.WriteLine($"Processing file {tableName}"); string tableDefinition = CreateTableDefinition(tableName); string formatFile; string bulkInsert; string create; using (DataSourceFactory factory = new DataSourceFactory()) { ITableDataSource source = factory.GetDataSourceForTable(tableName); List <ColumnDefinition> colDefinition = ColumnDefinitionFactory.GetColumnDefinitionsForTable(tableDefinition) .Where(col => source.UsesColumn(col)).ToList(); List <ColumnDefinition> sourceOrderedColumnDefinitions = source.Reorder(colDefinition); CreateGenerator createGenerator = new CreateGenerator(tableDefinition, colDefinition); create = createGenerator.BuildCreate(out formatFile, source.IsQuoteEnclosed); IInsertGenerator insertGenerator = new BulkInsertGenerator(tableDefinition, source, tableName); if (source is ExcelTableDataSource) { insertGenerator = new InlineInsertGenerator(tableDefinition, source, colDefinition, sourceOrderedColumnDefinitions); } bulkInsert = insertGenerator.BuildInsert(); } writer.TableName = tableName; writer.TableDefinition = tableDefinition; writer.CreateScript = create; writer.Format = formatFile; writer.BulkInsertScript = bulkInsert; writer.Write(); } Console.WriteLine("Completed all tables successfully"); } catch (Exception e) { Console.WriteLine(e); Console.ReadKey(); } }