是否可以仅从 MS SQL 数据库备份中恢复架构和存储过程? [英] Is it possible to restore only the schema and stored procedures from a MS SQL database backup?

问题描述

我有一个完整的 MS SQL 备份文件，我想从中提取存储过程和架构.有没有办法在不恢复数据/表行的情况下仅恢复架构定义和存储过程?

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?

推荐答案

我不这么认为，但您可以将其恢复到临时数据库，然后从那里编写脚本.

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

这篇关于是否可以仅从 MS SQL 数据库备份中恢复架构和存储过程?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！