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 <haidong...@gmail.com> > 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 step back from DTS (Data > Transformation Service from Sql Server 7 and Sql Server 2000 days). SSIS has > a fairly steep learning curve. > > I am also for the CSV flat file approach. One could use Sql Server bcp > utility to dump tables out as tab delimited file, then import it into MySQL > with LOAD DATA INFILE. > > Sample of bcp command: > bcp "MyDb.dbo.t1" out "c:\junk\t1.txt" -c -q -SMySqlServerInstance -T > > Sample of LOAD DATA command: > load data local infile '/home/MyFolder/t1.txt' into table MyDb.t1 lines > terminated by 'r\n' > > It looks like your first task is to restore this backup into a Sql Server > database. Sql Server Express management studio might have a GUI way of doing > this. If not, here is a sample script: > > restore database MyDb from disk = 'c:\LocationOfMyDbBackup' > with recovery, replace, move 'MyDbLogicalDataFile' to > 'c:\MyDirectory\MyDb.mdf', > move 'MyDbLogicalLogFile' to 'c:\MyDirectory\MyDb.ldf' > > Regards, > > Haidong "Alex" Ji > http://www.HaidongJi.com/tech > > > > On Sat, Feb 21, 2009 at 5:48 PM, Claudio Nanni <claudio.na...@gmail.com>wrote: > >> 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 <ch...@javadisciple.com> >> >> > 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 >> > ch...@javadisciple.com >> > >> > -- >> > MySQL General Mailing List >> > For list archives: http://lists.mysql.com/mysql >> > To unsubscribe: >> > http://lists.mysql.com/mysql?unsub=claudio.na...@gmail.com >> > >> > >> > >