List:General Discussion« Previous MessageNext Message »
From:Claudio Nanni Date:February 21 2009 11:48pm
Subject:Re: moving data to MySQL
View as plain text  
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 <chris@stripped>

> 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=1
>
>

Thread
moving data to MySQLChris Rehm21 Feb
  • Re: moving data to MySQLDimitar Vasilev21 Feb
  • Re: moving data to MySQLClaudio Nanni22 Feb
    • Re: moving data to MySQLHaidong Ji22 Feb
      • Re: moving data to MySQLClaudio Nanni22 Feb
Re: moving data to MySQLchaim.rieger21 Feb