Translator from MySQL to SQL ?
Does anyone know where i can find a translator from MySQL to SQL Server? preferably a free one...or a cheap one
Does anyone know where i can find a translator from MySQL to SQL Server? preferably a free one...or a cheap one
Shaggy posted this at 02:32 — 22nd December 2009.
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.
amgarden posted this at 16:06 — 13th April 2010.
They have: 1 posts
Joined: Apr 2010
Ya I wonder also what tool to use for that?!
drewgrantt1 posted this at 04:37 — 9th July 2010.
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;
Cheap Web Design
Jabulani posted this at 12:27 — 9th July 2010.
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.
napoleon gas fireplace
outdoor sink
JeevesBond posted this at 23:43 — 10th July 2010.
He has: 3,956 posts
Joined: Jun 2002
Run the following on the command line:
mysqldump --helpand you'll see this option:--compatible=name Change the dump to be compatible with a given mode. Bydefault 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.sqland get out your data. Or, if your database has a root username/password set:mysqldump -uroot -p --all-databases --compatible=mssql > databases.sqla Padded Cell our articles site!
Shaggy posted this at 19:46 — 13th July 2010.
They have: 121 posts
Joined: Dec 2008
Nice documentation catch!
pr0gr4mm3r posted this at 01:09 — 15th July 2010.
He has: 1,502 posts
Joined: Sep 2006
Fascinating - never knew that existed.
JeevesBond posted this at 09:31 — 17th July 2010.
He has: 3,956 posts
Joined: Jun 2002
Thanks guys, I was pleasantly surprised too!
sandeep Kumar posted this at 05:45 — 16th July 2010.
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.
jsrefinance99 posted this at 22:30 — 20th September 2010.
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.
jennywong posted this at 09:13 — 25th September 2010.
They have: 2 posts
Joined: Sep 2010
Tried your solution but did not work for me.
Birkenstock posted this at 09:43 — 5th May 2011.
They have: 5 posts
Joined: Apr 2011
you can search on google
jessicaellen posted this at 01:44 — 6th May 2011.
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
solarlight posted this at 16:34 — 25th February 2012.
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.
Solar Led Street Lights Ahmedabad | Solar street lights
David26 posted this at 11:59 — 15th March 2012.
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.