I have a Microsoft SQL Server 2005 Database inhouse I have to publish some information on the internet and I can't (for security policy) query this database from the web server.
So I came up with the solution of replicating the information (contained in 3 views) from my SQL Server to a MySQL server on the web server.
I have to schedule this synchronization (one way SQL Server always overwrites MySQL) every night. Ideally SQL Server should push updates into MySQL server (so security ninjas are satisfied).
I read some article about but I have no clue where to begin.
I'm familiar with PHP, Python. Preferably I'd like to realize this with the internal schedule of SQL Server and a stored procedure or a maintenance task
Thank you in advance