Page 1 of 1

MS SQl versus MYSQL

Posted: Fri Sep 23, 2005 3:16 am
by sebs
I created a database in MSSQL.Is there anyway I can import with mysql.With what command from mysql prompt?
Thanks.

Mysql

Posted: Fri Sep 23, 2005 3:26 am
by sebs
The only way of entering data in my sql is using insert into SOME values OTHER?

Posted: Fri Sep 23, 2005 3:53 am
by shiznatix
if its sql wouldnt it be perdy much the same? just read the tables then put them in the new mssql db. easily done

mysql

Posted: Fri Sep 23, 2005 4:37 am
by sebs
Is there a way to edit the MYSQL table(like in Access or MSSQL)without insert?

Posted: Fri Sep 23, 2005 4:44 am
by shiznatix
yes, use the UPDATE command

Posted: Fri Sep 23, 2005 4:48 am
by s.dot
phpmyadmin provides a good web interface for manual editing.

MYSQLADMIN

Posted: Fri Sep 23, 2005 4:58 am
by sebs
Thanks

fastest way

Posted: Fri Sep 23, 2005 7:16 am
by sebs
what is the fastest way to insert tousands of entries in an mysql database?

Posted: Fri Sep 23, 2005 7:40 am
by Maugrim_The_Reaper
Depends on size - phpmyadmin can handle up to about 2MB I think (but it wasn't very reliable - at least in older versions).

MySQL command line has an import function - see the manual.

Re: MS SQl versus MYSQL

Posted: Fri Sep 23, 2005 9:54 am
by BDKR
sebs wrote:I created a database in MSSQL.Is there anyway I can import with mysql.With what command from mysql prompt?
Thanks.
Use mysqldump.

As long as the MSSQL tables are allready setup, then a dump of just the data should get the stuff you need.

As for entering it into MSSQL, you're on your own there. However, if you can script to connect and do things with mssql, why not iterate through the file you dumped above run those insert queries into the server you want?

The last, coolest, most l33t solution would be to pipe your dump straight into some mssql utility. I just doubt Microsoft was ever smart enough to make it that easy.

Now if you haven't created the tables, it may get more interesting as there are likely to be differences in MS's SQL and the exact names/equivalents of/for types may (most likely will) have some variation. The easy thing to do is dump your MySQL database with no data (just table creation information) and then run that SQL in MSSQL. Look for the errors then adjust the SQL to something the server likes.

Cheers

Posted: Fri Sep 23, 2005 9:56 am
by feyd
I think several, or all of us, are confused a bit.. Do you want to import data to a MySQL database from MSSQL or import data to MSSQL from MySQL ?

MSSQL

Posted: Fri Sep 23, 2005 10:00 am
by sebs
From MSSQL to MYSQL

Re: MSSQL

Posted: Fri Sep 23, 2005 10:00 am
by BDKR
sebs wrote:From MSSQL to MYSQL
My bad. :oops:

MSSQL

Posted: Fri Sep 23, 2005 10:10 am
by sebs
I'm sure you are a little confused,for wht do I need that.The problem is I have a very big database,tousands and tousands of contacts that is in MSSQL.I have a Web page in PHP and the server that I wan't to put it on is only having connections to MYSQL(for PHP).Who thought they would dedicat their server of MSSQL to .NET and...