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.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 can we store sqlcmd output to ftp

Author  Topic 

amey_pg
Starting Member

2 Posts

Posted - 2012-02-22 : 12:10:59
Hi All,

Can you tell me how can store sqlcmd output file to FTP location?

b0dhiscript
Starting Member

1 Post

Posted - 2015-03-30 : 20:43:12
Just make a .bat script to export the SQL to a file and whatever else you wanna do to the files and then...

use winscp to write a script to send it over using parameters.

just look at the reference material for the technologies i have mentioned above! good luck!
Go to Top of Page

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2015-03-31 : 01:44:25
sqlcmd has output function. Read here for more information: http://www.sqlserver-dba.com/2012/09/sql-server-sqlcmd-with-screen-output-and-output-file.html

You can also use pscp to copy the file - http://www.dba-db2.com/2012/08/db2-how-to-pscp-from-the-command-line.html

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page
   

- Advertisement -