473,592 Members | 2,921 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Database transfer via web service question

I already spent some time thinking for a solution for my problem, but finally
can't decide what would be the most optimal and correct solution. Therefore I
post my question to this forum, to get your opinion.
On a regular basis (eg every 10 minutes or after user initiation) the
content of several MySQL database tables (on a pc/laptop client) need to be
transfered (over the Internet) (synced) with a SQL Server 2005 db (hosted on
a server) with the exact same structure as the MySQL tables. The size
of/number of rows of the different MySQL tables to be transfered is not that
impressive. Since the source MySQL db is the db of a third party application
I prefer not to add/change anything in this db, thus i want to only
reading/querying this db. The data that needs to be transfered is no
sensitive data security wise. My concern is also eventually a lost Internet
connection so that the db's are out of sync.

I see several possibilities to achieve this but to my opinion I think using
a web service, option 1 hereunder, would be the most interesting one:

1. passing a DataSet (of all the tables of the db that everytime needs to be
transfered at once) from the client to a webservice on the server where SQL
Server 2005 resides. Is this realistic, and can this assure the db's stay in
sync (by using transactions on the server side when loading all tables coming
from the DataSet)?

2. creating an (1) xml or plain ascii file containing all data from the
different tables on the client and transfering to the server, via a web
service, and processing this file?

3. querying the MySQL source db and directly inserting in the SQL Server db,
BUT this will probably have an impact when there's a lost Internet connection
since at that time a rollback on the server (due to the lost connection)
isn't possible anymore?

4. Using Synchronization Services for ADO.NET, but this would mean I need to
install an additional SQL Compact on the client, and transfering the MySQL
data to this SQL Compact db. And on its turn this SQL Compact synchronizes
with the SQL Server db on the server? Does my ISP has to take special action
to use Synchronization Services, since I have no impact on my ISP?

5. Other solution(s)???? ?

Many thanks for your info/feedback.
Jun 1 '08 #1
0 1224

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

Similar topics

2
3929
by: Simon | last post by:
Hi, I am having a little problem with my PHP - MySQl code, I have two tables (shown below) and I am trying populate a template page with data from both. <disclaimer>Now I would like to say my skills, especially with MySQL are rudimentary</disclaimer> However my code (link below) fails, the nested database call does not return any data and this has me stumped. Any help will be much appreciated. Many thanks in advance
3
2561
by: tomyboy | last post by:
Read this from Dev Ashish http://www.mvps.org/accessfr/forms/frm0034.htm for opening a form in an other db This seems useful for my job I've a db named INVOICING making invoice and a 2nd db name Mini_D_ASDEV checking debit/payment, without relation between them Then, 1st : is this /frm0034.htm working with Access 2002 under XP as well? 2nd : my form OPENED is INVOICE from db INVOICING
4
2136
by: Weston Weems | last post by:
I've got the simple problem where I'd like to transfer somewhat large files to my webserver via http/webservice/something like that. My question is what kinda limits have people been able to hit? Is 500mb unreasonable or not. Client doesnt have to be a typical webbrowser, so I could theoretically chunk it up and send chunks to the server, when completed, re- assemble and write file etc.
2
5767
by: Eric | last post by:
Hi, I have a .NET client and Java web service. I send an request and the answer with a correct SOAP message. But on the .NET client I get an exeption from the XML deserializer that he has found characters which he doesn't understand. When I look at the respond (via network monitor), I see that the message was
2
1861
by: Alex | last post by:
Hello, Quick question and I would really appreciate if anybody could helps me. Here are the steps to reproduce the problem. Create simple ASP.Net application. In code behind added protected class variable: protected string _result = "No result"; Page Load event has:
2
3024
by: steve | last post by:
Hi All I need to learn how to update a SQl server or Access database located on a web server from my windows forms application, via the internet I have a customer who wants to run several windows forms applications in different shop locations but all have to update a Web based database with products sold etc Is Web services the way to go? or are there better options
4
11291
by: HeislerKurt | last post by:
I'm having trouble opening a database a client has sent me. I keep getting an "unrecognized database format" error. The database was created in Access 2003. I'm trying to open it with Access 2003. The client can open it on her computer with no problem, and she was able to compact and repair it, and resend it with no problem. Yet I still get the error. If the database is corrupt, I would suspect that she'd be getting errors on her end,...
0
827
by: =?Utf-8?B?R3V5?= | last post by:
I already spent some time thinking for a solution for my problem, but finally can't decide what would be the most optimal and correct solution. Therefore I post my question to this forum, to get your opinion. On a regular basis (eg every 10 minutes or after user initiation) the content of several MySQL database tables (on a pc/laptop client) need to be transfered (over the Internet) (synced) with a SQL Server 2005 db (hosted on a server)...
9
2664
by: =?Utf-8?B?TUNN?= | last post by:
I'm sure the answer to my question varies depending on the situation, but I am looking for a general "best practice". If I have an asp.net application and I load certain data from a database, should I use ViewState to store and reload the data, or should I load the data from the database on each postback? Assume for the sake of this question that I only care about performance, I don't care about ease of programming.
0
7935
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
7871
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
8236
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...
0
8366
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
8227
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
5400
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
3851
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
3893
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2379
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

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.