Copy link to clipboard
Copied
Hello,
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.
Best regards,
Yogesh Mahadnac.
Copy link to clipboard
Copied
Make this:
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.
a webservice that you can call from php.
Copy link to clipboard
Copied
Thanks a lot for your reply Dan.
I'll definitely give it a try.
Best regards,
Yogesh Mahadnac.
Copy link to clipboard
Copied
Use just one database: MySQL in UTF-8 encoding. Then ColdFusion, PHP, ASP, .NET, or whichever, may connect to it, update it or read from it. MySQL doesn't know which is which, and doesn't care.