Hi Jai, I have experience doing this in linux, with freetds libraries ( allows PHP to access MSSQL server) and enables the mssql functions in PHP. Use them just as you would the MySQL functions...
I would recommend using MySQL to store a copy of the data, and do a sync periodically (with a PHP cron job) between the two. Cheers, Stig Jai Ivarsson wrote: > Hey, does anyone have any experience calling data from SQL Server? I > have a PHP/MySQL web app that needs to pull some information from a > few table in mssql and store info in the MySql tables that refer to > id's in the mssql tables. > > Has anyone got any ideas on the best way to tackle this? Perhaps it > could be nice and easy and have MySql create a views of the mssql tables? --~--~---------~--~----~------------~-------~--~----~ NZ PHP Users Group: http://groups.google.com/group/nzphpug To post, send email to [email protected] To unsubscribe, send email to [email protected] -~----------~----~----~----~------~----~------~--~---
