Web Hosting Talk







View Full Version : Ms SQL Vs My SQL


./thename
05-26-2004, 07:42 PM
I have a question for all you out there. Will a mysql database work under mssql? I currently have a forum and site that is under mysql databases but the new buyer has a server with mssql and is wondering if he can convert it somehow or if it will work if it is mysql?

monaghan
05-27-2004, 05:40 AM
If you do a dump from MySQL it will be in the form of

CREATE DATABASE....
CREATE TABLE....
INSERT ....

Assuming you're using more or less standard ANSI SQL, then it should import into MS SQL or most other RDBMS with little or no tweaking

You can also install MySQL on a Windows box, so he could keep MySQL, but I guess he's already paid for his MS SQL license.