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 |
|
nightworlds
Starting Member
3 Posts |
 Posted - 2005-04-27 : 21:00:45
|
| Hi Guys!How can I copy database and all tables but not including the data? I need to copy the entire database in another server with the same database name.Thanks for advance!--nightworlds-- |
|
|
mpetanovitch
Yak Posting Veteran
52 Posts |
Posted - 2005-04-27 : 21:38:17
|
| You could Export it and choose "Copy objects and data between sql server"Right click on a table in enterprise manager, all tasks import or export.From there its a wizard and pretty easy to follow.Note: make sure you uncheck copy data.Another way would be to script the objects out. Same thing, right click on a table in EM hit all tasks, generate sql script. Pretty easy after that.Mike Petanovitch |
 |
|
|
nightworlds
Starting Member
3 Posts |
Posted - 2005-04-27 : 22:07:15
|
Thanks!It is pretty easy!  .--nightworlds-- |
|
|
|
|
|
|
Copy database and all tables