sql-serverbackup

how to take sql database backup without data

Possible Duplicate:
Backup SQL Schema Only?

Anybody tell how to take sql database backup without data. i wanted to take all the tables and structures from sql server 2008. and import to another sql server 2008. i dont need the data.

Solution

  • Use "tasks" -> "Generate scripts" and choose what you want to script. Run, save to a file, open the file against the new database and run the script after changing the database name to match (if it changed)