How to install wordpress on MS SQL

Very important

To access the important data of the forums, you must be active in each forum and especially in the leaks and database leaks section, send data and after sending the data and activity, data and important content will be opened and visible for you.
You will only see chat messages from people who are at or below your level.
More than 500,000 database leaks and millions of account leaks are waiting for you, so access and view with more activity.
Many important data are inactive and inaccessible for you, so open them with activity. (This will be done automatically)

Thread Rating:

674 Vote(s) - 3.51 Average
1
2
3
4
5

Options

How to install wordpress on MS SQL

preforgive675243

Member

Member

Posts: 0
Threads: 0
Joined: Dec 2019
Reputation: 0

Level: inf [ Level

Level

]
Total Points: inf
Rank nan / 1
100% to upload Level

Rank

Activity inf / 1
99% to upload your Rank

Activity

Experience nan
100% to upload Experience

Experience

Points: 50

#1

07-27-2023, 10:56 AM

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.

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

EDIT/UPDATE: I have accomplished this by using a linked server. [Here][1] is a website if anyone else is reading this and wants to run the wordpress database by using Microsoft SQL Server Management Studio:

[1]:

[To see links please register here]

konstancejptlxj

Valued member

Valued member

Posts: 0
Threads: 0
Joined: Nov 2021
Reputation: 0

Level: inf [ Level

Level

]
Total Points: inf
Rank nan / 1
100% to upload Level

Rank

Activity inf / 1
99% to upload your Rank

Activity

Experience nan
100% to upload Experience

Experience

Points: 50

#2

07-27-2023, 11:10 AM

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.

psittacinesqpbemeofx

Valued member

Valued member

Posts: 0
Threads: 0
Joined: Oct 2019
Reputation: 0

Level: inf [ Level

Level

]
Total Points: inf
Rank nan / 1
100% to upload Level

Rank

Activity inf / 1
99% to upload your Rank

Activity

Experience nan
100% to upload Experience

Experience

Points: 50

#3

07-27-2023, 11:12 AM

There is no feasible way to do this. MS SQL support is an open request in WordPress's [**bug tracking system.**][1]

[**Here**][2] is a blog entry from a guy who tried it. It didn't end well.

For completeness's sake, there seems to be an *approach* that is in alpha Stadium (Not suitable for everyday use!) that may one day become a workable workaround. [**wordpress-mssql**][3]

[1]:

[To see links please register here]

[2]:

[To see links please register here]

[3]:

[To see links please register here]

hemipterous641

Valued member

Valued member

Posts: 0
Threads: 0
Joined: Jun 2017
Reputation: 0

Level: inf [ Level

Level

]
Total Points: inf
Rank nan / 1
100% to upload Level

Rank

Activity inf / 1
99% to upload your Rank

Activity

Experience nan
100% to upload Experience

Experience

Points: 50

#4

07-27-2023, 11:45 AM

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

[To see links please register here]

Dralsup7

Member

Member

Posts: 0
Threads: 0
Joined: Nov 2018
Reputation: 0

Level: inf [ Level

Level

]
Total Points: inf
Rank nan / 1
100% to upload Level

Rank

Activity inf / 1
99% to upload your Rank

Activity

Experience nan
100% to upload Experience

Experience

Points: 50

#5

07-27-2023, 11:51 AM

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.

[To see links please register here]

[To see links please register here]

aphrodision274016

Valued member

Valued member

Posts: 0
Threads: 0
Joined: Dec 2022
Reputation: 0

Level: inf [ Level

Level

]
Total Points: inf
Rank nan / 1
100% to upload Level

Rank

Activity inf / 1
99% to upload your Rank

Activity

Experience nan
100% to upload Experience

Experience

Points: 50

#6

07-27-2023, 11:53 AM

WordPress won't natively run MSSQL. However, an up-to-date fork that supports MSSQL [does exist][1].

[1]:

[To see links please register here]

« Next Oldest

Next Newest »

Forum Jump:

Users browsing this thread:

1 Guest(s)

©0Day 2016 - 2023 | All Rights Reserved. Made with for the community. Connected through