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 |
|
eurob
Posting Yak Master
100 Posts |
 Posted - 2007-01-26 : 10:37:02
|
| How can I quickly copy a database including everything (tables,constraints,views...etc) to a different server ? I used a DTS package which is in my opinion a pain. I get so tired of all those constraint restrictions, not allowing me to just drop the tables and replace it. I wish I could just drop the whole database and create a copy from production with a simple command. I know I can go through all the tables and drop the constraints, do the DTS copy and then recreate the constraints, I was just hoping for a method to bypass that part.Any ideas ?robert |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2007-01-26 : 11:17:47
|
| backup/restore is the easiest method. I use that in conjunction with the microsoft stored procedure sp_help_revlogin to copy a database (and all logins) from one environment to another SQL environment.-ec |
 |
|
|
|
|
|
copy database across server