databasescripting

SQL Server create/update database script

In MS SQL Server 2005, how can I create a script consisting off all the objects in the database (tables, stored procedures, views)? I want to use the script to create the database using SMO or to update its objects (alter, drop) if they already exist. I know about the scripting feature in SQL Server Management Studio, I am however not fa...

Looking for a good "create" database scripting tool (not diff scripting)

I'm looking for a db script tool which can do the following: Create "create-scripts" for each table in the database and place them in separate files. Note: these files should not contain relational constraints. Create scripts for relational constraints (as one file or many, doesn't matter) Create insert scripts for populating tables. ...