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 |
|
igorblackbelt
Constraint Violating Yak Guru
407 Posts |
 Posted - 2006-08-17 : 12:49:48
|
| Hello All -Is that possible to backup only the schema of my dbs ? We have a few databases that we use just for data dumps from other systems (Lotus Notes) and we would like to backup only the tables structure on those DBs, since the notes guys already have a backup procedure on the notes side, is that possbile ?Thanks in advance!---Thanks!Igor. |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-08-17 : 12:52:12
|
| Seehttp://www.nigelrivett.net/DMO/DMOScriptAllDatabases.htmlIt'll script all the tables, sps, triggers, indexes, ... from a server or databaseAthttp://www.nigelrivett.net/#DMOthere is more about scripting individual objects.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
Backing up DB schema only