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 |
|
babui386
Starting Member
1 Post |
 Posted - 2007-12-18 : 08:31:26
|
| Hi,I am new to SQL server, currently using 2005, my web server using 2000, we have also 2000 installed, which has enterprise.I would like to create a schedual for daily data download to our local server, if it is possible in 2005, or may be we can use 2000 enterprise, but I am really stuck how to set this into my system.Please someone help... |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2007-12-18 : 09:57:34
|
| When you say download, what exactly do you mean?If it is data from one SQL server to another, then use bcp or SSIS and use a scheduled job to run it. |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-12-18 : 21:04:23
|
| If those servers are not on same network, you have to fine way to transfer data file. |
|
|
|
|
|
|
Schedual data Download - How to??