Gossamer Forum
Home : General : Databases and SQL :

covert mssql2mysql

Quote Reply
covert mssql2mysql

I was wandering if it is possible to convert a complete mssql-database with asp to a mysql with php without any problems...
You see, i've made a page with a friend of mine (who did the coding). Due to the fact that he no longer has an internetconnection and the costs of mssql webhosting, i would like to change it to mysql.
Now, i've read something about mssql2mysql and asp2php converters, but wasn't sure if this would be the answer. Do we have to re-write the complete database and asp-files, or is there a much easier way??
Could asp for instance be used together with mysql??

Quote Reply
Re: [rvaggelen] covert mssql2mysql In reply to
It is not that easy or straightforward. Depending on the column types you used in your SQL Server database (like SQL Server specific ones like NVARCHAR, NTEXT, etc.), you will have problems transferring data from one database application to the other (in terms of the CREATE table codes in the DUMP file that you can create from SQL Server and use to create your structure in MySQL).

The best suggestion I have is the following:

1) Create a dump script that contains all the CREATE statements via SQL Server Enterprise Manager.

2) Manually edit the column types in the SQL CREATE statements to ones that are used in MySQL.

3) Then you can save the file as .sql and then run it in your MySQL server.

In terms of the codes between ASP and PHP...haha! That is a good one...you'll have to re-code the whole system...good luck!

Depending on the queries you've written in ASP, you could probably get away with using MySQL as your datasource, just changing your datasource references in your ASP datasource references. However, if you used SQL Server specific queries like INNER JOINS and such, they will not translate very well into MySQL. So, there will be a level of re-coding that you'll have to do anyway.
Buh Bye!


Last edited by:

Stealth: Oct 29, 2002, 2:07 PM