| Author |
Topic |
|
nitin1353
Constraint Violating Yak Guru
381 Posts |
 Posted - 2006-04-19 : 13:50:23
|
| GurusCan you please tell me what all options do we have in which we can transfer datas between servers or how can we transfer databases between servers.I dnt want to use backup and restore and Attach and dettach.Please adviceRegardsNitin |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-04-19 : 13:51:17
|
quote:
I dnt want to use backup and restore and Attach and dettach.
Those are the best options to transfer databases between servers! Why don't you want to use them?Tara Kizeraka tduggan |
 |
|
|
nitin1353
Constraint Violating Yak Guru
381 Posts |
Posted - 2006-04-19 : 14:14:48
|
| hiActually i was asked this question in the interview in one of the top IT companies in india.Do you have any idea? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-04-19 : 14:18:08
|
| Tell them that those are the best options! Any other option would be too time consuming. The other options would be DTS or bcp along with scripting of the objects. Using these options would be mean more significant downtime for the users that the backup/restore or detach/attach approaches.Tara Kizeraka tduggan |
|
|
|
kpsreenath
Yak Posting Veteran
52 Posts |
Posted - 2006-04-19 : 14:18:51
|
| Transfering data can be done using dts packages as wellThanksSree |
|
|
|
nitin1353
Constraint Violating Yak Guru
381 Posts |
Posted - 2006-04-19 : 14:20:55
|
| hitell me one thing,how can i use DTS in this.Is there a task for this?RegardsNitin |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-04-19 : 14:26:18
|
| Import/Export wizard would be easiest rather than creating a DTS package. It uses DTS but walks you through the steps.Tara Kizeraka tduggan |
|
|
|
nitin1353
Constraint Violating Yak Guru
381 Posts |
Posted - 2006-04-19 : 14:29:18
|
| hmmm..anything else?do you have information about linked servers?can they help me in anyway?Regards |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-04-19 : 14:31:30
|
| I wouldn't use linked servers. If you want information about them, do some reading in SQL Server Books Online.Tara Kizeraka tduggan |
|
|
|
nitin1353
Constraint Violating Yak Guru
381 Posts |
Posted - 2006-04-19 : 14:41:08
|
| yeah i am doing that.Tara any information how data can be transfered using insert scripts?Regards |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
nitin1353
Constraint Violating Yak Guru
381 Posts |
Posted - 2006-04-19 : 14:49:38
|
| allrite,one more thing if there are 100 dts on my server and i want to find one particular string,how will i go about it?Regards |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-04-19 : 14:51:21
|
| I don't understand your question.Tara Kizeraka tduggan |
|
|
|
nitin1353
Constraint Violating Yak Guru
381 Posts |
Posted - 2006-04-19 : 14:57:36
|
| Suppose there are 100 DTS on my server and i want to find a particular thing in the packages,i dnt wanna open every package and check |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-04-19 : 15:06:23
|
| I gues you could check the packagedata column in the msdb.dbo.sysdtspackages, but I don't think that would get you very far. I'd probably save the files to a VB file and do my search from there. Then I'd go back in Enterprise Manager and open the DTS package that corresponded to my search in VB. I try to avoid DTS as much as possible as it complicates things. I like to write T-SQL, bcp commands, batch files, etc... instead of using DTS. But that's my preference. Your mileage may vary.Tara Kizeraka tduggan |
|
|
|
nitin1353
Constraint Violating Yak Guru
381 Posts |
Posted - 2006-04-19 : 15:13:35
|
| hmm.thanks for all the answers tara.Regards |
|
|
|
|
Transfering data between servers