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 |
|
AsimKhaliq
Yak Posting Veteran
94 Posts |
 Posted - 2003-12-02 : 23:49:03
|
| I have to upload some tables to my FTP site can any one help me regarding the process and scripts or documentation.Thans in advance |
|
|
mohdowais
Sheikh of Yak Knowledge
1456 Posts |
Posted - 2003-12-03 : 02:04:47
|
Asim, how do you upload tables to an FTP site? Are you talking about deploying database changes to some other server? Can you clarify your situation a little further? Owais
Please excuse my driving, I am reloading. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-12-03 : 12:28:15
|
| You can BCP the data out to a file, then run FTP commands to get it to the server. All of this can be done in a batch file if you need it to happen on a scheduled basis. Check out BCP command in SQL Server Books Online.Tara |
|
|
|
|
|
|
FTP upload