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 |
|
Yars
Starting Member
7 Posts |
 Posted - 2004-11-12 : 16:46:21
|
| this may be a stupid question but i haven't found an easy way to do this yet....I have SQL Server 2000 set up on my laptop just to play around with to learn. The question is, how would i move a database that i created to another machine that already has SQL Server 2000 on it. I want to move all the tables and data inside the tables.I know with Access i just have to move one database file, but i havent found anything like that with SQL Server.Thanks in advance,Yars |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-11-12 : 18:04:44
|
| You can use sp_detach_db and sp_attach_db. Check them out in SQL Server Books Online.Tara |
 |
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2004-11-12 : 18:10:38
|
| Depending on if you want the structure and data or just the structure, you might want to use SQL Compare from Red Gate.http://www.red-gate.comMichael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
|
|
|
|
|
|
SQL Deployment