./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.