[Webinar] Streamline your web hosting managementRegister Today


Send registers froma database to a server database (mysql)

Posted on 2008-01-24
Medium Priority
Last Modified: 2010-04-05
Hi guys,

I have in a internet server a MySQL database. I wrote a delphi program that creates a local database and I want to be able to send the registers created to the server's MySQL database.

How I can add this to my program, or rephrasing the question... How I can send data registers from a local table (in my computer) to a MySQL server database thru delphi?

Any ideas?

best regards
Question by:lopem
LVL 21

Accepted Solution

developmentguru earned 500 total points
ID: 20742955
 This could be a complicated issue.  If you want to send data records from one table locally to the server side then you can open a query on the local, and for each record, run an insert query on the server.  If you are ok with deleting all records on the server before reproducing them this would be easy.  If on the other hand, you need to try to do a more elegant synchronization then it can be a lot more work.

  As an example... if you wanted to synchronize purchase orders then you would need to synchronize the header and all of the line items (and any other associated tables).  This would involve determining if the record exists on the server.  If it does then you need to update it.  If it does not you need to insert a new one.  Generally all of the updates are done inside a transaction so it all happens or none of it happens.  If you have multiple outside users doing synchronization then you need to have a unique ID for all locations so you can determine if the record exists or not.

  Basically we would need to know more about what, precisely, you are attempting.  Connecting to both database servers is the easy part.

Let me know when you can give me more info to go on.
LVL 16

Assisted Solution

CodedK earned 500 total points
ID: 20747468
I agree with developmentguru and i want to add this :

I suppose since you created both local and remote database you know how to do the queries.
If your problem is only how to make both databases talk and exchange data then this is fairly simple.
I strongly recommend AnyDAC its the best by far and its free.
They are going to remove the link soon cause another company bought it so download it...
As soon as you set the remote connection password you are ready to go...
Drop another AnyDac component on the form for the local connection and start querying.


Featured Post

[Webinar] Kill tickets & tabs using PowerShell

Are you tired of cycling through the same browser tabs everyday to close the same repetitive tickets? In this webinar JumpCloud will show how you can leverage RESTful APIs to build your own PowerShell modules to kill tickets & tabs using the PowerShell command Invoke-RestMethod.

Question has a verified solution.

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

Introduction The parallel port is a very commonly known port, it was widely used to connect a printer to the PC, if you look at the back of your computer, for those who don't have newer computers, there will be a port with 25 pins and a small print…
This is an update to some code that someone else posted on Experts Exchange. It is an alternate approach, I think a little easier to use, & makes sure that things like the Task Bar will update.
Planning to migrate your EDB file(s) to a new or an existing Outlook PST file? This video will guide you how to convert EDB file(s) to PST. Besides this, it also describes, how one can easily search any item(s) from multiple folders or mailboxes…
This video tutorial shows you the steps to go through to set up what I believe to be the best email app on the android platform to read Exchange mail.  Get the app on your phone: The first step is to make sure you have the Samsung Email app on your …
Suggested Courses
Course of the Month10 days, 5 hours left to enroll

591 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