Page 1 of 1
PHP and MySQL/MS-SQL
Posted: Mon Jul 18, 2005 9:16 am
by quadoc
I've a web page written in PHP and MySql. Could someone tells me if I can convert it to use MS-SQL instead of MySQL? What is involve? Thanks...
Posted: Mon Jul 18, 2005 10:01 am
by pickle
I highly doubt Microsoft has anything built into their database to allow them to read directly from other databases. There are two things I can think of:
1) Make a mysqldump and try to import that into MSSQL - I've never done it, but it might work.
2) Write some code to manually get all the data from your MySQL database and dump it in a (CSV) text file. Then, write some more code that reads from that text file and dumps it into MSSQL (or just write one page to go direct).
1 question - why are you going from MySQL (champion of the people) to MSSQL (public enemy #1 through #27). Needless to say, I'm completely objective

Posted: Mon Jul 18, 2005 10:57 am
by quadoc
Thanks for the tips pickle.
And I completely agreed with your question. But it wasn't my choice to convert from MySQL (champion of the people) to MSSQL (public enemy #1 through #27).
