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 |
|
cognos79
Posting Yak Master
241 Posts |
 Posted - 2006-10-18 : 09:16:07
|
| How can I export a whole database(with all objects) from one sql server to another sql server. could anyone tell me what the steps involved to do it.Thanks... |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2006-10-18 : 09:24:30
|
| There are various options1. You can script entire database and run it on the destination server2. You can backup current database and restore on another server3. You can use DTS4. You can attach the database files on other server.Harsh AthalyeIndia."Nothing is Impossible" |
 |
|
|
cognos79
Posting Yak Master
241 Posts |
Posted - 2006-10-18 : 10:22:00
|
| Thanks... |
|
|
|
|
|
|
export a database