/// <summary> /// Displays the DDL to the console /// </summary> /// <param name="Cols">A List of ProfileColumn with column name and data type information</param> static void ShowDDL(List <ProfileColumn> Cols) { string TableName = Cfg.Tbl; bool CreateAsVarchar = !Cfg.Typed; string DDLStatement = ProfileColumn.GenerateCreateTableStatement(Cols, TableName, CreateAsVarchar); Log.InformationMessage("Target table creation DDL statement:\n====================================\n{0}", DDLStatement); }
/// <summary> /// Creates the target table /// </summary> /// <param name="Cols">A List of ProfileColumn with column name and data type information</param> static void CreateTable(List <ProfileColumn> Cols) { string TableName = Cfg.Tbl; Log.InformationMessage("Creating table: {0}", TableName); bool CreateAsVarchar = !Cfg.Typed; string DDLStatement = ProfileColumn.GenerateCreateTableStatement(Cols, TableName, CreateAsVarchar); ServerUtils.ExecSql(Cfg.Server, Cfg.Db, DDLStatement); }