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: "blackwater dev" <blackwaterdev AT gmail.com>
  • To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] moving data from mssql to mysql on linux
  • Date: Wed, 15 Mar 2006 11:37:20 -0500

Thanks James,

I didn't seem much in the freetds documentation about using bcp, unless I
missed it, is there some good info online about using it?

Thanks!

On 3/14/06, James K. Lowden <jklowden AT freetds.org> wrote:
>
> 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
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
>




Archive powered by MHonArc 2.6.24.

Top of Page