1
Vote

Stripped off schemas

description

While it does script the schemas - it needs to create a folder or leave the schema name in front of the table filename.
Example:
 
Schema1.Table1
Schema2.Table1
 
These are 2 different tables, the schemas DO get scripted - but the Table1 of Schema2 is the last one to be scripted and it overwrites the existing script for Table1 of schema1.
 
TIA
cmatech

comments

cmatech wrote Jul 23, 2008 at 4:29 AM

                    string FileName = Path.Combine(tables, FixUpFileName(table.Schema + "." + table.Name) + ".sql");
                    #region Table Definition
                    using (StreamWriter sw = GetStreamWriter(FileName, false))
                    {
                        if (verbose)
                            Console.WriteLine("Scripting {0}", table.Schema + "." + table.Name);
...
...etc

wrote Feb 14, 2013 at 7:14 PM