This plugin provides db access abstraction and SQL dialect abstraction for SQL Server.
It is an mu (Must-Use) plugin AND also a db.php drop-in.
|Author:||Anthony Gentile and Elizabeth M Smith (profile at wordpress.org)|
|WordPress version required:||3.0|
|WordPress version tested:||3.3.2|
|Added to WordPress repository:||02-03-2011|
Warning! This plugin has not been updated in over 2 years. It may no longer be maintained or supported and may have compatibility issues when used with more recent versions of WordPress.
|Total downloads:||21 977|
Click to start download
WP Database Abstraction is a plugin to make it possible to run WP on top of MS SQL Server or Azure and provides two features, database access abstraction and SQL dialect abstraction. This plugin cannot be installed or used as a regular plugin, it must be in the "mu-plugins" directory (must use plugins) and in addition to the plugin it contains a "drop-in" to hook into WordPress Database functionality.
Database Access Abstraction is the way you connect to the database through PHP. This plugin allows mysql, mysqli, pdo, sqlsrv or mssql extensions to be used. PDO has support for mssql, dblib, sqlsrv and mysql drivers. This allows you to choose the way your WordPress installation connects to your database. You can use the plugin and still use a Mysql Database, which is perfect if your hosting provider does not make the mysql extension available. The flexible structure of the plugin means that dropping in additional drivers is easy.
SQL dialect abstraction means translating from the dialect understood by Mysql to other dialects. Currently only translation layers for T-SQL (used by Azure and SQL Server) are provided. However this is an open source project and additional translation layers could be added.
For help and support please see the sourceforge project http://sourceforge.net/projects/wp-sqlsrv/
For information and tutorials please visit our blog http://wordpress.visitmix.com/