Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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

like image 855
Tom Grochowicz Avatar asked Aug 06 '08 15:08

Tom Grochowicz


2 Answers

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
like image 104
Greg Hurlman Avatar answered Sep 23 '22 13:09

Greg Hurlman


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

like image 32
Brandon Wood Avatar answered Sep 22 '22 13:09

Brandon Wood