Solved

Mobilink Synchronization (upload) of existing data in remote database.

Posted on 2004-08-03
3
539 Views
Last Modified: 2008-02-01
We are trying to use Mobilink to synchronize our Corporate database with remote databases located at various regional offices.

We already have existing data in the regional databases. The problem we are facing is that when we are running synchronization, it is synchronizing only the new inserts done after the creation of Publications & Subscriptions.

What we want is to get all existing data from the regional databses and synchorinize our corporate databse with them. We are not able to do that.

Can anyone help us in doing the same.

Regards,
Anuj Paul.
0
Comment
Question by:antu23
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 19

Accepted Solution

by:
grant300 earned 400 total points
ID: 11708353
Anuj,

You are doing this implementation in kind of reverse order.  Normally you start with the consolidated database and migrate the schema (and any data) out to the virgin remote databases.  When you use the Migrate Schema wizard in Sybase Central, there is a checkbox option to the last page to "Migrate Data" when you migrate the schema.  After that, the data goes either direction depending upon the Pubs and Subs you have defined.

In the this case you have established remote databases and are trying to build a consolidated database.

Which way did you migrate the schema, remote to consolidated or consolidated to remote?

You can try to trick the system into sending all the data:
1)  Backup up everything!
2)  Break the Pubs/Subs for that remote server
3)  Delete the data for Region A from the consolidated server
4)  On the Region A server, copy the data into working tables (select into)
5)  Reconnect the Pubs/Subs for Region A
6)  On the Region A server, insert/select the data from the working tables back into the real tables
7)  Let it connect and then sit back and wait for the sync to finish.  Could take awhile.

8) - 800)  Repeat the above steps for each Regional Server.  Yuck!

Another approach that MAY be possible depends on two things: do you have a Pub/Sub for UPDATES and do you have the update logic on the consolidation server setup to INSERT a record that was updated on the Remoe server but is not found in the consolidated server.

If both these conditions are true you can do a meaningless  update (with no where clause) against each table.  Mobilink should pick it up and move it but it will be ugly as well.

Yet a third option is to dump the tables at the remotes databases into flat files, move them to the consolidated site, and load them in the server.  You will have to figure out how to delete any data that already exists for the Regional server you are loading at the moment.  This is probably the most effeciant method since it bypasses the overhead of replication.  You just have to find adequate batch window to get the extract, transfer and load done.

Hope that helps.

Bill
0

Featured Post

[Webinar] Learn How Hackers Steal Your Credentials

Do You Know How Hackers Steal Your Credentials? Join us and Skyport Systems to learn how hackers steal your credentials and why Active Directory must be secure to stop them. Thursday, July 13, 2017 10:00 A.M. PDT

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article shows how to use a free utility called 'Parkdale' to easily test the performance and benchmark any Hard Drive(s) installed in your computer. We also look at RAM Disks and their speed comparisons.
In this blog we highlight approaches to managed security as a service.  We also look into ConnectWise’s value in aiding MSPs’ security management and indicate why critical alerting is a necessary integration.
If you're a developer or IT admin, you’re probably tasked with managing multiple websites, servers, applications, and levels of security on a daily basis. While this can be extremely time consuming, it can also be frustrating when systems aren't wor…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question