[teknoids] Getting data from MS SQL to MySQL

Adamiec, Lawrence ladamiec at kentlaw.iit.edu
Fri Jun 5 14:59:51 EDT 2015


Hi,

Maybe this will provide an idea.

http://stackoverflow.com/questions/1178043/how-to-export-text-data-from-a-sql-server-table


Thank you.
Larry

__________________________________________
Lawrence Adamiec
UNIX Mgr/Web Support Specialist
Information Technology Services (ITS)
Chicago-Kent College of Law
Illinois Institute of Technology
565 W. Adams St.
Chicago, IL
60661

On Fri, Jun 5, 2015 at 1:48 PM, Tracey McCartney <tracey at fairhousing.com>
wrote:

> Teknoids:
>
>
>
> We have an MS SQL 2005 database with a table that contains about 4500
> records, including a text field that is the full text of judicial decisions
> in HTML format.  As such, that field is full of commas and quotation marks,
> which is creating problems for a conventional comma-delimited export.
>
>
>
> What is going to be the best method for exporting this table for migration
> to a new web site that will be on a MySQL database? I have MS Access and
> SQL Server Management Studio (the lite/free version), and I used Access to
> export a .csv file which is probably useless because of the delimiters.  I
> would assume that .csv is going to be the best file format for the export,
> in terms of importing through phpMyAdmin if we can make it work, but please
> correct me if I'm wrong.
>
>
>
> Thanks!
>
>
>
> Tracey McCartney
>
> Tennessee Fair Housing Council
>
> 107 Music City Circle, Suite 318
>
> Nashville, TN 37214
>
> www.tennfairhousing.org
>
> 615-874-2344
>
>
>
> _______________________________________________
> You are currently subscribed to teknoids as: ladamiec at kentlaw.iit.edu.
> To unsubscribe send a blank email to teknoids-leave at lists.teknoids.net
> --
> See the web interface at http://lists.teknoids.net/listinfo/teknoids to
> get your list password, unsubscribe, and view your list settings.
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.teknoids.net/pipermail/teknoids/attachments/20150605/c91d2e2c/attachment.html>


More information about the Teknoids mailing list