datasynchronization

Strategy for Offline/Online data synchronization

My requirement is I have server J2EE web application and client J2EE web application. Sometimes client can go offline. When client comes online he should be able to synchronize changes to and fro. Also I should be able to control which rows/tables need to be synchronized based on some filters/rules. Is there any existing Java frameworks ...

Which is the best way to bi-directionally synchronize dynamic data in real time using mysql

Here is the scenario. 2 web servers in two separate locations having two mysql databases with identical tables. The data within the tables is also expected to be identical in real time. Here is the problem. if a user in either location simultaneously enters a new record into identical tables, as illustrated in the two first tables belo...

Google Gears - To what level is synchronization supported?

Hi All, I have a few questions about data synchronization. The architecture does not seem to be clear about this: Does Google Gears provide from automatic synchronization of data (from client to server and server to client)? If it does provide for automatic data synchronization, then can i write functions to hook into the sync mechani...

Are there any PDA or Outlook Synch Frameworks out there?

We have a web application that deals with some common sales entities (Contacts, Appointments, Addresses, Notes etc..). We need to keep our app, outlook, and potentially any devices that they might have synchronized. Are there any frameworks that we can use that help us integrate with PDAs? Any thoughts or reccomendations are appreci...

Periodically copy revisions from one SVN repository to another active SVN repository

Hi My company maintains two SVN repositories, Repository 1 and Repository 2: This repository has multiple projects in it, and is only accessed by the developers within the company. Access is through HTTPS and authentication is through the Windows domain. This repository has a single project in it, and is accessed by the developers wit...

What are viable options for data synchronization and transformation in sql server 2008?

Our company needs to synchronize two sql server 2008 databases on two different servers. The database schemas are about 50% different so transformation is needed. Synchronization needs to be done in real time. Synchronization needs to be bi-directional. What are some good practices used for this purpose? We have analyzed the foll...

XCOPY-deploying Microsoft Sync Framework in a no admin rights scenario (i.e. ClickOnce install)

I'm currently designing a smart client app (WPF) which needs to operate in an "occasionally disconnected" mode. For the offline scenario, I'm looking at using: Disconnected Service Agent Application Block (from the Smart Client Software Factory) Microsoft Sync Framework I should mention that I want my smart client app to be XCOPY-de...

Strategy for syncing data with mobile phones?

We built a .NET server application that hosts data (contacts, email, etc.). We'd like to sync our data to mobile devices: iPhone, Windows Mobile, Blackberry, etc. How should we go about doing this? Build several mobile apps, one for each platform (e.g. app for iPhone, app for Blackberry, etc.), each app syncs with our server. License ...

How to add data sync (Google docs) ability to iPhone app?

I would like to enable my iPhone app's data to sync with Google docs. How can this be done? What other sync'ing options do I have (another one I am aware of is EverNote Sync Server)? ...

Data sync with vb.net and php

I have a windows application and a php web application(not connected to internet all times), eventually data add/remove/update can happen at either places. So data has to be synchronized every day or manually. I have a small sqllite database file (less than 500K) in my end, and the php web app uses Mysql, the structures remain the same....

Microsoft Sync Framework with Mutliple Client and Server Database

I'm working on changes to an application to have a local data store instead of connecting directly to the database server. The client app will then sync changes both ways between the server database and its local data store. I'm trying to implement the syncing solution using Microsoft Sync Framework. To be clear there is no server applic...

Synchonizing data between django orm and pyodbc data source

Hello. I have a database (in Access 95 format... don't ask) that contains data i'd like to use in Django. I can already successfully connect, issue queries, etc using pyodbc. For the most part this is a one way sync operation - that is, the data won't be modified in Django, but will be modifed in the Access 95 db via legacy applications...

Data sync solution?

For some security issues I'm in an envorinment where third party apps can't access my DB. For this reason I should have some service/tool/script (dunno what yet... i'm open to the best option, still reading to see what I'm gonna do...) which enables me to generate on a regular basis(daily, weekly, monthly) some csv file with all new/modi...

How do you execute Data Synchronizations between EPMA applications programmatically?

I would like to schedule a batch job in which a can execute a move of data between two workspace application in Hyperion Fusion Edition for Oracle. The tool provided is called 'Data Synchronization' This tool allows for this type if activity to occur upon request via the workspace environment. How might I do this automatically? I no...

Updating a local sqlite db that is used for local metadata & caching from a service?

I've searched through the site and haven't found a question/answer that quite answer my question, the closest one I found was: Syncing objects between two disparate systems best approach. Anyway to begun, because there is no RSS feeds available, I'm screen scrapping a webpage, hence it does a fetch then it goes through the webpage to sc...

Microsoft Sync Framework and Integer as Identifier

I've got to implement data synchronization between a local storage that resides on a mobile device and the server DB. The thing is that our DB (which is already in production for many years) all uses an integer as the Id of a record. I'm afraid that changing it to be a GUID is currently not an alternative because it has too many repercu...

Syncrhonizing 2 database with different schemas

Hi guys, We have a normalized SQL Server 2008 database designed using generic tables. So, instead of having a separate table for each entity (e.g. Products, Orders, OrderItems, etc), we have generic tables (Entities, Instances, Relationships, Attributes, etc). We have decided to have a separate denormalized database for quick retrieva...

Replication/Synchronization Library for Occasionally Connected Systems

here is the situation I have a .Net desktop application which stores it's data on local file system (using sqllite). And there is the master database on a remote server which. The desktop application needs to synchronize data to the master database when ever there is a dial up connection to a specif server or when ever there is an intern...

How do i migrate data from MSSQL 2000 data tp MySQL?

Hi guys, I am given a task of developing a tool for migrating data from MSSQL 2000 do MySQL database. My clients runs a third party software which stores data in MSSQL 2000. The application is desktop software that stores data in local MSSQL Server. My Application is in web. We store data on online servers. Now my task is to write a ...

Jangomail Integration with Salesforce

Has anyone used or uses this feature? I've been using the free trial of Centerprise recommended to me which works really well in building specific contact lists I want from Salesforce imported into Jangomail. Is it worth looking into Jangomail's integration with Salesforce because I haven't had the time to figure it out. I might have ...