Convert MS SQL .sql files for use with MySQL

Hello,

If you don't have many tables, you can do the following (in Notepad)::
- replace bit with tinyint or what other type of field you want to use
- replace [ with empty string
- replace ] with empty string
- replace dbo. with empty string
- replace ON [PRIMARY] with empty string

Now:
- manually  delete the code after the constraint, which is in my case:
WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]

I hope this helps a little.

Thank you

What you start up with:

CREATE TABLE [dbo].[TEST](
	[TESTFLD] [varchar](255) NOT NULL,
	[TESTBIT] [bit] NOT NULL,
 CONSTRAINT [PK_TEST] PRIMARY KEY CLUSTERED 
(
	[TESTFLD] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]







What you end up with:

CREATE TABLE TEST(
	TESTFLD varchar(255) NOT NULL,
	TESTBIT tinyint NOT NULL,
 CONSTRAINT PK_TEST PRIMARY KEY CLUSTERED 
(
	TESTFLD ASC
)
)

Select all Open in new window