MySQL 如何在 MS SQL 上安装 wordpress
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/2293153/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
How to install wordpress on MS SQL
提问by bvandrunen
I am trying to convert my wordpress site which is based on MYSQl to a MS SQL because my we have our main database through MS SQL and we are creating database driven wordpress sites. I have been able to automate all of our wordpress installation + setup through database scripts through MYSQL but all of our variables + inputs are in MS SQL.
我正在尝试将我的基于 MYSQl 的 wordpress 站点转换为 MS SQL，因为我们通过 MS SQL 拥有我们的主数据库，并且我们正在创建数据库驱动的 wordpress 站点。我已经能够通过 MYSQL 通过数据库脚本自动完成我们所有的 wordpress 安装 + 设置，但我们所有的变量 + 输入都在 MS SQL 中。
Would it be easier to create a new database in MYSQL and migrate all of my data over from MS SQL or is there a way to have wordpress use MS SQL. I am wondering if anyone has been able to do this or has any hints. Thanks
在 MYSQL 中创建一个新数据库并从 MS SQL 迁移我的所有数据会更容易，还是有办法让 wordpress 使用 MS SQL。我想知道是否有人能够做到这一点或有任何提示。谢谢
EDIT/UPDATE: I have accomplished this by using a linked server. Hereis a website if anyone else is reading this and wants to run the wordpress database by using Microsoft SQL Server Management Studio:
编辑/更新：我通过使用链接服务器完成了这项工作。如果其他人正在阅读本文并希望使用 Microsoft SQL Server Management Studio 运行 wordpress 数据库，请访问以下网站：
采纳答案by johannes
You can't. Even when migrating the data over Wordpress would still use MySQL specific API calls and MySQL specific SQL statements, you'd first have to refactor the whole codebase in order to make it compatible.
你不能。即使在 Wordpress 上迁移数据时仍会使用 MySQL 特定的 API 调用和 MySQL 特定的 SQL 语句，您首先必须重构整个代码库以使其兼容。
回答by Harry Love
It is definitely possible to run WordPress connecting to MS SQL Server. We are running such an instance in production at my company. Here are two posts that describe the process of using WordPress with MS SQL Server and IIS. I am using such a configuration right now on my local box.
绝对可以运行连接到 MS SQL Server 的 WordPress。我们正在我公司的生产环境中运行这样一个实例。这里有两篇文章描述了在 MS SQL Server 和 IIS 中使用 WordPress 的过程。我现在在我的本地机器上使用这样的配置。
http://techsugar.wordpress.com/2011/03/02/how-to-install-wordpress-on-iis-7-5-using-sql-server-2008/
http://techsugar.wordpress.com/2011/03/02/how-to-install-wordpress-on-iis-7-5-using-sql-server-2008/
http://wordpress.visitmix.com/development/installing-wordpress-on-sql-server
http://wordpress.visitmix.com/development/installing-wordpress-on-sql-server
回答by Pekka
There is no feasible way to do this. MS SQL support is an open request in WordPress's bug tracking system.
没有可行的方法来做到这一点。MS SQL 支持是 WordPress错误跟踪系统中的一个开放请求。
Hereis a blog entry from a guy who tried it. It didn't end well.
这是一个尝试过的人的博客条目。结局并不好。
For completeness's sake, there seems to be an approachthat is in alpha Stadium (Not suitable for everyday use!) that may one day become a workable workaround. wordpress-mssql
为了完整起见，似乎有一种方法在 alpha 体育场（不适合日常使用！），有一天可能会成为一种可行的解决方法。wordpress-mssql
回答by Jallen
So we are running Wordpress 3 with MS SQL 2008 under IIS 7 and the Wincache plugin and it's great. The trick is as another poster suggested is the MySQL that exists in many plugins. The project is here http://sourceforge.net/projects/wp-sqlsrv/
所以我们在 IIS 7 和 Wincache 插件下使用 MS SQL 2008 运行 Wordpress 3，它很棒。诀窍是另一张海报建议的是存在于许多插件中的 MySQL。该项目在这里http://sourceforge.net/projects/wp-sqlsrv/
回答by Spencer Cameron-Morin
WordPress won't natively run MSSQL. However, an up-to-date fork that supports MSSQL does exist.
WordPress 本身不会运行 MSSQL。但是，确实存在支持 MSSQL 的最新分支。
