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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-05-20 : 08:29:21
|
| sreekanth writes "hi,i have to export the sqlserver data to a text file and transfer that file to a remote machine and import that on to that machine.i know how to export and import the database files. i do not know how to transfer those files over internet. our client do not want to use replication. can you suggest me any alternate methhod?" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-05-20 : 08:40:58
|
| You could use Data Transformation Services to transfer data between the two servers directly, without needing the intermediate import/export step. Since it sounds like you can transfer a file to the client's machine, I don't see any reason why you can't (besides security issues, but you can work that out with the client)You can also try using linked servers. These allow the two machines to link in a way that allow you to query the other server's as if the databases were no different than the local ones.I'd recommend reading through Books Online regarding DTS and linked servers, and try some experiments to see if they are feasible for you. |
 |
|
|
|
|
|
transfer the data files between remote servers