?
Solved

Can triggers effect remote databases?

Posted on 2007-03-20
2
Medium Priority
?
207 Views
Last Modified: 2010-03-19
Is it possible to create a trigger on a MS/SQL database to update a remote MySQL database, or are triggers intended to make local changes only?
0
Comment
Question by:bemara57
2 Comments
 
LVL 9

Accepted Solution

by:
nito8300 earned 1400 total points
ID: 18761621
you can try to do something like
Update MySQL.Database.Table
Set Field1 = 'Your Value'

You would have to add the server as a linked server.
0
 
LVL 42

Assisted Solution

by:dqmq
dqmq earned 600 total points
ID: 18761631
While I can't claim it's advisable, it's certainly possible for a trigger to update a database on a linked server. This should head you the right direction:

http://msdn.microsoft.com/msdnmag/issues/04/11/DataPoints/
0

Featured Post

Configuration Guide and Best Practices

Read the guide to learn how to orchestrate Data ONTAP, create application-consistent backups and enable fast recovery from NetApp storage snapshots. Version 9.5 also contains performance and scalability enhancements to meet the needs of the largest enterprise environments.

Question has a verified solution.

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

In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
In this article, we’ll look at how to deploy ProxySQL.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Suggested Courses

850 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