Regarding mysql server

Question

0.00/5 (No votes)

See more:

Hi there,
I want to shift from ms-sql to mysql,but i have already created database.Is it possible to use ms-sql stored procedure or tables script (or database script) in mysql server.what i ahve to do populate this database from mssql to mysql.
pls help ~~me ASAP.........~~

Posted 15-Jun-12 3:08am

nira.parmar

Updated 15-Jun-12 3:12am

ZurdoDev

v2

Add a Solution

Comments

Bernhard Hiller 15-Jun-12 10:19am

Did it the other way round a few month ago. I used my BusinessObjects, and added some extra functionality. I filled them with the data from the MySQL server, and INSERTed them to the MS SQLServer, with the IDENTITY_INSERT option (you do not need that with MySQL).
By the way, MS SQLServer is more performant, and has less issues with non-ASCII characters (especially with Backup and Restore...).

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Tim Corey · Answer 1 · 2012-06-15T07:57:00

While I'm not a big fan of systems that create schemas based upon another schema, there are ways you can do this. One tool that looks like it might work is the MySQL Migration Toolkit:

http://dev.mysql.com/doc/migration-toolkit/en/mysql-migration-toolkit-features.html[^]

It seems as though this used to be in the MySQL Workbench but I'm not sure if it still is or not. You could try there first. If you don't see it there, you can download the integrated version here:

http://downloads.mysql.com/archives.php?p=MySQLDeveloperSuite&v=1.1.10[^]