mysql到sql server迁移 [英] mysql to sql server migration

问题描述

在将数据库从mysql迁移到sql server 2000之后，我需要在我的php代码中应用哪些更改。请帮助..

What are the changes i needed to apply in my php code after migrating database from mysql to sql server 2000. please help..

推荐答案

大多数情况下你需要处理数据库连接，执行，检索数据，当然还有查询。



1. 使用MySQL迁移PHP应用程序到SQL Server在IIS上运行PHP [ ^ ]

2. 将MySQL查询转换为MS SQL Server查询 [ ^ ]

Mostly you need to take care of Database Connections, Execution, Retrieval of data and of course the queries.

1. Migrating a PHP Application using MySQL to SQL Server running PHP on IIS[^]
2. Converting MySQL Queries to MS SQL Server Queries[^]

同意解决方案1.主要内容是提供者/驱动程序，连接字符串，安装，在将产品转移到生产环境之前，请确保测试服务器中的内容非常完美。



查看这些内容以获取更多详细信息

使用PHP访问SQL Server数据库 [ ^ ]

< a href =http://technet.microsoft.com/en-us/library/cc966396.aspx>将MySQL迁移到Microsoft SQL Server 2000 [ ^ ]

安装MSSQL for PHP [ ^ ]

使用SQL Server Express在Windows上开始使用PHP [ ^ ]

Agree with solution 1. Main things are provider/driver, connection string, Installations, etc., Before moving things to production, make sure things are perfect in test server.

Check these for more details
Accessing SQL Server Databases with PHP[^]
Migrating MySQL to Microsoft SQL Server 2000[^]
Installing MSSQL for PHP[^]
Get Started with PHP on Windows with SQL Server Express[^]

这篇关于mysql到sql server迁移的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！