Is it possible to restore only the schema and stored procedures from a MS SQL database backup?

10,581

I don't think so, but you could restore it to a temporary database and then script it all from there.

Share:
10,581
B4ndt
Author by

B4ndt

Updated on June 08, 2022

Comments

  • B4ndt
    B4ndt about 2 years

    I have a full MS SQL Backup file that I would like to extract the stored procedures and schema from. Is there a way to restore only the schema definitions and stored procedures without restoring the data/table rows?

  • B4ndt
    B4ndt over 15 years
    I'm using SQL2005 and SQL Server Management Studio
  • B4ndt
    B4ndt almost 11 years
    I see that, SQL Server has been able to do that for quite a few versions now. I don't think that this answer will solve the original question though.