Welcome to the VanDyke Software Forums

Join the discussion today!


Go Back   VanDyke Software Forums > File Transfer

Reply
 
Thread Tools Display Modes
  #1  
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!

Thanks
Reply With Quote
  #2  
Old 02-11-2020, 02:40 PM
bgagnon bgagnon is offline
VanDyke Technical Support
 
Join Date: Oct 2008
Posts: 4,220
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.
__________________
Thanks,
--Brenda

VanDyke Software
Technical Support
support@vandyke.com
(505) 332-5730

Last edited by bgagnon; 02-11-2020 at 02:40 PM. Reason: added version
Reply With Quote
  #3  
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
Reply

Tags
sas , securefx , server , transfer , unix


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
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 01:29 AM.