Welcome to the VanDyke Software Forums

Join the discussion today!

Go Back   VanDyke Software Forums > File Transfer


Thread Tools Display Modes
Old 02-11-2020, 01:44 PM
craned craned is offline
Registered User
Join Date: Feb 2020
Posts: 2
Transfer Tables Between Two Separate Servers

I'm looking for a way to automate the transfer of several tables between two different servers. I'm connected to both servers in SecureFX. Usually, I have to drag-and-drop one table at a time from a location in Server A to a different location in Server B, but this is getting tedious.

Is there a way to set up all of these transfers automatically, so that when I update these tables in Server A, I can go into SecureFX, run a script, and they'll all be updated in Server B?

Let me know if I can clarify anything above!

Reply With Quote
Old 02-11-2020, 02:40 PM
bgagnon bgagnon is offline
VanDyke Technical Support
Join Date: Oct 2008
Posts: 4,636
Hi craned,

Why not use Synchronize (Tools menu) in SecureFX?

Here's a video about it. While the video might illustrate local to remote syncs (or vice-versa), I have just tested and verified you can do a server-to-server sync (supported in v8.1 and later).

Once you have created a Sync session, you can use it with SFXCL to automate the task:

SFXCL /Synchronize "Server2Server_Sync"

You'll want to throw in logging and some other options probably. See this tip on our website about SFXCL. It does not delve into Quick Sync and Synchronize operations but the SecureFX help topic Getting Started / Command-Line Utility has all the options and syntax.

VanDyke Software
Technical Support
(505) 332-5730

Last edited by bgagnon; 02-11-2020 at 02:40 PM. Reason: added version
Reply With Quote
Old 02-11-2020, 02:41 PM
craned craned is offline
Registered User
Join Date: Feb 2020
Posts: 2
Thank you, bgagnon! I was having trouble finding a place to start. I'll take a look at the info you provided below, and let you know if I have any questions.

Thanks again!
Reply With Quote

sas , securefx , server , transfer , unix

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

All times are GMT -6. The time now is 05:32 AM.