开发者

SQL Server restore and backup per schema [duplicate]

This question already has answers here: 开发者_运维知识库 Closed 10 years ago.

Possible Duplicate:

SQL Server 2005 restore one schema only

I have a database that contains several schemas in SQL Server 2008 R2. All schemas contain the same tables. Now I want to be able to restore a backup of only one schema, while leaving the other schemas the way they are.

I'm looking for something equivalent to using pg_restore --schema="schemaname" in PostgreSQL. Is there any way I can do this in SQL Server?


MSSQL doesnt have a posibility to backup/restore only 1 schema. You can still perform partial backup of a database by grouping tables of one schema to a specific filegroup and make a filegroup backup.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜