Jose Bredariol
asked on
PH copy tables from MSSQL to MYSQL
Hi, I need php code to copy a table from MS SQL to MYSQL.
How are you currently accessing the MS SQL server?
ASKER
I´m not accessing it yet. MSSQL is on my windows server (2008R2) and there we use asp and .net. Now I want some tables on my new server linux debian with php. I´m accessing MYSQL using :
mysql_connect($hostname, $username, $password) or die(mysql_error());
mysql_select_db("DATABASEN AME") or die(mysql_error());
mysql_connect($hostname, $username, $password) or die(mysql_error());
mysql_select_db("DATABASEN
You should write a program that runs on the Windows Server to fetch the data you need and send it to your Linux server. To get the data from a PHP program on your Linux server can be difficult. You would first have to make sure that TCP/IP and remote connections are enabled on your MS SQL server. Then you would have to struggle thru setting up FreeTDS on Linux. And even then you may find that FreeTDS does not support all of the data types that are available in SQL Server 2008 and newer.
ASKER
Yes, TCP/IP and remote connections are enabled on your MS SQL server. I can´t do that on Linux using PHP ? Are you sure ?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks all