Since the MSSQL driver isn't compiled in my PHP installation, I can't connect to a SQL Server database from PHP.
Therefore, I have created a SQL Server connection in my CF Admin page and I've created a small script that's reading records from the SQL Server database and inserting/updating my table in MySQL.
Now, owing to UTF-8 encoding, I've created another function in PHP that actually reads the synchronised records and updates them into UTF-8 e.g. for french accents, etc.
The above situation works great, however, there are 2 files actually -
Ideally, every time I lauch the application (which runs mainly on PHP), it should synchronise the SQL Server and the MySQL databases so that data is consistent.
Now, I'm having 2 files for that matter.
How do I
So that, in the end, I only need to call 1 single file which does everything.
Thanks in advance for your help.
Europe, Middle East and Africa