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

> 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.nanni@stripped>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 <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