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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-10-28 : 08:06:47
|
| Danko writes "I need to 'copy' a database to different server.What do you reccoment and why?a) Detach & Attach database orb) generate SQL scripts for all objects and run those scipts destinaton server" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2004-10-28 : 08:09:10
|
| If you just need to copy the structure, but not the data, then generating the scripts and running them is the fastest way. If you also need the data then detach, move, and attach is better obviously. |
 |
|
|
|
|
|
Database migration reccomendation