Translator from MySQL to SQL ?

They have: 5 posts

Joined: Apr 2009

Does anyone know where i can find a translator from MySQL to SQL Server? preferably a free one...or a cheap one Laughing out loud

They have: 121 posts

Joined: Dec 2008

I can't think of anything you'd want to trust your data to...
I seem to remember a bundled SQL Server migration assistent bundled with the product - have you looked at that tool? (Or maybe it isn't included anymore?)

Cheers,
Shaggy.

They have: 1 posts

Joined: Apr 2010

Ya I wonder also what tool to use for that?!

They have: 5 posts

Joined: Jul 2010

There are two ways....
update extract set CustomerCreditCode
= ( select CreditCode from CreditCodes as b where extract.ConsumerNO = b.Consumer_No);

update extract as a
inner join CreditCodes b
on a.ConsumerNO = b.Consumer_No
set a.CustomerCreditCode = b.CreditCode;

They have: 2 posts

Joined: Jul 2010

Hello drewgrantt1,

Tried your solution but did not work for me. I am wondering how I can incorporate this if I committed mistakes by using your solution. I badly needed this converter so I can finish my project before the end of the month. I am way way behind my scheduled timelines and I only have less than a month to catch up. please let me know if you know any kind of tool that can convert MySQL to SQL.

JeevesBond's picture

He has: 3,955 posts

Joined: Jun 2002

Run the following on the command line: mysqldump --help and you'll see this option:

  --compatible=name   Change the dump to be compatible with a given mode. By
                      default tables are dumped in a format optimized for
                      MySQL. Legal modes are: ansi, mysql323, mysql40,
                      postgresql, oracle, mssql, db2, maxdb, no_key_options,
                      no_table_options, no_field_options. One can use several
                      modes separated by commas. Note: Requires MySQL server
                      version 4.1.0 or higher. This option is ignored with
                      earlier server versions.

So you should run something like: mysqldump --all-databases --compatible=mssql > databases.sql and get out your data. Or, if your database has a root username/password set:

mysqldump -uroot -p --all-databases --compatible=mssql > databases.sql

a Padded Cell our articles site!

They have: 121 posts

Joined: Dec 2008

Nice documentation catch!

pr0gr4mm3r's picture

He has: 1,502 posts

Joined: Sep 2006

Fascinating - never knew that existed.

JeevesBond's picture

He has: 3,955 posts

Joined: Jun 2002

Thanks guys, I was pleasantly surprised too!

He has: 53 posts

Joined: Jun 2010

Hello Friend, for that topic i have no more knowledge, but I have little bit Idea that I want to Share with all,

From that code we get text output of the Scheme["Defination, That contain Attribute name,primary key " and foreign key],which is compatible with MySql.

use SQL::Translator;
my $t = SQL::Translator->new( parser => '...', producer => 'MySQL', '...' );
$t->translate;

And I also, mention here URL,which we get from search engine, which help you for getting your Result,
"http://www.freedownloadscenter.com/Business/Accounting_Tools/MySQL_to_SQL_Server_Conversion_Software.html"
I Think that's help you.

They have: 1 posts

Joined: Sep 2010

SwisSQL Console SQL query translation / conversion tool converts SQL queries from one database dialect to another. It has a simple and user friendly GUI. DBAs and developers who work with multiple databases or on database migration projects need not spend unproductive hours trying to learn the differences in SQL dialects. SwisSQL Console lets you type in a SQL query and quickly see how the query is translated to other SQL dialects.you should try it.

They have: 2 posts

Joined: Sep 2010

Tried your solution but did not work for me.

They have: 5 posts

Joined: Apr 2011

you can search on google

jessicaellen's picture

They have: 31 posts

Joined: Nov 2010

We found SQLTran to be an efficient way to convert our Microsoft SQL Server database to the open-source MySQL database platform. The technical aspects of the conversion were completed quickly and accurately, and the software was well supported.
Goto sqltran.com

They have: 13 posts

Joined: Jan 2012

I am wondering how I can incorporate this if I committed mistakes by using your solution. I badly needed this converter so I can finish my project before the end of the month.

They have: 10 posts

Joined: Mar 2012

update extract as a
inner join CreditCodes b
on a.ConsumerNO = b.Consumer_No
set a.CustomerCreditCode = b.CreditCode;

Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.