How to convert mssql script to mysql

Question

I tried to convert script from MS SQL Server to MySql.

I couldn't find any convenience approach to do this conversion.

I tried this MS SQL Server to MySQL Conversion online converter but it has a lot of mistakes at syntax.

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IDENTITY(1,1) NOT NULL,
`address` varchar(255) NOT NULL,
`date_added` datetime N' at line 2

Here is content of the file that I need to convert pastebin - script

Does any better way to make this conversion but without installing special tool exist?

You are trying to migrate a database or data? There is a tool that you don't need to install, just execute and it does the rest. — Jorge Campos
– Jorge Campos, Commented Nov 20, 2013 at 22:27
I had to migrate MS SQL to MySQL and wrote Q̛&A about that: stackoverflow.com/questions/38942424/… not a straightforward solution and requires installing of the tools, but may help someone — vitro
– vitro, Commented Aug 14, 2016 at 13:15

tommy_o · Accepted Answer · 2016-01-10 16:46:16Z

5

You don't just "convert" TSQL to SQL code for MySQL. You need to know the different datatypes, column constraints, etc. You hit the first of many roadblocks: MySQL uses AUTO_INCREMENT instead of SQL Server's IDENTITY field constraint.

EDIT: There are utilities, but you should still understand what the changes are, as they'll affect many things (including performance and future development against the DB). Duplicate of several other posts (dead link removed).

edited Jan 10, 2016 at 16:46

answered Nov 20, 2013 at 22:29

tommy_o

3,8233 gold badges32 silver badges33 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Steve Smith Over a year ago

This answer doesn't actually provide an answer, and also contradicts itself ("You don't just convert.." -> You need to convert from AUTO_INCREMENT to IDENTITY).

Alan Hickman · Accepted Answer · 2015-05-05 08:51:28Z

2

The converter at http://burrist.com/mstomy.php runs a set of regexps to do the conversion – the regexps list isn’t exhaustive and can be modified as required. I’ve added a couple of extra lines to the standard regexps and it now creates a working version of your script up to the point you start inserting data (it only does tha structure not the data). Hope this is of interest.

Cheers sql-hub.com

answered May 5, 2015 at 8:51

Alan Hickman

234 bronze badges

Comments

R M Shahidul Islam Shahed · Accepted Answer · 2018-08-02 17:47:52Z

0

I used this online tools and its absolutely fine. http://www.sqlines.com/online

answered Aug 2, 2018 at 17:47

R M Shahidul Islam Shahed

1,39417 silver badges13 bronze badges

2 Comments

catch32 Over a year ago

I tried this one. The converted script is good for creating new tables. For insertion, it fails.

Pradeep Puranik Over a year ago

The suggested sqlines does a terrible job of converting scripts. For example, my simple MSSQL script was: <code>if not exists (select * from INFORMATION_SCHEMA.COLUMNS where table_name='Orgs') begin create table Orgs ( OrgId varchar(50), Name varchar(250), Add1 varchar(250), Add2 varchar(250), City varchar(50), Pin varchar(15), TelNos varchar(250), Email varchar(500) ) end go... </code> When I converted to Mysql, sqlines just removed the "go" and added semicolons, but did no real conversion. It left INFORMATION_SCHEMA.COLUMNS as it is, which fails in mysql.

Collectives™ on Stack Overflow

How to convert mssql script to mysql

3 Answers 3

1 Comment

Comments

2 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

2 Comments

Linked

Related