Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 594
  • Last Modified:

How to update MySQL web server with data from SQL Server 2000

Hi all.

I have a website whose database is MySQL and I would like to update some fields in some of the tables from my Access application whose backend is SQL Server 2000.

Is this possible? To be able to update a MySQL table that is on a web server from my application in our office? How?

Thank you in advance.
0
Sim1980
Asked:
Sim1980
  • 2
1 Solution
 
Ray PaseurCommented:
I think a dependable way to do this would be to write a "web service" script.  You would install this script on your office application and expose the URL to the WWW.  Then your website with MySQL could call upon the URL to retrieve the information.  It's not rocket science, but it has a lot of moving parts, so you might consider hiring a professional developer to help you through this.
0
 
edtechdbaCommented:
What about setting up a linked SQL server on your SQL Server 2000 database to the MySQL database and then perform updates that way? This may be an option if the update processing isn't too intensive.

Here's an example of how to set up a SQL linked server to a MySQL database:
http://www.ideaexcursion.com/2009/02/25/howto-setup-sql-server-linked-server-to-mysql/

Once your linked server is set up to your MySQL database, then you should be able to perform update commands using the linked server to update your MySQL tables.

Here's an example of an update command using OPENQUERY:
UPDATE OPENQUERY (LinkedServerName, 'SELECT name FROM student WHERE id = 1')
SET name = 'StudentNameTest';

I hope that helps!
0
 
Sim1980Author Commented:
Thanks edtechdba.
0
 
edtechdbaCommented:
You're welcome, good luck!
0

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now