Can I update a non-sql server database from within a sql server stored procedure?

Question

Is it possible to update a different ODBC database from withing a SQL Server Stored Procedure. For example, say I have Access, MySQL, etc. I update my SQL Server database and I want the stored procedure to update the other ODBC database. Kind of like a poor man's replication.

Is there a better way to replicate between different database systems?

Thank you for any help.

Answer 1

Adding a Linked Server should solve your problem. You have a choice of providers, including ODBC.

http://msdn.microsoft.com/en-us/library/ms188279.aspx