Home : General : Databases and SQL :

General: Databases and SQL: Re: [rvaggelen] covert mssql2mysql: Edit Log

Here is the list of edits for this post
Re: [rvaggelen] covert mssql2mysql
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!

Cheers,
Me

Last edited by:

Stealth: Oct 29, 2002, 2:07 PM

Edit Log: