views:

1692

answers:

4

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

A: 

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

bcwood
+3  A: 

Use a 3 step process:

  1. Generate a script from the working database
  2. Create a new database from that script
  3. Create a backup of the new database
Greg Hurlman
A: 

I make heavy use of this tool: http://www.dswsoft.com/sqlbalance.php, Unfortunately; its windows only... but works like a charm to move databases around, data or no data, merge or compare.

/mp

mauriciopastrana
A: 

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

Mark Harrison