求助如何将.sql文件加载到mysql

[babymaoqiu]

我有个现成的数据库是用sql server2000做的。。我如何把它加载到mysql里面去。下面的这个文件的代码，应该没什么错吧？/*
*ER/Studio 6.6 SQL Code Generation
* Company : syt
* Project : BankDB.DM1
* Author : Songyiting
*
* Date Created : Monday, September 18, 2006 09:05:11
* Target DBMS : Microsoft SQL Server 2000
*/

/*
* TABLE: BANKINFO
*/

CREATE TABLE BANKINFO(
BANKID varchar(32) NOT NULL,
BANKNAME varchar(50) NULL,
BANKMANAGER varchar(50) NULL,
OPAREA varchar(100) NULL,
BANKINTRO varchar(200) NULL,
CONSTRAINT PK15 PRIMARY KEY NONCLUSTERED (BANKID)
)
go



IF OBJECT_ID('BANKINFO') IS NOT NULL
PRINT '<<< CREATED TABLE BANKINFO >>>'
ELSE
PRINT '<<< FAILED CREATING TABLE BANKINFO >>>'
go

/*
* TABLE: CLIENTBASICINFO
*/

CREATE TABLE CLIENTBASICINFO(
ClIENTID varchar(32) NOT NULL,
ClIENTCODE varchar(32) NOT NULL,
CLIENTNAME varchar(32) NULL,
CLIENTTYPE varchar(2) NULL,
ADRESS varchar(32) NULL,
TELL varchar(32) NULL,
STATE varchar(1) NULL,
DATE datetime NULL,
CONSTRAINT PK9 PRIMARY KEY NONCLUSTERED (ClIENTID)
)
go



IF OBJECT_ID('CLIENTBASICINFO') IS NOT NULL
PRINT '<<< CREATED TABLE CLIENTBASICINFO >>>'
ELSE
PRINT '<<< FAILED CREATING TABLE CLIENTBASICINFO >>>'
go

/*
* TABLE: CLIENTFINANC
*/

CREATE TABLE CLIENTFINANC(
ClIENTID varchar(32) NOT NULL,
INCOME numeric(32, 4) NULL,
FIXEDASSETS numeric(32, 4) NULL,
TOTALASSETS numeric(32, 4) NULL,
COINTYPE varchar(32) NULL,
CONSTRAINT PK10 PRIMARY KEY NONCLUSTERED (ClIENTID)
)
go



IF OBJECT_ID('CLIENTFINANC') IS NOT NULL
PRINT '<<< CREATED TABLE CLIENTFINANC >>>'
ELSE
PRINT '<<< FAILED CREATING TABLE CLIENTFINANC >>>'
go

/*
* TABLE: COIN
*/

CREATE TABLE COIN(
COINID varchar(32) NOT NULL,
COINTYPE varchar(32) NULL,
RATE numeric(32, 4) NULL,
SOURCE varchar(32) NULL,
CONSTRAINT PK8 PRIMARY KEY NONCLUSTERED (COINID)
)
go



IF OBJECT_ID('COIN') IS NOT NULL
PRINT '<<< CREATED TABLE COIN >>>'
ELSE
PRINT '<<< FAILED CREATING TABLE COIN >>>'
go

/*
* TABLE: CREDITLINEAPPLY
*/

CREATE TABLE CREDITLINEAPPLY(
ClIENTID varchar(32) NOT NULL,
CREDITLINE numeric(32, 4) NULL,
APPLYSTATE varchar(1) NULL,
APPLYSUM numeric(32, 4) NULL,
CLARE varchar(32) NULL,
ASSESSOR varchar(32) NULL,
CONSTRAINT PK13 PRIMARY KEY NONCLUSTERED (ClIENTID)
)
go
IF OBJECT_ID('CREDITLINEAPPLY') IS NOT NULL
PRINT '<<< CREATED TABLE CREDITLINEAPPLY >>>'
ELSE
PRINT '<<< FAILED CREATING TABLE CREDITLINEAPPLY >>>'
go
/*
* TABLE: GUARANTY
*/
CREATE TABLE GUARANTY(
GUARANTYID varchar(32) NOT NULL,
GUARANTYTYPE varchar(32) NULL,
GUARANTYBOUND numeric(32, 4) NULL,
GUARANTYLEVEL varchar(2) NULL,
CONSTRAINT PK7 PRIMARY KEY NONCLUSTERED (GUARANTYID)
)
go
IF OBJECT_ID('GUARANTY') IS NOT NULL
PRINT '<<< CREATED TABLE GUARANTY >>>'
ELSE
PRINT '<<< FAILED CREATING TABLE GUARANTY >>>'
go
/*
* TABLE: GUARANTYAPPLY
*/
CREATE TABLE GUARANTYAPPLY(
APPLYID varchar(32) NOT NULL,
ClIENTID varchar(32) NOT NULL,
GUARANTYTYPE varchar(32) NULL,
GUARANTYLEVEL varchar(2) NULL,
GUARANTYSUM numeric(32, 4) NULL,
APPLYSTATE varchar(1) NULL,
GUARANTYTERM int NULL,
GUARANTYINFO varchar(200) NULL,
GUARANTYEND datetime NULL,
CLARE varchar(32) NULL,
ASSESSOR varchar(32) NULL,
CONSTRAINT PK12_1 PRIMARY KEY NONCLUSTERED (APPLYID)
)
go
IF OBJECT_ID('GUARANTYAPPLY') IS NOT NULL
PRINT '<<< CREATED TABLE GUARANTYAPPLY >>>'
ELSE
PRINT '<<< FAILED CREATING TABLE GUARANTYAPPLY >>>'
go
/*
* TABLE: LOG
*/
CREATE TABLE LOG(
LOGID varchar(32) NOT NULL,
USERID varchar(32) NOT NULL,
DATE datetime NULL,
EVENT varchar(100) NULL,
CONSTRAINT PK6 PRIMARY KEY NONCLUSTERED (LOGID)
)
go
IF OBJECT_ID('LOG') IS NOT NULL
PRINT '<<< CREATED TABLE LOG >>>'
ELSE
PRINT '<<< FAILED CREATING TABLE LOG >>>'
go
/*
* TABLE: MENU
*/
CREATE TABLE MENU(
MENUID varchar(32) NOT NULL,
MENUCODE varchar(32) NULL,
MENUNAME varchar(50) NULL,
MENUTYPE varchar(1) NULL,
UPMENUCODE varchar(32) NULL,
MENULEVEL varchar(8) NULL,
MENULINK varchar(100) NULL,
MENUSTATE varchar(1) NULL,
MENUSHOW varchar(200) NULL,
CONSTRAINT PK3 PRIMARY KEY NONCLUSTERED (MENUID)
)
go
IF OBJECT_ID('MENU') IS NOT NULL
PRINT '<<< CREATED TABLE MENU >>>'
ELSE
PRINT '<<< FAILED CREATING TABLE MENU >>>'
go
/*
* TABLE: ROLE
*/
CREATE TABLE ROLE(
ROLEID varchar(32) NOT NULL,
ROLECODE char(10) NULL,
ROLENAME varchar(32) NULL,
ROLESTATE varchar(1) NULL,
CONSTRAINT PK2 PRIMARY KEY NONCLUSTERED (ROLEID)
)
go
IF OBJECT_ID('ROLE') IS NOT NULL
PRINT '<<< CREATED TABLE ROLE >>>'
ELSE
PRINT '<<< FAILED CREATING TABLE ROLE >>>'
go

/*
* TABLE: ROLEANDMENU
*/

CREATE TABLE ROLEANDMENU(
ROLEID varchar(32) NOT NULL,
MENUID varchar(32) NOT NULL
)
go
IF OBJECT_ID('ROLEANDMENU') IS NOT NULL
PRINT '<<< CREATED TABLE ROLEANDMENU >>>'
ELSE
PRINT '<<< FAILED CREATING TABLE ROLEANDMENU >>>'
go

/*
* TABLE: USERANDROLE
*/

CREATE TABLE USERANDROLE(
USERID varchar(32) NOT NULL,
ROLEID varchar(32) NOT NULL,
CONSTRAINT PK4 PRIMARY KEY NONCLUSTERED (USERID)
)
go
IF OBJECT_ID('USERANDROLE') IS NOT NULL
PRINT '<<< CREATED TABLE USERANDROLE >>>'
ELSE
PRINT '<<< FAILED CREATING TABLE USERANDROLE >>>'
go

/*
* TABLE: USERINFO
*/

CREATE TABLE USERINFO(
USERID varchar(32) NOT NULL,
USERCODE varchar(32) NOT NULL,
PASSWORD varchar(32) NULL,
USERNAME varchar(32) NULL,
TELL varchar(50) NULL,
MAIL varchar(100) NULL,
DATE datetime NULL,
STATE varchar(1) NULL,
CONSTRAINT PK1 PRIMARY KEY NONCLUSTERED (USERID)
)
go
IF OBJECT_ID('USERINFO') IS NOT NULL
PRINT '<<< CREATED TABLE USERINFO >>>'
ELSE
PRINT '<<< FAILED CREATING TABLE USERINFO >>>'
go
/*
* TABLE: CLIENTFINANC
*/
ALTER TABLE CLIENTFINANC ADD CONSTRAINT RefCLIENTBASICINFO31
FOREIGN KEY (ClIENTID)
REFERENCES CLIENTBASICINFO(ClIENTID)
go
/*
* TABLE: CREDITLINEAPPLY
*/
ALTER TABLE CREDITLINEAPPLY ADD CONSTRAINT RefCLIENTBASICINFO32
FOREIGN KEY (ClIENTID)
REFERENCES CLIENTBASICINFO(ClIENTID)
go
/*
* TABLE: GUARANTYAPPLY
*/
ALTER TABLE GUARANTYAPPLY ADD CONSTRAINT RefCLIENTBASICINFO35
FOREIGN KEY (ClIENTID)
REFERENCES CLIENTBASICINFO(ClIENTID)
go
/*
* TABLE: LOG
*/
ALTER TABLE LOG ADD CONSTRAINT RefUSERINFO21
FOREIGN KEY (USERID)
REFERENCES USERINFO(USERID)
go
/*
* TABLE: ROLEANDMENU
*/
ALTER TABLE ROLEANDMENU ADD CONSTRAINT RefROLE19
FOREIGN KEY (ROLEID)
REFERENCES ROLE(ROLEID)
go
ALTER TABLE ROLEANDMENU ADD CONSTRAINT RefMENU20
FOREIGN KEY (MENUID)
REFERENCES MENU(MENUID)
go
/*
* TABLE: USERANDROLE
*/
ALTER TABLE USERANDROLE ADD CONSTRAINT RefROLE18
FOREIGN KEY (ROLEID)
REFERENCES ROLE(ROLEID)
go

ALTER TABLE USERANDROLE ADD CONSTRAINT RefUSERINFO27
FOREIGN KEY (USERID)
REFERENCES USERINFO(USERID)
go

[davidsyg]

启动MYSQL
登陆后
把上面代码
复制，然后粘贴
然后enter
如果代码没错的话
就OK

[babymaoqiu]

要能ctrl c,ctrl v我 还问别人啊

[yingtju]

太长了也没细看
sql　server与mysql语法不同，内置函数也不同
用mysql的source试试呗，有错就改

[milo-higgs]

[Quote=引用 5 楼 yingtju 的回复:]
太长了也没细看
sql　server与mysql语法不同，内置函数也不同
用mysql的source试试呗，有错就改
[/Quote]

应该是有很大的不同的啊

[liujun999999]

source命令就可以了

[liujun999999]

source命令就可以了啊

[老紫竹]

用 navicat 工具吧！

[babymaoqiu]

source命令试过了。。不可以。。语法差别比较大

[evoloyeu]

1. 实例数据库在MySQL 5.0.27 版本下测试通过
2. 将database目录中ajax.sql文件复制到C:\
3. 进入MySQL安装目录中的bin目录
4. 输入 mysql -u root -p ，然后输入密码登录本地MySQL服务器
5. 输入 CREATE DATABASE ajax DEFAULT CHARACTER SET utf8; 创建名为ajax的数据库
6. 输入 use ajax
7. 输入 source c:\ajax.sql 执行数据库初始化语句

[samhsieh]

打开MYSQL控制台
source 你的SQL文件所在路径；

[jiaping108]

下个管理工具撒,比如mysql-front,然后导入SQL文件就成了哈

[babymaoqiu]

导入是能导入了。。但语法差别很大 。。么的用。。还是谢谢你哈