March 11, 2009
Eleven steps to script your SQL Server database schema…
This would apply to MS SQL Server 2005 Express and MS SQL Server 2008 Express and other versions (but I’ve not tested it on them). The process shows generation of a script that helps you duplicate an entire database structure either on a local system or on one hosted elsewhere.
This comes in handy if you’d like to move an entire database schema from one server to another and later import data using the DTS Wizard (dts wizard usage is not covered here). The good thing about scripting a database this way is that all table identities are maintained and you get an exact replica of your schema.
The following are self explanatory screen shots that will take you through the process. I created them on MS SQL Server 2008 Express.
