Re: moving data to MySQL

2009-02-22 Thread Claudio Nanni
Well, it is just to have a console that is able to connect to every database, ODBC and videogames are one of the few things good about microsoft! I used it to import export data from/to access/sql server/mysql/oracle. Cheers Claudio 2009/2/22 Haidong Ji > Hi, > > Never thought of the MS Acces

Re: moving data to MySQL

2009-02-21 Thread Haidong Ji
Hi, Never thought of the MS Access solution, but it sounds interesting and I am intrigued. If the data volume is not that big, it could be a quick and dirty way of doing it. Sql Server 2005 and Sql Server 2008 Integration Service (SSIS) can do this, but as far as usability is concerned, it is a s

Re: moving data to MySQL

2009-02-21 Thread Claudio Nanni
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

Re: moving data to MySQL

2009-02-21 Thread Dimitar Vasilev
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

Re: moving data to MySQL

2009-02-21 Thread chaim . rieger
There are products out there that convert from ms sql to MySql. Though I would test them before trusting them --Original Message-- From: Chris Rehm To: mysql@lists.mysql.com Subject: moving data to MySQL Sent: Feb 21, 2009 10:47 I want to write some programs to work with data from

moving data to MySQL

2009-02-21 Thread 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