public void Act(params object[] args) { var table = _mssqlDbService.GetTable(_tableOptions.Name); table.Columns = _mssqlDbService.GetTableColumns(_tableOptions.Name); var sb = new StringBuilder(); _stringBuilderService.CreateTdsExtension(sb) .CreateServerForDb(sb, table) .CreateUserMapping(sb) .CreateSchema(sb) .DropTableIfExists(sb, table) .CreateTableScript(sb, table); var script = sb.ToString(); if (Application.Configuration.GetValue <string>("scriptsavedirectory") != null) { SaveToFile($"{Application.Configuration.GetValue<string>("scriptsavedirectory")}{_mssqlConnectOptions.Database}_{_tableOptions.Name}.sql", script); } if (Application.Configuration.GetValue <bool>("scriptshowonly")) { if (!Application.Configuration.GetValue <bool>("confirm")) { goto Exit; } Console.WriteLine(script); Console.Write("Execute script?[Y]"); var keyInfo = Console.ReadKey(); Console.WriteLine(); if (keyInfo.Key == ConsoleKey.Y) { _pgDbService.ExecuteScript(script); Console.WriteLine("Script successfull executed."); } Exit: return; } _pgDbService.ExecuteScript(script); Console.WriteLine("Script successfull executed."); }