How can PHP be used to read an entire table from MSSQL and transfer it to MySQL?

To transfer an entire table from MSSQL to MySQL using PHP, you can connect to both databases, retrieve the data from MSSQL, and then insert it into MySQL. You can achieve this by querying the MSSQL database to fetch the data, and then executing insert queries on the MySQL database to transfer the data. 

// Connect to MSSQL
$server = "mssql_server";
$username = "mssql_username";
$password = "mssql_password";
$database = "mssql_database";
$connMSSQL = mssql_connect($server, $username, $password);
mssql_select_db($database, $connMSSQL);

// Connect to MySQL
$mysqlServer = "mysql_server";
$mysqlUsername = "mysql_username";
$mysqlPassword = "mysql_password";
$mysqlDatabase = "mysql_database";
$connMySQL = mysqli_connect($mysqlServer, $mysqlUsername, $mysqlPassword, $mysqlDatabase);

// Retrieve data from MSSQL
$query = "SELECT * FROM mssql_table";
$result = mssql_query($query, $connMSSQL);

// Insert data into MySQL
while ($row = mssql_fetch_array($result)) {
    $values = implode("', '", $row);
    $insertQuery = "INSERT INTO mysql_table VALUES ('$values')";
    mysqli_query($connMySQL, $insertQuery);
}

// Close connections
mssql_close($connMSSQL);
mysqli_close($connMySQL);

Keywords

PHP MSSQL MySQL data transfer table reading

Related Questions