SitePoint Sponsor

User Tag List

Results 1 to 4 of 4
  1. #1
    SitePoint Member
    Join Date
    Jul 2013
    Location
    Houston
    Posts
    14
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Translating SQL Server scripts to MySQL

    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.

    Code:
    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. #2
    Barefoot on the Moon! silver trophy Force Flow's Avatar
    Join Date
    Jul 2003
    Location
    Northeastern USA
    Posts
    4,615
    Mentioned
    56 Post(s)
    Tagged
    1 Thread(s)
    Visit The Blog | Follow On Twitter
    301tool 1.1.5 - URL redirector & shortener (PHP/MySQL)
    Can be hosted on and utilize your own domain

  3. #3
    SitePoint Member
    Join Date
    Jul 2013
    Location
    Houston
    Posts
    14
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    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. #4
    SitePoint Member
    Join Date
    Jun 2008
    Posts
    22
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Maybe, with the developer tools of sql server you can do it, using a ETL (extraction, transformation and load).


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •