Re: MSSQL > MySQL
| From: | David Tod Sigafoos | Date: | Fri, 17 Nov 2000 16:44:01 +0000 |
| Subject: | Re: MSSQL > MySQL | ||
| References: | 1 | Groups: | php.windows |
| Request: | Send a blank email to php-windows+get-3951@lists.php.net to get a copy of this message | ||
SA> Is there a way to convert a mssql database to a mysql database ? and then upload it to my
SA> webhoster ?
There are two considerations here .. data and db/table structures.
MSSql has an export routine. I don't for the life of me remember
right now what it is called (someone pipe in) but it can be found in
the help.
You can also export the scheme of your system. If you need the data
structures, once exported you will have to modify the 'create' syntax
to work with MySql. Different data types etc.
Once this is done both files (export data and scheme) should be able
to be ftp'd to your host and used
DSig
David Tod Sigafoos