Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

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

Posted on 2004-08-03
3
Medium Priority
?
543 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 1600 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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Explore the ways to Unlock VBA Project Password Excel 2010 & 2013 documents. Go through the article and perform the steps carefully to remove VBA Excel .xls file.
Tech spooks aren't just for those who are tech savvy, it also happens to those of us running a business. Check out the top tech spooks for business owners.
In response to a need for security and privacy, and to continue fostering an environment members can turn to for support, solutions, and education, Experts Exchange has created anonymous question capabilities. This new feature is available to our Pr…
We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data. But that feeling is fleeting. Attacks these days can happen in many w…

636 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