SQL Server 2005 SQLAgent Triggers

I need to set up a SQL Server trigger to connect to a remote mysql linux server and insert data into a table. Is there a way to do this?

I'm leaning towards triggers rather than scheduled tasks because the trigger will execute each time data is entered/updated in the SQL Server table and only 1 record will be passed to the MySQL table at a time, cutting down on lar开发者_开发知识库ge data transfers and creating a more 'realtime' transfer appearance.

You don't need a trigger for this.

Create a linked server to the remote server, create a stored procedure to insert the data into the linked server and then schedule a task under SQL Agent to run the stored procedure.

• Writing a Stored Procedure
• How to: Schedule a Job