Manual:Microsoft SQL Server

From MediaWiki.org
Jump to: navigation, search
Manual:Contents MediaWiki database layout Microsoft SQL Server


Microsoft SQL Server support on MediaWiki is of experimental quality. Generally, all wiki features should work using the database, however there may be issues blocking usage of some common features. T11767 is tracking all known bugs with Microsoft SQL Server. Microsoft SQL Server has been supported since MediaWiki 1.23, and is best supported on the LTS releases of MediaWiki. Non-LTS releases have diminished support, and the database may not work at all on them.

Server requirements[edit]

Microsoft SQL Server 2008 R2 or later and Azure SQL are supported, however running the latest version of SQL Server is recommended. The Express editions are not supported.

Client requirements[edit]

PHP must have the sqlsrv extension installed and enabled. This driver only works on Windows, and as such it is not possible at this time to have MediaWiki on linux or other operating systems connecting to Microsoft SQL Server.

Installation[edit]

Follow the prompts in the installer to install MediaWiki on Microsoft SQL Server. You can either create a new database during installation or use an existing one. The installation user should have the dbowner role for the database (if using an existing database) or the sysadmin role (if creating a new database). The database user for normal wiki operation should have the db_datareader and db_datawriter roles. If creating a new database user as part of the installation, it will be granted the minimum set of permissions needed in order to make the wiki functional.

DatabasesManual:Database layout Engines: MySQL/MariaDBManual:MySQLOracleManual:OraclePostgreSQLManual:PostgreSQLSQLiteManual:SQLiteSQL ServerManual:Microsoft SQL Server

Technical documentation: SchemaManual:Database layout (tablesCategory:MediaWiki database tables) – API property associationsAPI:Database field and API property associationsField prefixesDatabase field prefixesPrimary key storage in other fieldsManual:Primary key storage in other fieldsWikimedia extension tablesCategory:Wikimedia extension database tables
Configuration: SettingsManual:Configuration_settings#Database_settingsSharingManual:Shared database
Development: AccessManual:Database accessOptimizationDatabase optimizationPolicyDevelopment policy#Database_patchesUpdaterManual:DatabaseUpdater.phpExtension schema updatesManual:Hooks/LoadExtensionSchemaUpdatesPatch fileManual:SQL patch file

Core tables: archivebot_passwordscategorycategorylinkschange_tagcommentconfigexternallinksfilearchivehitcounterimageimagelinksimage_comment_tempinterwikiiwlinksipblocksip_changesjobl10n_cachelanglinkslogginglog_searchmsg_resourcemsg_resource_linksmodule_depsobjectcacheoldimagepagepagelinkspage_propspage_restrictionsprotected_titlesquerycachequerycachetwoquerycache_inforecentchangesredirectrevisionrevision_comment_tempsearchindexsitessite_identifiers - site_statstag_summarytemplatelinkstexttranscacheupdateloguploadstashuseruser_former_groupsuser_groupsuser_newtalkuser_propertiestag_summaryvalid_tagwatchlist