How to access database on FTP site

• KOliver

  SSC Enthusiast

  Points: 183

  More actions

  July 18, 2005 at 11:14 am

  #109939

  Hi, all

  How would i use MS-SQL to automatically access and retrive a database file from a FTP server. 

  Thanks

  Oli

• vinod-228002

  SSChasing Mays

  Points: 608

  More actions

  July 19, 2005 at 6:19 am

  #575445

  h!!,

   register the remote SQL server on Enterprise Manager by adding a route to your server using IP address..

  regards,

  Vinod (DBA)

  09840856202

• Junk SQL1

  Valued Member

  Points: 65

  More actions

  July 19, 2005 at 11:13 am

  #575576

  Hi,

  I think you're asking how to pick a file from an ftp site, not from another SQL server.

  I used dts to call a batch file that pulled a database dump that had been zipped down using a custom compile of GZip to deflate multigig database dumps.

  Once the file was pulled, I used the dts package process to GUnZip the file and then restore the database.  After the database was restored, a process was then called to sequentially rename the downloads so that the client had a rotating seven day backup.

  ftp will accept a command file which would allow you to open the connection enter UID/Pass and get or put a file

  The batch file you create would look something like this

  c:

  cd \FileTransfer

  ftp -s:C:\<ScriptSource>\<ftpscriptname.txt>

  example of the syntax for the ftp script file

  open <ftpsite address>

  <login name>

  <login pass>

  prompt

  <put/get> <file name>

  quit

  Depending on whether you have mail set up you can run error checking to notify if the file did not get transferred.