Migrating MYSQL to MSSQL HELP!

[Dci521]

Okay so like many other people I've seen on these forums, my server only supports MSSQL, and obviously VBulletin only supports MYSQL. My question is if I get one of these converters and migrate the database to MSSQL, how often will i have to convert the database for my forums to run smoothly, or will it convert it automatically and deposit itself into the right place in my server? In other words, are these converters constantly working or do I have to manually innitiate them. I have litterally only a small amount of BASIC knowledge and Im not too savy with the databases yet, but im a fast learner. Its really important that my site gets online as soon as possible with at least the forums working because I have a big meeting with the president of MTV on the 15th. Unfortunately, thanks to the fact that i had no idea what the difference between these two databases was, I already purchased the VBulletin license without realizing that my server would not support it. Please can anybody help me with this dilema!!? I would appreciate it 1,000 percent!!

[Zachery]

You'll need to rewrite almost all of vBulletin to support MSSQL, I'd think it'd be _alot_ easier to just find a server with mysql support.

[psylenced]

While most sql should be similar there is a major difference being the limiting of rows.

In MSSQL it's SELECT TOP 100 *, in mysql it uses the LIMIT statement.

One is at the top and one is at the bottom of the statement, and MS-SQL only lets you limit the top, LIMIT lets you give a position and a count.

This would cause major headaches trying to convert.

[Simetrical]

I'm not aware of any way for this to work. In principle it might be possible using appropriate query rewriting, but I don't think anyone has done it (and even if it were done it would probably work poorly).

When vBulletin says it only supports MySQL, it means it. I suggest you either find forum software that supports MSSQL, or find a server that supports MySQL. The latter is probably easier.