Backup SQL Schema Only?

Backup SQL Schema Only? "I need to create a backup of a SQL Server 2005 Database that's only the structure...no records, just the schema. Is there any way to do this? EDIT: I'm trying to create a backup file to use with old processes, so a script wouldn't work for my purposes, sorry"
Asked by: Guest \| Views: 241

Total answers/comments: 4

Comments display order:

Guest [Entry]

"Use a 3 step process:

Generate a script from the working database
Create a new database from that script
Create a backup of the new database"

Guest [Entry]

Why not just use SQL Management Studio to create a complete script of your database and the objects?

Guest [Entry]

Toad for SQL Server does this nicely, if you're considering a commercial product.

Guest [Entry]

"I make heavy use of this tool:
SQLBalance for MySQL

Unfortunately; its windows only... but works like a charm to move databases around, data or no data, merge or compare."