From: Claudio Nanni
Date: February 21 2009 11:48pm
Subject: Re: moving data to MySQL
List-Archive: http://lists.mysql.com/mysql/216407
Message-Id: <53bcf3a60902211548j7ae20a9aoaf3c39e8ffc414e3@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary=0016368e2b2096ab7204637666eb
--0016368e2b2096ab7204637666eb
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Hi,
Using ODBC Drivers and MS Access you can do the job.
This is a quick list of steps(if you need more in depth just ask):
Download ODBC drivers for MySQL from www.mysql.com
Install the ODBC drivers
Create a System Data Source Name that point to the MySQL database (Control
Panel->Administration Tools->ODBC Data Sources)
Create a System Data Source Name that point to the MSSQL database (Control
Panel->Administration Tools->ODBC Data Sources)
Using Microsoft Access you can import-export-query the tables as you like.
Cheers
Claudio Nanni
2009/2/21 Chris Rehm
> I want to write some programs to work with data from eveonline.com but my
> installed database is MySQL and the data format they provide is a backup of
> MSSQL. They recommend installing SQL Server 2005 Express and I've downloaded
> that and am willing to install it, I just want to know if there is a
> programmatic way of transferring the data to MySQL. Any help or insight
> would be appreciated, I have been away from coding for several years because
> of health issues and I'm trying to knock the rust off my brain and get going
> again.
>
> Chris Rehm
> chris@stripped
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=claudio.nanni@stripped
>
>
--0016368e2b2096ab7204637666eb--