We ported WP to SQL Server almost three years and have been maintaining it ever since. Provided you are planning to use SQL Express 2012 or higher, this should be the solution you are looking for:
Simply put, replacing WPDB isn’t enough. So we went a step further and rewrote any MySQL-specific syntax within Core. Our primary reason for doing this was to take advantage of the native PaaS offerings from Azure. Over the past three years it has grown to include others who want to run WordPress but for reasons of policy, principle, or simple preference do not run MySQL. They range from SQL Server user groups to Fortune 100 companies looking to maximize investment in their current DBAs.
Related Posts:
- Sub-domain or 2nd, temporary different domain?
- Cloning and syncing a WordPress website
- WordPress showing install screen after max_questions error
- Database sync between local and production
- Trigger Plugin database update after git pull
- Export all content from wordpress
- Automate dir and DB stack creation with WP-CLI
- Error establishing a database connection on Installation
- How can I (semi) automate a database export and import to a different location?
- “Database Connection Error” upon install in Apache VirtualHost document root.. Why did this happen? [closed]
- Migrating from PDO using SQLite to clean new install using MySQL
- Selectively restoring original posts from a compromised site to a freshly installed WordPress database
- Moving to another server database connection error [closed]
- Is it possible to have more than 1 MySQL database in my WordPress blog?
- Create database on installation
- Reinstalling wordpress from database breaks the site
- Choosing http or https during manual installation of WordPress and database
- Installation question
- Multiple WordPress sites installs sharing the same database but with different content and domains
- Image link issues after importing a database backup to my local web server
- Database create or redirect
- New installation fatal error in 5.9.3 at edit or create entry
- WordPress credentials not matched
- unable to use my wordpress site after moving
- I have a WordPress 4.6 database dump – how do I use it in a new install?
- Copy WordPress to new directory
- Does WordPress Support Using Named Pipes on the Windows Operating System?
- Can’t Install WordPress (local) Failed to open file wp-includes/wp-db.php
- Why is wordpress trying to re-install itself?
- Install WordPress with SQL database
- Getting an error when trying to migrate to DV server from Grid with Media Temple [closed]
- WordPress can’t fetch the posts from the database after moving to new server [closed]
- What is this JavaScript “require”?
- Using wpdb to connect to a separate database
- How can I make updates to a site, on a development copy, but then move updates back without overriding live site’s evolving database?
- How can I make a WordPress database portable and url independent?
- wpdb->insert multiple record at once
- How to migrate a HTTPS WordPress installation to localhost?
- How to stop WordPress using utf8mb4_unicode_520_ci collation?
- How to monitor server for error establishing a database connection
- Exporting revisions
- WP_Options ID high
- Default WordPress settings API data sanitization
- Fatal error: Call to undefined function dbDelta()
- Connect to remote database using Localhost install
- How to ensure data consistency in WordPress
- How to intercept update_option() before it saves data?
- wpdb query on custom table not working [closed]
- WordPress doesn’t show all posts in database
- Adding new row to wp_post table
- Extracting the post_id via the wp_insert_post action (external db query)
- How to interact with another wordpress install on same database?
- What is the proper way to validate and sanitize JSON response from REST API?
- How do I get the posts within a certain year/date(with sql query)?
- batch UPDATE autoload value in wp_options table
- Displaying BLOB PDF File
- Saving into post_excerpt or post_content
- Maintain user profile data in a non-WordPress database
- How to fix the disappearance of the “\” character when updating a post in the database
- Data storage for JS app using WP REST API
- Setup 3 Sites To Connect To 1 Database and Share Data
- How can I push local database changes to production, without impacting recent posts/pages that were published on production server?
- Setup private content for specific users with daily updates [closed]
- Does auto_load to ‘no’ in wp_options improve performance
- Error message on blog posts only on my local environment [closed]
- how to read database fields
- $wpdb->query can’t insert data
- WSOD 3.9.1 – Tried Everything so far
- Can you refresh ONLY the wordpress adminbar and not the whole page?
- Sending posts from Python to WordPress
- Problem migrating to localhost
- How can I detect right db type?
- Add search bar to Custom Database Table in WordPress Dashboard
- Design problems when exporting remote database for local development
- How do you render posts from outside wordpress?
- A change in URL slug in database returns 404, how can I do auto-redirect?
- Second ezSQL initialization for MSSQL
- Fetch a single row from a custom table for to a given ID
- Database structure cheatsheet
- White Screen in Home Page
- Continuous SQL query errors from outside source
- How to escape percentage sign(%) in sql query with $wpdb->prepare?
- Recovery – Restore Database after moving folder location locally
- Migrate Users From laravel to wordpress
- WordPress has been updated! Before we send you on your way, we have to update your database to the newest version
- how add more field to wp user and save it to database
- How do I cleanup my database with data that is no longer being used?
- Malware in old website – how to migrate?
- How to display $wpdb->insert_id; value on redirected page
- database – multiple wordpress installations using same database – can they share plugin settings?
- Should I Use only wpdb Class to Write Custom Queries?
- Auto populate form fields based on serial input or pull listings from other websites?
- Wrong url for the images while using same database for two WordPress installations
- Sending WordPress database information to cross domain the safe way?
- Database Name Change
- Weird characters in title if it contain “ ”
- Where To Find bb_profile_data(); In bbPress?
- One information repeated on multiple locations on one site [closed]
- Showing Error(TAble already exist)
- Many images in wp-content/uploads folder that are not in Media Library