Skip to Content.
Sympa Menu

freetds - Re: [freetds] moving data from mssql to mysql on linux

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "James K. Lowden" <jklowden AT freetds.org>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] moving data from mssql to mysql on linux
  • Date: Tue, 14 Mar 2006 22:22:15 -0500

blackwater dev wrote:
> I have a project where I need to connect to a remote SQL Server and move
> data from their to my localy MySQL server. On the remote SQL Server, I
> only have access to a few views but need to get their data and move it
> to my local MySQL db. What is the best way to do this? Can I do it
> with the FreeTDS BCP? Is there a better way?

freebcp is the best way to move data from a view or table to a file. I
think you'll find it's both versatile and reliable.

Once you have a data file, I'm sure you have MySQL tools to import the
data.

HTH.

--jkl




Archive powered by MHonArc 2.6.24.

Top of Page