"AG" <aj*****@hotmail.com> wrote in message
news:11*********************@g49g2000cwa.googlegro ups.com...
Every night i want to send the new records that are created from my
remote client to my FTP site, using a application which sets up an
internet connection on the client , exports the data to the flat file
and downloads the flat file to an FTP site.
Would anyone know how to do this?
Thanks in anticipation.
Ajay
I'm not sure what you mean by "remote client", but if you're asking how to
move data from one MSSQL or MSDE installation to another, then that's
certainly possible. There are a number of different ways, but one general
solution would be to export your data to a flat file with bcp.exe, osql.exe,
or DTS; then use a script in a language like C#, Perl, Python etc to handle
the network/FTP part. To control the whole process, you could put everything
into a DTS package or use multiple steps in a scheduled job.
If this isn't helpful, I suggest you give some more details about your
environment and which part of the process you're not sure about - your
MSSQL/MSDE version, what your "remote client" actually is, the volume of
data to transfer, where the data is going from and to, what you mean by "new
records" (copy any change to the database or only new rows from certain
tables) etc.
Simon