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 |
|
Nick
Posting Yak Master
155 Posts |
 Posted - 2003-07-24 : 10:50:14
|
| Replication isn't something I have to deal with very often, so excuse me if this is a simple question. I need to create an exact copy of my database. All of the stored procedures, tables, relationships, and all. I do not want the data to be carried over to the copy though. Basically everything should be the same except the tables should all be empty.Does SQL Server 2000 offer an easy way to do this?Thanks-Nick |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-07-24 : 11:43:06
|
| You can backup and restore the database then truncate all the tables or script all the objects and run the script or use the import/export wizard to transfer objects without data==========================================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. |
 |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-07-24 : 11:53:14
|
| Right click on your db in Enterprise manager..get the menu item ALL TASKS and select script database..and select the options you want..Brett8-) |
|
|
|
|
|
|
Database Replication (sans data)