At 11:32 AM 4/21/2010, Matthew Burke wrote:
Razzak,
Thanks so much for the information about R:Synchronizer! I think
this is just
what we need. I'm not sure if you remember us talking about this or not... I
know you're a busy man, but what I'm looking at this for is our "LiveShip"
R:Base project. I'm trying to find the best solution to keep the
new Ship 2.0
tables in sync with our E3 products Microsoft SQL tables as close to
real time
as I can manage. I feel it would be most beneficial for us to let our users
work off of information warehoused in R:Base tables to keep things as snappy
as possible, opposed to building a R:Base frontend for the SQL tables.
Matthew,
We didn't discuss this during my last on-site visit. However, R:Synchronizer
is the perfect solution for your specific scenario.
Can R:Synchronizer be embedded into scripts, like if I were to build an
updating client that would 'R:Synchronize' as a timed event?
Absolutely!
R:Synchronizer includes support to save all available synchronization
parameters into a script file. Once all tables are mapped, you can save
your current settings into a script (.rsf) file. Then, you can totally
automate the entire replication/synchronization process.
Here's how:
In your R:BASE Turbo V-8 environment:
RSynchronizer80.exe scriptfilename.rsf -t -ss
In your R:BASE eXtreme 9.0 environment:
RSynchronizer90_64.exe scriptfilename.rsf -t -ss
During the synchronization process, any -ERRORs-, if found, will be
recorded in the log file, if defined.
-t
The "-t" parameter allows the ability to substitute the target database
name at the command line. Following the "-t", the path and database name
must be specified. This entire optional parameter must be enclosed in
double quotes. This parameter is beneficial to users with multiple
synchronization processes to configure.
Example:
RSynchronizer90_64.exe sync_alpha.rsf "-t \\RRBYW16\TeamAlpha\rrbyw16.rx1"
Where:
the -t parameter is a target database override that only substitutes the
target database name for the one in the script file.
-ss
The "-ss" parameter toggles the Speed Sync option for faster synchronization.
Toggle Speed Sync using "YES" or "NO". This entire optional parameter must
be enclosed in double quotes.
Example:
RSynchronizer90_64.exe sync_alpha.rsf "-ss YES"
Where:
the -ss parameter activates Speed Sync mode. Your script files can also be
used when assigning operating system scheduled tasks!
Can R:Synchronizer sync multiple tables simultaneously?
Yes, you CAN!
Thank you and keep up the amazing work!
Thank you!
Keeping up with today's ever-changing technology and incorporating R:BASE
to provide a total solution for current needs has always been a challenge
on which I thrive.
Take Care and Very Best R:egards,
Razzak.
--- RBASE-L
================================================
TO POST A MESSAGE TO ALL MEMBERS:
Send a plain text email to [email protected]
(Don't use any of these words as your Subject:
INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH,
REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP)
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: INTRO
================================================
TO UNSUBSCRIBE:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: UNSUBSCRIBE
================================================
TO SEARCH ARCHIVES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: SEARCH-n
(where n is the number of days). In the message body,
place any
text to search for.
================================================
