MS SQl versus MYSQL
Moderator: General Moderators
MS SQl versus MYSQL
I created a database in MSSQL.Is there anyway I can import with mysql.With what command from mysql prompt?
Thanks.
Thanks.
phpmyadmin provides a good web interface for manual editing.
Set Search Time - A google chrome extension. When you search only results from the past year (or set time period) are displayed. Helps tremendously when using new technologies to avoid outdated results.
fastest way
what is the fastest way to insert tousands of entries in an mysql database?
- Maugrim_The_Reaper
- DevNet Master
- Posts: 2704
- Joined: Tue Nov 02, 2004 5:43 am
- Location: Ireland
Re: MS SQl versus MYSQL
Use mysqldump.sebs wrote:I created a database in MSSQL.Is there anyway I can import with mysql.With what command from mysql prompt?
Thanks.
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
Re: MSSQL
My bad.sebs wrote:From MSSQL to MYSQL
MSSQL
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...