Schedule replication of SQL Server views to MySQL remote database 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
You'll want to look at SQL Server Replication.  If you just want a one time nightly feed then you'll probably want Snapshot Replication.  If you want a more real time feed then you'll want to look at Transactional Replication.

Now replication doesn't support replicating the views, so you'll need to replicate the base tables, removing any columns which aren't needed by the website then create the views on the MySQL database.