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...Please help: Mobilink script is applied to the consolidated database or remote database
I have a table called Customer in both Remote and Consolidated database. In
the table there is a status field. i wrote in my end_download script:
update Customer set status = 'd' where customerID = @customerID
@customerIS is created in the begin_download script.
I understand the end_download script above will affect the consolidated
database. However, if i wrote in my end_upload script: update Customer set
status = 'u' where customerID = @customerID
@customerID is created in the begin_upload script.
I dont know if the end_upload above will affect my...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...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" <firstname.lastname@example.org> 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...mobilink with sql server as consolidated database
I am using sql server 2000 as consolidated database and in the device I am
using asa 10.0.1.3686 with Pocket Builder 2.5
previously in sybase 9 I have that to manage a temporal table in the
mobilink to manage environment variable that used in the different events,
the same thing happens in mobilink 10, when I work with sql server like
"LAPI" <email@example.com> wrote in news:48359692@forums-1-dub:
> I am using sql server 2000 as consolidated database and in the device I am
> using asa 10.0.1.3686 with Pocket Builder 2.5...Prevent sync of selected remote database changes with consolidated database
I have query from one of my customers using SQLAnywhere 9.0.1. They are
asking whether there is a way to prevent logging of certain
inserts/updates/deletes such that these changes are not reflected in the
consolidated database. I was looking through the documentation and found a
STOP SYNCHRONIZATION DELETE command but I believe this only prevents deletes
from being synched to the backend.
You have probably written MobiLink scripts to handle the uploaded
inserts/updates/deletes. You could implement a consolidated database
table to hold the MobiLink user ids th...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...How to delete duplicate rows from remote database when they have successfully replicated back to the consolidated database?
I have a SQL remote replication setup with a central consolidated database
and many remote databases.
For simplicity sake I have a table called period_sale (sale_code,
period_number, sale_amount, branch_id) which participates in replication
and the publication to which this table belongs
has a SUBSCRIBE BY branch_id. Also the subscription that has been created
for each of the remote branch to this publication has a subscription value
of branch_id. In other words the subscription for branch_id of HAR001 was
created using CREATE SUBSCRIPTION TO pub_dailytrans ('HAR0...Unable to connect to database server: Database server not running
I get this error on one of my clients, although the DB server is, in fact,
If I go to ODBC, and "TEST CONNECTION" it says OK, and all begins to work
within a minute or so again.
Sybase][ODBC Driver][Adaptive Server Anywhere]Unable to connect to database
server: Database server not running
Are there client settings, or server settings, which can eliminate this
Our entire website stops working as it's completely db driven, until the
error clears itself up...
RUNNING ASA 6.0.3030
Can you post the parameters you filled in...Replicating passwords from one remote database to other remote databases
I am attempting to replicate password changes from a remote database to
the consolidated database to all other remote databases.
The reason I am attempting this is we are implementing "multi-user"
remote databases, where a db user created on the consolidated can be on
one or more remote databases.
I want to only allow remote users to change their db passwords, but have
those password changes replicate to all other remote databases.
My initial thought was to have a table that maintained db user name and
encrypted password that would be subscribed to by all remote databas...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
...Dev servers consolidation
I like to gather thoughts on how your firms setup Dev boxes for ASE servers.
1. Does any developer have their own ASE to work on?
2. Or they can share 1 ASE, with their own databases?
My firm has too many ASE dev servers, I like to find a Good way to
reduce ASE counts. If Oracle or MS-SQL or DB2 have better methods to
accommodate more developers simultaneous working on 1 project, I like to
Are there some 3rd party tool or home grown tools can facility create a
big ASE with many many databases; and developers can do the works w/o
interfere with each other. For example,...