We have a client that wants to migrate a large amount of data from mssql 2000, we are on a linux server w/ php 4.4.4. I have installed the freetds and have tried everywhere to get the php-mssql-4.4.4 or php-odbc-4.4 to use php to migrate the data. From what I understand the php-mssql version has to be the same as the php version on the server. Are there any workarounds, fixes, or solutions to get this data migrated?
what about exports to text files and loading via mysql load? Not the most elegant solution...
another thought is could you create a windows php mysql install and then use php/mssql functionality to load the windows table? If they are myisam tables you can just copy them across to the linux server
Have a look at the MySQL Migration Tool to do this.
we have tried several options to update a linux server to handle the transfer but nothing worked, so the solution will be to find a windows based server w/ apache, mysql, php, and that can handle mssql....
This should be easy using a DTS package inside SQL Enterprise Manager. It can connect to any ODBC datasource (your MySQL database). No need for php or Apache.
