sqlserver的.sql文件导入到mysql,麻烦有sqlserver的帮忙看一下,比较着急,现下不赶趟,谢谢啦

USE [master]

GO

/****** Object:  Database [yygh_db]    Script Date: 05/20/2014 00:04:48 ******/

CREATE DATABASE [yygh_db] ON  PRIMARY 

( NAME = N'yygh_db_Data', FILENAME = N'F:\Program Files (x86)\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\yygh_db_Data.MDF' , SIZE = 1792KB , MAXSIZE = UNLIMITED, FILEGROWTH = 10%)

 LOG ON 

( NAME = N'yygh_db_Log', FILENAME = N'F:\Program Files (x86)\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\yygh_db_Log.LDF' , SIZE = 2816KB , MAXSIZE = UNLIMITED, FILEGROWTH = 10%)

GO

EXEC dbo.sp_dbcmptlevel @dbname=N'yygh_db', @new_cmptlevel=80

GO

IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))

begin

EXEC [yygh_db].[dbo].[sp_fulltext_database] @action = 'disable'

end

GO

ALTER DATABASE [yygh_db] SET ANSI_NULL_DEFAULT OFF

GO

ALTER DATABASE [yygh_db] SET ANSI_NULLS OFF

GO

ALTER DATABASE [yygh_db] SET ANSI_PADDING OFF

GO

ALTER DATABASE [yygh_db] SET ANSI_WARNINGS OFF

GO

ALTER DATABASE [yygh_db] SET ARITHABORT OFF

GO

ALTER DATABASE [yygh_db] SET AUTO_CLOSE OFF

GO

ALTER DATABASE [yygh_db] SET AUTO_CREATE_STATISTICS ON

GO

ALTER DATABASE [yygh_db] SET AUTO_SHRINK ON

GO

ALTER DATABASE [yygh_db] SET AUTO_UPDATE_STATISTICS ON

GO

ALTER DATABASE [yygh_db] SET CURSOR_CLOSE_ON_COMMIT OFF

GO

ALTER DATABASE [yygh_db] SET CURSOR_DEFAULT  GLOBAL

GO

ALTER DATABASE [yygh_db] SET CONCAT_NULL_YIELDS_NULL OFF

GO

ALTER DATABASE [yygh_db] SET NUMERIC_ROUNDABORT OFF

GO

ALTER DATABASE [yygh_db] SET QUOTED_IDENTIFIER OFF

GO

ALTER DATABASE [yygh_db] SET RECURSIVE_TRIGGERS OFF

GO

ALTER DATABASE [yygh_db] SET  ENABLE_BROKER

GO

ALTER DATABASE [yygh_db] SET AUTO_UPDATE_STATISTICS_ASYNC OFF

GO

ALTER DATABASE [yygh_db] SET DATE_CORRELATION_OPTIMIZATION OFF

GO

ALTER DATABASE [yygh_db] SET TRUSTWORTHY OFF

GO

ALTER DATABASE [yygh_db] SET ALLOW_SNAPSHOT_ISOLATION OFF

GO

ALTER DATABASE [yygh_db] SET PARAMETERIZATION SIMPLE

GO

ALTER DATABASE [yygh_db] SET READ_COMMITTED_SNAPSHOT OFF

GO

ALTER DATABASE [yygh_db] SET  READ_WRITE

GO

ALTER DATABASE [yygh_db] SET RECOVERY SIMPLE

GO

ALTER DATABASE [yygh_db] SET  MULTI_USER

GO

ALTER DATABASE [yygh_db] SET PAGE_VERIFY TORN_PAGE_DETECTION

GO

ALTER DATABASE [yygh_db] SET DB_CHAINING OFF

GO

EXEC sys.sp_db_vardecimal_storage_format N'yygh_db', N'ON'

GO

USE [yygh_db]

GO

/****** Object:  Table [dbo].[yyjj]    Script Date: 05/20/2014 00:04:50 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[yyjj](

[id] [int] IDENTITY(1,1) NOT NULL,

[remark] [text] NULL,

 CONSTRAINT [PK_yyjj] 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] TEXTIMAGE_ON [PRIMARY]

GO

/****** Object:  Table [dbo].[yy]    Script Date: 05/20/2014 00:04:50 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[yy](

[id] [int] IDENTITY(1,1) NOT NULL,

[ysid] [varchar](50) NULL,

[rq] [varchar](50) NULL,

[uid] [varchar](50) NULL,

[status] [varchar](50) NULL

) ON [PRIMARY]

GO

SET ANSI_PADDING OFF

GO

/****** Object:  Table [dbo].[yspb]    Script Date: 05/20/2014 00:04:50 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[yspb](

[id] [int] IDENTITY(1,1) NOT NULL,

[rq] [varchar](50) NULL,

[rs] [int] NULL,

[ysid] [varchar](50) NULL,

 CONSTRAINT [PK_yspb] 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]

GO

SET ANSI_PADDING OFF

GO

/****** Object:  Table [dbo].[sysuser]    Script Date: 05/20/2014 00:04:50 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[sysuser](

[id] [int] IDENTITY(1,1) NOT NULL,

[uname] [varchar](50) NULL,

[upass] [varchar](50) NULL,

[tname] [varchar](50) NULL,

[sex] [varchar](50) NULL,

[tel] [varchar](50) NULL,

[ks] [varchar](50) NULL,

[zc] [varchar](50) NULL,

[utype] [varchar](50) NULL,

[img] [varchar](50) NULL,

[delstatus] [varchar](50) NULL,

[idcard] [varchar](50) NULL,

[remark] [text] NULL

) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

SET ANSI_PADDING OFF

GO

/****** Object:  Table [dbo].[notice]    Script Date: 05/20/2014 00:04:50 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[notice](

[id] [int] IDENTITY(1,1) NOT NULL,

[title] [varchar](500) NULL,

[content] [text] NULL,

[savetime] [varchar](50) NULL,

 CONSTRAINT [PK_notice] 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] TEXTIMAGE_ON [PRIMARY]

GO

SET ANSI_PADDING OFF

GO

/****** Object:  Table [dbo].[ks]    Script Date: 05/20/2014 00:04:50 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[ks](

[id] [int] IDENTITY(1,1) NOT NULL,

[name] [varchar](50) NULL,

[type] [varchar](50) NULL,

[remark] [text] NULL,

[delstatus] [varchar](50) NULL

) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

SET ANSI_PADDING OFF

GO

/****** Object:  Table [dbo].[br]    Script Date: 05/20/2014 00:04:50 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[br](

[id] [int] IDENTITY(1,1) NOT NULL,

[uname] [varchar](50) NULL,

[upass] [varchar](50) NULL,

[tname] [varchar](50) NULL,

[age] [varchar](50) NULL,

[sex] [varchar](50) NULL,

[tel] [varchar](50) NULL,

[isblack] [varchar](50) NULL,

[delstatus] [varchar](50) NULL,

[idcard] [varchar](50) NULL

) ON [PRIMARY]

GO

SET ANSI_PADDING OFF

GO


慕粉1148598521
浏览 1992回答 1
1回答

qq_Dreamy_旧城_0

请问这是要干嘛呀
打开App,查看更多内容
随时随地看视频慕课网APP

相关分类

MySQL
大数据