473,725 Members | 2,254 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Two way syncronizing with a website database with a local database

D0c
Hey,
I would like to syncronize my local database with my website database.
Scenarios are
1. New rows / row updates in the local database to be updated on the
website database (local -net)
2. Updates on the website database to be updated on the local database
(net -local)

* Updates for both databases are possibly on different fields

I am thinking of writing an application (C#.Net or what ever works)
that will start up the sync process (1 then 2 ).. maybe at the end of
a work day. The idea is to have a sort of replication of the database
both locally and internet. This is because, the local (client) may not
always be connected and could be disconnected for any length of time.
However once connection is restored,i would like for the sync process
to execute and sync both databases.

The underlining idea behind the website database, is for field updates
and viewing only. The local database is for new rows and field
updates.

My questions are,
1. Does MySQL provide scripting for such a sync as described above to
take place without overwriting data on either database?
2. If so can this sync be automated or executed with one click/
command ?

Feb 4 '07 #1
0 2920

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
1461
by: shank | last post by:
I want to create a dynamic website hosted on a CD. It would be based on ASP and have a database. Is this possible? How would I approach such a thing? I'm sure I could by a runtime version of Access and build an application, but could that be implemented within the website? Any thoughts? I don't want the user to install anything on their hardrive if possible. thanks!
2
3963
by: Alex_Bxl | last post by:
Hi to all I have to choose a DBMS and a database architecture for an Ebay like website about to be launched. The company wants to use a web hosting service and not host the database on dedicated servers at the office. The database will contain web-only information and lots of back end information that is not really needed to be stored on the web host.
2
1276
by: Brenda | last post by:
Is it possible to Syncronize with a CD to Access Runtime? I have a program that needs to be updated yearly and we are trying to find the best way to distribute it and then update it without loosing the data that is entered in the mean time. Some of the computers have Access and some do not, so runtime must be included, but I am not sure how to update querys and forms that can be distributed without loosing data. I would also like to know...
0
988
by: Rob Smeets | last post by:
Hi, i'm trying to grasp the concept of syncronizing threads, but without success Here is the situation: I'm using an object which connects to a server. After connection i want to send informational requests. If i send a request and the object is not connected yet i tell the Component to connect(sub RequestInfo).
0
1177
by: mmcquade.forums | last post by:
Hey everyone, Let me give you a rundown on our setup. We're a small, small firm, so please take this setup with a grain of salt, with both of us knowing it's probably not the best setup ever (and I'm more than happy to hear suggestions). On our webserver we have a MySQL database that collects information on our clients (name, address, etc) when they fill out a form to sign up.
4
1487
by: SAL | last post by:
I'm trying to use the website configuration tool and it keeps telling me that it is unable to connect the SQL Server Database. I do not have SQL Server Express installed. I have the real deal installed on my development box. Is this the problem or is there someway to tell this tool that I'm using and named instance of SQL Server. I ran the aspnet_regsql.exe tool and it installed the aspnetdb database in the server. In the...
2
1555
by: =?Utf-8?B?Tkg=?= | last post by:
Hi, I have an asp.net 2.0 website and a sql database on the same server. In the web config file I have set up a connection to the database using this connection string.... connectionString="Data Source=myServer;Initial Catalog=MyDatabase;Persist Security Info=True;User ID=LoginUser;Password=LoginPassword" providerName="System.Data.SqlClient" />
2
1674
by: =?Utf-8?B?R2lkaQ==?= | last post by:
Hi, I've created a ASP.NET application on my pc using visual studio and it works fine. when i moved it to my web server (another pc with IIS) and surf to my website, the website comes up but for some reason doesn't connect to the database. from the visual studio i could connect to the same database as i'm trying now.
1
1058
by: Bobby Edward | last post by:
Here's the situation.... 1. Local dev environment is VS2005 and VS2008 / using SQL Express databases for data 2. Hosting company ONLY supports MS SQL Server 2005 databases Here are the questions... 1. Should I develop using SQL Express, or would my life be easier if I had my local dev machine connected to a local SQL Server db? Any advantages or
0
8889
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9257
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
9116
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
8099
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
6702
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6011
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4519
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
1
3228
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
2637
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.