Translating SQL Server scripts to MySQL

Databases
1

Anyone know if sql scripts from SQL Server would work in MySQL? Something like this for example, it’s a excerpt from a script to create a table as part of an NBA statistics database.


SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Games](
	[Id] [uniqueidentifier] NOT NULL,
	[HomeTeam] [char](3) NOT NULL,
	[AwayTeam] [char](3) NOT NULL,
	[Date] [datetime] NOT NULL,
 CONSTRAINT [PK_Games] PRIMARY KEY CLUSTERED
(
	[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

I could just as easily just do it all by hand, but I worry that I might forget something that I had in the SQL Server version when I translate it over.

2

Maybe this?

[URL=“http://php.dzone.com/articles/converting-mysql-sqlserver-queries”]http://php.dzone.com/articles/converting-mysql-sqlserver-queries

Or these?

http://dbconvert.com/convert-mssql-to-mysql-pro.php?DB=6

http://www.sqltran.com/sql-server-to-mysql/

3

Okay, so that answers my question. Programs that do what I’m trying to do cost more money than I’m willing to spend.

I’ll do it by hand.

4

Maybe, with the developer tools of sql server you can do it, using a ETL (extraction, transformation and load).