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 ...
Replication of entire consolidated database to remote databaseHi Friends,
i need to replicate the entire consolidated database into remote databse
through Mobilink..
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
Govada
"Nageswara Rao" <tnagesh@i-vantage.com> wrote in
news:efRU$hd9CHA.317@forums-1-dub:
> i need to replicate the entire consolidated database into remote
> databse through Mobilink..
> can any body suggest me the simpliest way of...
Prevent sync of selected remote database changes with consolidated databaseHi everyone,
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...
Replicating passwords from one remote database to other remote databasesI 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...
How to delete duplicate rows from remote database when they have successfully replicated back to the consolidated database?Hello,
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...
Server database remote to consolidated databaseDear community,
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".
Questions:
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...
database upgrade process when upgrading ASA9 database replicating with dbremoteNot sure where I should post this.
I have bee doing some testing with SQL Anywhere 10.0.0.2417. I converted my
publisher and one of the subscriber databases from ASA 9.0.2.3302. The
Publisher and subscriber wer replicating fine when on running ASA 9.
I ran the dbunload process on the ASA 9 databases and copied the old
database log files into the SQL Anywhere 10 database directories.
Now when I attempt to run the Replication process ( dbremote ) I continue to
get an error that a log off set is not found
"Unable to find log offset 018112048023"
I translated...
create ASA remote database out of consolidated databaseI 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
follows:
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...
Refreshing the remote database and changing database structureHi,
I have Mobilink synchronization setup between two SQL Anywhere 11
databases. Everything is working fine but I wanted to know if it is
possible to cause the remote database to refresh it's entire contents
from the consolidated database.
I previously used Intellisync to synchronise databases and it had a
refresh option on the server which allowed you to specify a certain
user and then at the next sync it would just download the entire
consolidated database and overwrite the local remote one. This was
useful if a device was reinstalled or hadn't synced for a while.
At the ...
Disabling database changes tracking for remote databaseHi everyone,
I've been battling an issue with slow synchronization for some time now and
finally figured out some of the potential bottlenecks. I have a table that
stores binary data, there is only a download scripts defined for the table
(download_cursor, download_delete_cursor) as no changes are allowed to it on
the remote database. However I see that every time the table is updated, on
the next synchronization Mobilink uploads table operations for this
particular table. Thus if the amount of data inserted into the table was
large, on the next synchronization attempt all...
uploading data from the remote database to a consolidated database.hi all,
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...
Schema changes (create table) on existing remote database doesn't synchronise existing records from consolidated database.We have an existing ASA 9 database who syncs through Mobilink with an
Oracle consolidated database.
When we create a new table in the ASA database and that table with
data already exists in the consolidated database,
the synchronization will not download the records because the
timestamp of the last synchronization is greater than the timestamps
in the table on the consolidated database.
How can this easily been solved?
Thanks in advance.
Finding a way to unload the Oracle table data into a file
and finding a way to ship that file out, so that you can
use LOAD TABLE statements ...
copy database one database to onther database
hii want to copy one database table to onther database table using script?my database is ms-sql server 2000 Nothing is really over,untill the moment stop trying for it...Amitsp(MCTS,MCP)sqlreporting.blogspot.com
You can use import/export task and DTS package created automatically by Enterprise manager or just try
select * INTO [newdatabase].dbo.[newTable] from [sourceDatabase].dbo.[sourcetable]
good luckThanksJPazgier
no dear i want to this programatticallyiusing c #,source is my database in local machine and target is other computer means server Nothing is really...
Please help: Mobilink script is applied to the consolidated database or remote databaseHi,
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...