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 |
|
SamC
White Water Yakist
3467 Posts |
 Posted - 2002-07-21 : 12:16:59
|
| I've been using DTS to copy databases from our web host to my laptop for test. One constraint is the difficulty in changing the USERNAME because DTS doesn't seem to be able to convert usernames of stored proceedures on the fly. Instead, it will abort the whole copy process. Source and Destination databases MUST have the same username to make a database copy - at least the way I am copying.My workaround has been to create the scripts, replace the username in the editor, run them on the target machine to get the desired username.Is there a more direct method to get the job done in a single step using DTS or some other copy utility?Thanks,SamC |
|
|
M.E.
Aged Yak Warrior
539 Posts |
Posted - 2002-07-21 : 13:10:40
|
| Can you access backups of your database? A simple backup from their side then restore on your is the best option-----------------------Take my advice, I dare ya |
 |
|
|
SamC
White Water Yakist
3467 Posts |
Posted - 2002-07-22 : 08:37:27
|
| Thanks for your suggestion, but it may be more work to perform a restore on my laptop than a DTS copy.Getting a backup file from the remote host would involve contacting the host administrator. DTS is something I can do on my own.Probably simpler to continue use DTS and edit the stored proceedures....SamC |
|
|
|
dataphile
Yak Posting Veteran
71 Posts |
Posted - 2002-07-25 : 11:27:49
|
| Are you using the "Copy SQL server objects task"? |
|
|
|
|
|
|
Copy of Entire Database