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
SET QUOTED_IDENTIFIER ON
SET ANSI_PADDING ON
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
)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.
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.
Maybe, with the developer tools of sql server you can do it, using a ETL (extraction, transformation and load).
This topic is now closed. New replies are no longer allowed.