讨论：mssql和mysql是不同的数据库吧？

作者 sdusn 发布于 0000-00-00 分类：数据库技术

今天先前没看清楚把一个mssql的数据库导入到mysql里面，死活不行！

就是serv－u连接的数据库，mssql是这样的，有什么办法弄成mysql的，再导入啊～


————————————————————————————————————
CREATE TABLE [dbo].[npGroupPath] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[GroupID] [varchar] (40) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[GroupPath] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[Permissions] [char] (9) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[npLog] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[UserID] [varchar] (40) COLLATE Chinese_PRC_CI_AS NULL ,
[Status] [tinyint] NULL ,
[FileName] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[FileSize] [int] NULL ,
[Elapse] [int] NULL ,
[AccessIP] [varchar] (15) COLLATE Chinese_PRC_CI_AS NULL ,
[HostIP] [varchar] (15) COLLATE Chinese_PRC_CI_AS NULL ,
[HostPort] [int] NULL ,
[AccessDateTime] [datetime] NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[npUserComm] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[ServerPort] [int] NULL ,
[HomePath] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[GroupID] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[TimeOut] [int] NULL ,
[SessionTimeOut] [int] NULL ,
[SpeedLimitDownload] [int] NULL ,
[SpeedLimitUpload] [int] NULL ,
[MaxUsersLoginPerIP] [int] NULL ,
[MaxUsers] [int] NULL ,
[DownLoadMax] [int] NULL ,
[QuotaMax] [int] NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[npUserInfo] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[UserID] [varchar] (40) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[Pass] [varchar] (40) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[Enabled] [bit] NOT NULL ,
[ServerPort] [int] NOT NULL ,
[UserComm] [int] NOT NULL ,
[DownloadMax] [int] NULL ,
[DownloadCurrent] [int] NULL ,
[QuotaMax] [int] NULL ,
[QuotaCurrent] [int] NULL ,
[Expire] [bit] NOT NULL ,
[ExpireDatetime] [datetime] NULL ,
[HomePath] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[GroupID] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[TimeOut] [int] NULL ,
[SessionTimeOut] [int] NULL ,
[SpeedLimitDownLoad] [int] NULL ,
[SpeedLimitUpLoad] [int] NULL ,
[MaxUsersLoginPerIP] [int] NULL ,
[MaxUsers] [int] NULL ,
[LastAccessDatetime] [datetime] NULL ,
[CreateDatetime] [datetime] NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[npUserPath] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[UserID] [varchar] (40) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[UserPath] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[Permissions] [char] (9) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[npGroupPath] WITH NOCHECK ADD
CONSTRAINT [PK_npGroupPath] PRIMARY KEY CLUSTERED
(
[id],
[GroupID]
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[npLog] WITH NOCHECK ADD
CONSTRAINT [PK_npLog] PRIMARY KEY CLUSTERED
(
[id]
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[npUserComm] WITH NOCHECK ADD
CONSTRAINT [PK_UserComm] PRIMARY KEY CLUSTERED
(
[id]
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[npUserInfo] WITH NOCHECK ADD
CONSTRAINT [PK_npUserInfo] PRIMARY KEY CLUSTERED
(
[id],
[UserID]
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[npUserPath] WITH NOCHECK ADD
CONSTRAINT [PK_UserPath] PRIMARY KEY CLUSTERED
(
[id],
[UserID]
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[npLog] ADD
CONSTRAINT [DF_npLog_AccessDateTime] DEFAULT (getdate()) FOR [AccessDateTime]
GO

ALTER TABLE [dbo].[npUserComm] ADD
CONSTRAINT [DF_npUserComm_ServerPort] DEFAULT (21) FOR [ServerPort],
CONSTRAINT [DF_npUserComm_TimeOut] DEFAULT (0) FOR [TimeOut],
CONSTRAINT [DF_npUserComm_SessionTimeOut] DEFAULT (0) FOR [SessionTimeOut],
CONSTRAINT [DF_npUserComm_SpeedLimitDownload] DEFAULT (0) FOR [SpeedLimitDownload],
CONSTRAINT [DF_npUserComm_SpeedLimitUpload] DEFAULT (0) FOR [SpeedLimitUpload],
CONSTRAINT [DF_npUserComm_MaxUsersLoginPerIP] DEFAULT (0) FOR [MaxUsersLoginPerIP],
CONSTRAINT [DF_npUserComm_MaxUsers] DEFAULT (0) FOR [MaxUsers],
CONSTRAINT [DF_npUserComm_DownLoadMax] DEFAULT (0) FOR [DownLoadMax],
CONSTRAINT [DF_npUserComm_QuotaMax] DEFAULT (0) FOR [QuotaMax]
GO

CREATE INDEX [IX_npUserComm] ON [dbo].[npUserComm]([HomePath]) ON [PRIMARY]
GO

ALTER TABLE [dbo].[npUserInfo] ADD
CONSTRAINT [DF_UserInfo_Enabled] DEFAULT (0) FOR [Enabled],
CONSTRAINT [DF_npUserInfo_ServerPort] DEFAULT (21) FOR [ServerPort],
CONSTRAINT [DF_UserInfo_UserComm] DEFAULT (0) FOR [UserComm],
CONSTRAINT [DF_npUserInfo_DownloadMax] DEFAULT (0) FOR [DownloadMax],
CONSTRAINT [DF_npUserInfo_DownloadCurrent] DEFAULT (0) FOR [DownloadCurrent],
CONSTRAINT [DF_npUserInfo_QuotaMax] DEFAULT (0) FOR [QuotaMax],
CONSTRAINT [DF_npUserInfo_QuotaCurrent] DEFAULT (0) FOR [QuotaCurrent],
CONSTRAINT [DF_npUserInfo_Expire] DEFAULT (1) FOR [Expire],
CONSTRAINT [DF_npUserInfo_ExpireDateTime] DEFAULT (getdate()) FOR [ExpireDatetime],
CONSTRAINT [DF_npUserInfo_TimeOut] DEFAULT (0) FOR [TimeOut],
CONSTRAINT [DF_npUserInfo_SessionTimeOut] DEFAULT (0) FOR [SessionTimeOut],
CONSTRAINT [DF_npUserInfo_SpeedLimitDownLoad] DEFAULT (0) FOR [SpeedLimitDownLoad],
CONSTRAINT [DF_npUserInfo_SpeedLimitUpLoad] DEFAULT (0) FOR [SpeedLimitUpLoad],
CONSTRAINT [DF_npUserInfo_MaxUsersLoginPerIP] DEFAULT (0) FOR [MaxUsersLoginPerIP],
CONSTRAINT [DF_npUserInfo_MaxUsers] DEFAULT (0) FOR [MaxUsers],
CONSTRAINT [DF_UserInfo_LastAccessDateTime] DEFAULT (getdate()) FOR [LastAccessDatetime],
CONSTRAINT [DF_UserInfo_CreateDateTime] DEFAULT (getdate()) FOR [CreateDatetime]
GO

逛论坛交流：mssql和mysql是不同的数据库吧？

1. 
   
   
   我有话要讲：(可以匿名发表, 发广告的有多远请滚多远!!!)
   LZ, 我顶你个肺啊！俺不说两句，心里过意不去，刚心里憋得慌，回来说两句了，心里终于踏实了。
   昵称： 请输入验证码：
   
   
   

• 更早的 >