Link to home
Start Free TrialLog in
Avatar of Paul_Blackler
Paul_Blackler

asked on

Can I use SQL Server to backup, zip and ftp - as a one button process

Hi
I have a requirement to backup a database, shrink it, zip it and ftp to a server all as one process (me thinks here this is going to be command line stuff) - does any body have any ideas on how to accomplish this.

Thanks

Paul
SOLUTION
Avatar of nmcdermaid
nmcdermaid

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Paul_Blackler
Paul_Blackler

ASKER

I actually want to use a bespoke program called FTP Voyager from the CMDExec would that cause any problems
Thanks
in theory, if there is commandline access to the FTP prog, there should be no problem.

i personally just have objections to the use of cmdExec from a security perspective.
Thanks both of you
Paul