Thanks :) and some suggestions

Sep 27, 2007 at 3:53 AM
This is a great tool and exactly what I was looking for.
I made a few mods that you may be interested in.

  • Renato Buda
  • September 2007
  • 1. Extended properties on Primary Key only works for v9 + so added version check
  • 2. Add an Add an IF NOT EXISTS(...) DROP xxx for those objects not scripted with IF NOT EXISTS
  • These are objects with a potential for internal alteration such as procedures, views and functions
  • This does not apply to tables where it is far too dangerous to script a drop
  • 3. scriptingOptions.IncludeDatabaseRoleMemberships = true (Important for Users)
  • 4. Fixed a bug in database creation script. Should use CleanStatements(databaseStatements)
  • Change defaults (these suit me, though I believe SchemaQualify should definitely default to true):
  • outputType = OutputType.Tree
  • scriptSchemaQualify = true
  • scriptExendedProperties = true

Best Regards,
Renato Buda (renato_buda@iprimus.com.au)

(ps I posted this on the front page which was probably a mistake)
Coordinator
Sep 27, 2007 at 2:04 PM
If you'd like to upload a patch, I'll look to add your features to the next release.

Yeah... I think you're right about schema qualification, it probably should be the default. ExtProps? Yeah, that too.
Output type? Dunno, I kinda prefer console output as default... instead of creating files.

I'd certainly like to include the version check fix.
Sep 28, 2007 at 4:00 AM
Agreed to all. I posted the patch.