[teknoids] Getting data from MS SQL to MySQL
ladamiec at kentlaw.iit.edu
Fri Jun 5 14:59:51 EDT 2015
Maybe this will provide an idea.
UNIX Mgr/Web Support Specialist
Information Technology Services (ITS)
Chicago-Kent College of Law
Illinois Institute of Technology
565 W. Adams St.
On Fri, Jun 5, 2015 at 1:48 PM, Tracey McCartney <tracey at fairhousing.com>
> 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.
> Tracey McCartney
> Tennessee Fair Housing Council
> 107 Music City Circle, Suite 318
> Nashville, TN 37214
> 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...
More information about the Teknoids