FreeTDS Development Group

["James K. Lowden" <jklowden AT freetds.org>]

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