Replication of consolidated database to remote database; for columns added to a table in the consolidated database.
I want to find out if I add columns to a data table in the consolidated
database and then extract it for a remote database. Will the added columns
appear in the remote database automatically? or do I have to deploy the
extracted remote database by copying it to the remote machine.
Currently the consolidated database and the remote database get replicated
nightly and they have connections already established. Due to established
connections, will the extracted database automatically get deployed to the
remote machine with the updated table?
Try it, that is the best way to check ...How to upgrade database changes in remote databases and consolidated databases
I am Working in a project which uses Sybase Mobilink server as the
replication system. Now I have been given a requirement to automate the
upgrade databases chages in remote databases and consolidated database.
I heard the about "Passthrough" but I don't know how to use it.
I saw below topic in our forum
PASSTHROUGH Question. How do I replicate DML ...
1.- Created a Version_Tracking Table (contains columns
Unique_Record_ID, DB_Remote_ID, DB_Version, DB_Update_Time_Stamp and
2.- The new Version_Tracking table is part of a publication that...Is there a way of asking the remote database to Re-send statements that have failed to be applied at the consolidated database because of referential integrity ?
We have a consololidate database with a table 'client_site'. The remote
database also has this table 'client_site'. The client_site table is an
article in a publication and the SUBSCRIBE BY on client_site is by
'site_ref' which is the PK in the client_site table. I also do not include
a column list with the articles, so it assumes all columns in the table
participate in replication
For some strange mis-management reason, this table at the remote end has a
column 'month_end_run_ts' which is not present in the consolidated
...Server database remote to consolidated database
our consolidated database "A" (db not determinated yet) and
the database which to be replicated "B" (Oracle) are on
different boxes. The Mobilink replication will be done
between A and many clients "C".
1. Is it possible to configure the Mobilink Server to handle
this configuration ?
2. If so, does the Mobilink Server pull the data via odbc
from the remote database ?
3. If not, would it be possible to use for a replication
between A and B the Mobilink Server (the client is A and the
server is B) ? This barmy idea b...Replication of entire consolidated database to remote database
i need to replicate the entire consolidated database into remote databse
can any body suggest me the simpliest way of doing????(what exactly i need
is how to make my remote databse should contain
same data which my consolidated has...)
thanks in advance....
waiting for reply
"Nageswara Rao" <email@example.com> wrote in
> i need to replicate the entire consolidated database into remote
> databse through Mobilink..
> can any body suggest me the simpliest way of...create ASA remote database out of consolidated database
I am trying to make a remote database out of a consolidated database.
The scheme of the remote database should be parallel in structure to the
scheme of the consolidated database. The database has about 300 tables.
In all our tables is a identifier company_id and in some tables (about
200) the identifier user_id.
After the remote database is created synchronisation should work as
The tables with the identifier user_id are changed in the remote
database and should be uploaded to the consolidated database. The tables
with no user_id are changed in the consolidated dat...uploading data from the remote database to a consolidated database.
im using a ASA 8.0.2 build 4089 as a mobilink server in my win2k.
and ASA CE 8.0.2 im my pocket pc 2002 device.
im using mobilink sync server 8.0.2 build 4089
im confused which sync events i should use. to upload data from my remote db
to the consolidated db.
i need to upload rows from my remote db to the consolidated db.
i tried upload_insert . upload_update events .
but every time the upload_inster event fires first and it gives a primary
key conflict error in my CD db.
can any one explain me how to design the upload procees?
i need to insert , update and delete in my co...Extracted database not applying messages of consolidated database
I have a replication problem. I'm using Adaptive Server Anywhere 7 version
7.02.1588 and dbremote replication. After extraction of remote database the
replication works only one way from remote database to consolidated one.
The messages from consolidated database are staying in a folder and not
applying against remote database by dbremote. It looks like dbremote doesn't
see consolidated messages at all.
Do you have any ideas how to fix that ?
What does the dbremote output window report on the remote when it fails to
apply the messages?
...Multiple consolidated databases for Mobilink
Is there a way to use Mobilink to synchronize multiple clients
(iAnywhere on PDAs) to multiple back-end databases (MS SQL Server)? If yes,
how can I configure the client to specify which database it should use to
synchronize? Any success stories or suggestions are welcomed.
Thanks in advance,
Anastasios Papadopoulos wrote:
> Hello all,
> Is there a way to use Mobilink to synchronize multiple clients
> (iAnywhere on PDAs) to multiple back-end databases (MS SQL Server)? If yes,
> how can I configure the client to specify whic...Using a MobiLink enabled database for non-MobiLink deployment
Would there be any known issues/consequences using a database that has been
setup for MobiLink if the application will not be participating in
synchronization? We deploy an empty database as a template with each
release of our software that may or may not need the synhronization aspect.
I was thinking that it would be easiest to maintain the template with
MobiLink installed (all ml_* tables and views), all the sync scripts in
place, and just not have any MobiLink users defined or subscriptions. The
consolidated database doesn't get the publications, s...Mobilink synchronization with Informix consolidated database
Reading chapter '2.Sinchronization Basics' of 'Mobilink
Synchronization User=b4s Guide' I see that not include bd
Informix like consolidated database. My consolidates
database is Informix what can i do?
Informix is not an officially supported consolidated database for MobiLink
synchronization. You may be able to use statement based synchronization
scripts (instead of cursor based) to get something to work, or even use ASA
with proxy tables to Informix. Keep in mind however, that Informix is not
officially supported, so if you run into difficulty, we may not have the
...delet mobilink client in consolidated database
How do I delete a mobilink client in the consolidated database?
I use the script below to test if the user of our program is a mobilink
WHERE user_id = :UserOfOurProgram;
Should I use:
WHERE user_id = :UserOfOurProgram;
Eric Verhorstert <firstname.lastname@example.org> wrote in news:42ea4418$1@forums-
EV> ASA 9
Please provide dbeng9 -v output.
EV> How do I delete a mobilink client in the consolidated database?
First let's a...Mobilink server / consolidated database in maintenance
I was wondering if there is a preferred way of dealing with
synchronisation requests whilst the consolidated database
server was down for maintenance? With the Mobilink server
stopped clients simply fail to connect a socket (as you
If there a more graceful way of information the client
database that the server is not in fact missing, just down
Thanks in advance.
MobiLink 11 184.108.40.2064
There are many approaches to address this concern.
All of which use multiple ML servers and some
redirector or load balancing.
See the det...Problem Mobilink With Trigger on Consolidate Database
I have some problem about Mobilink .
I have 3 table . table A , B and C
all 3 table are consolidate database (Sybase ASE 15)
- table A have trigger update by update table C
- table B have not trigger
Remote Database ( ASA)
- Have table A ,C
Problem : When i update table A and i insert table C then Sync , I
E. 06/26 11:06:29. SQLCODE from MobiLink server is: -10002
E. 06/26 11:06:29. Message: ...