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 |
|
k006b
Starting Member
10 Posts |
 Posted - 2006-02-02 : 18:10:45
|
| Transferring objects between sql servers having db created using different usernames :We have a local sql2000 db created using username abc, and another SQL2000db at a remote location where we have hosted our database. In our remotelocation the db username is ourdomain. How do we transferall objects from local db created using username abc to remote db created using ourdomain.? Is it possible to exclude usernames while transferring objects between sql servers?? Please helpK006b |
|
|
Srinika
Master Smack Fu Yak Hacker
1378 Posts |
Posted - 2006-02-02 : 19:51:08
|
| If u need only Database (tables / stored procedures / views / Functions) only to be transferred, if u want data as well, u can backup in one SQL server, and restore in the other SQL server. Then create the necessary users / roles ...If u want r not concerned about data, u can script the DB objects and run the script in any SQL Server |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
Transferring objects between sql servers