sqlsql-serveroraclesql-server-2005backup

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

Solution

  • 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