Re: Conversion from access to mysql
| From: | Scott Houseman | Date: | Mon, 16 Sep 2002 08:20:21 +0000 |
| Subject: | Re: Conversion from access to mysql | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-116494@lists.php.net to get a copy of this message | ||
Hi Chris.
You could try installing MyODBC on your SQL Server machine, create an ODBC connection to your mysql server, and then use SQL Server's
"Import and Export Data" tool to export the database from yout
SQL server to the Mysql server.
Regards
-Scott
Chris Grigor wrote:
Howdi All I posted this last week, and some of you had some suggestions and none of them have worked.... I have a database running on an Sql 2000 Server, I want to take this database and export it so that it can be used on a MySql Linux server running version 3.23 I have tried exporting it to a text file, to an xls file and then using dbtools Anyone else have any good ideas this is the first time I am doing it... Cheers Chris-- //--------------------------------------------// // Scott Houseman // // Jam Warehouse http://www.jamwarehouse.com/ // // Smart Business Innovation // // +27 21 4477440 / +27 82 4918021 // //--------------------------------------------//