469,088 Members | 1,265 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,088 developers. It's quick & easy.

Date From SQL Server to MySQL

Hi

How do I get data from my tables in SQL Server into my tables in mySQL

I have tried exporting the data out of SQL Server to a flat file (.txt), and
then import into the table in mySQL from the txt. For some reason, it bombs
and closes my GUI (mySQL control center)

Any help appreciated.
Thanks
Jul 19 '05 #1
6 1317
http://www.mysql.com/doc/en/LOAD_DATA.html
I have used this to import txt files to mySQL with no problem. Above link
will give you all the syntax.

"Derek Smith" <de*******@rogersNOSPAM.com> wrote in message
news:bF******************@news01.bloor.is.net.cabl e.rogers.com...
Hi

How do I get data from my tables in SQL Server into my tables in mySQL

I have tried exporting the data out of SQL Server to a flat file (.txt), and then import into the table in mySQL from the txt. For some reason, it bombs and closes my GUI (mySQL control center)

Any help appreciated.
Thanks

Jul 19 '05 #2
http://www.mysql.com/doc/en/LOAD_DATA.html
I have used this to import txt files to mySQL with no problem. Above link
will give you all the syntax.

"Derek Smith" <de*******@rogersNOSPAM.com> wrote in message
news:bF******************@news01.bloor.is.net.cabl e.rogers.com...
Hi

How do I get data from my tables in SQL Server into my tables in mySQL

I have tried exporting the data out of SQL Server to a flat file (.txt), and then import into the table in mySQL from the txt. For some reason, it bombs and closes my GUI (mySQL control center)

Any help appreciated.
Thanks

Jul 19 '05 #3
http://www.mysql.com/doc/en/LOAD_DATA.html
I have used this to import txt files to mySQL with no problem. Above link
will give you all the syntax.

"Derek Smith" <de*******@rogersNOSPAM.com> wrote in message
news:bF******************@news01.bloor.is.net.cabl e.rogers.com...
Hi

How do I get data from my tables in SQL Server into my tables in mySQL

I have tried exporting the data out of SQL Server to a flat file (.txt), and then import into the table in mySQL from the txt. For some reason, it bombs and closes my GUI (mySQL control center)

Any help appreciated.
Thanks

Jul 19 '05 #4
That works great--thanks for the link!
Derek
"Robin" <rl*****@energymasterllc.com> wrote in message
news:Y_****************@bignews4.bellsouth.net...
http://www.mysql.com/doc/en/LOAD_DATA.html
I have used this to import txt files to mySQL with no problem. Above link
will give you all the syntax.

"Derek Smith" <de*******@rogersNOSPAM.com> wrote in message
news:bF******************@news01.bloor.is.net.cabl e.rogers.com...
Hi

How do I get data from my tables in SQL Server into my tables in mySQL

I have tried exporting the data out of SQL Server to a flat file (.txt),

and
then import into the table in mySQL from the txt. For some reason, it

bombs
and closes my GUI (mySQL control center)

Any help appreciated.
Thanks


Jul 19 '05 #5
That works great--thanks for the link!
Derek
"Robin" <rl*****@energymasterllc.com> wrote in message
news:Y_****************@bignews4.bellsouth.net...
http://www.mysql.com/doc/en/LOAD_DATA.html
I have used this to import txt files to mySQL with no problem. Above link
will give you all the syntax.

"Derek Smith" <de*******@rogersNOSPAM.com> wrote in message
news:bF******************@news01.bloor.is.net.cabl e.rogers.com...
Hi

How do I get data from my tables in SQL Server into my tables in mySQL

I have tried exporting the data out of SQL Server to a flat file (.txt),

and
then import into the table in mySQL from the txt. For some reason, it

bombs
and closes my GUI (mySQL control center)

Any help appreciated.
Thanks


Jul 19 '05 #6
That works great--thanks for the link!
Derek
"Robin" <rl*****@energymasterllc.com> wrote in message
news:Y_****************@bignews4.bellsouth.net...
http://www.mysql.com/doc/en/LOAD_DATA.html
I have used this to import txt files to mySQL with no problem. Above link
will give you all the syntax.

"Derek Smith" <de*******@rogersNOSPAM.com> wrote in message
news:bF******************@news01.bloor.is.net.cabl e.rogers.com...
Hi

How do I get data from my tables in SQL Server into my tables in mySQL

I have tried exporting the data out of SQL Server to a flat file (.txt),

and
then import into the table in mySQL from the txt. For some reason, it

bombs
and closes my GUI (mySQL control center)

Any help appreciated.
Thanks


Jul 19 '05 #7

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

8 posts views Thread by Jeroen | last post: by
4 posts views Thread by Stupidgirl | last post: by
reply views Thread by Martin | last post: by
7 posts views Thread by meltedown | last post: by
2 posts views Thread by zMisc | last post: by
8 posts views Thread by hugh webster | last post: by
1 post views Thread by rija | last post: by
9 posts views Thread by TC | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by kglaser89 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.