Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
agapimu6969
Starting Member
9 Posts |
 Posted - 2008-01-24 : 06:35:04
|
| Hi everyone,How can I only do a backup of a schema of my db?example: I have a db with four schemas (Nameschema1, Nameschema2, Nameschema3, Nameschema4 ). I only copy my Nameschema3 with its objects.Thanks. |
|
|
crever
Starting Member
7 Posts |
Posted - 2008-01-24 : 10:22:55
|
| Y, you can't. Sorry. I've been wanting that for along time too, but it's not possible. You can do it indirectly by using something like RedGate's schema compare tool or MS's tool, but there is no native backup option for schema-only backup. |
 |
|
|
agapimu6969
Starting Member
9 Posts |
Posted - 2008-01-24 : 10:37:02
|
| Thanks. I had thought to put every schema in a differente filegroup but it doesn't seem a good idea. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-24 : 23:40:28
|
| You can copy them with data export wizard. |
|
|
|
CShaw
Yak Posting Veteran
65 Posts |
Posted - 2008-01-25 : 00:17:40
|
| If you don't need the data you can script the objects via SQL Server Management Studio. But if you were to go that route I would use the Redgate tool SQL Compare.Chris Shawwww.SQLonCall.com |
|
|
|
|
|
|
Backup schema