473,846 Members | 1,891 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 2925

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

Similar topics

4
1464
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
3972
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
1278
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
991
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
1183
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
1496
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
1561
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
1678
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
1064
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
10976
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
1
10705
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
9477
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
7877
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
7050
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
5714
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...
0
5906
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
4111
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
3157
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.