x
login about faq Site discussion (meta-askssc)

Export to Mysql

Hy, Can y export a table from SQL server 2005 to MYSQL data format? Thanks.

more ▼

asked Nov 26 '09 at 08:34 AM in Default

Nick2673 gravatar image

Nick2673
1 1 1 1

(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first

not that i know off .. . but maybe you should check with MySQL forum see if there is anyway to import from MSSQL database

Alternatively, export to delimited text file and import from the text file

more ▼

answered Nov 26 '09 at 08:56 AM

Squirrel 1 gravatar image

Squirrel 1
1.6k 1 3

(comments are locked)
10|1200 characters needed characters left

Mysql can very well sopport csv file. So export data to it and import in the mysql database

more ▼

answered Nov 26 '09 at 09:24 AM

Madhivanan gravatar image

Madhivanan
1.1k 1 2 6

it'a about a SQL database table who include in an field imagis(*.jpg). The idea was to eport the table (or a query result) in to a Mysql database table in order to update a website

Nov 26 '09 at 09:56 AM Nick2673
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments



Facebook logo Follow Ask SSC on Facebook
Find Ask SSC on Google+
linkedin logo Find us on LinkedIn

Topics:

x1834
x52
x26

asked: Nov 26 '09 at 08:34 AM

Seen: 777 times

Last Updated: Nov 26 '09 at 08:34 AM

Copyright © 2002-2012 Simple Talk Publishing. All Rights Reserved. If you have any queries, please contact the site administrators.
Ask SQL Server Central is a community service provided by Red Gate.