mysql语句转sqlserver语句_Sqlserver 语句转成MySql语句

要转成一样的效果，用powerdesigner怎么转？能转吗？

create table publishers (

publisherID int identity,

publisherName varchar (30) NOT NULL,

constraint pk_publishers primary key (publisherID)

)

;

create table authors (

authorID int identity,

firstName varchar (20) NOT NULL,

lastName varchar (30) NOT NULL,

constraint pk_authors primary key (authorID)

)

;

create table titles (

isbn varchar (20) NOT NULL,

title varchar (100) NOT NULL,

editionNumber int NOT NULL,

copyright varchar (4) NOT NULL,

publisherID int NOT NULL,

imageFile varchar (20) NOT NULL,

price float NOT NULL,

constraint fk_titles foreign key (publisherID)

references publishers (publisherID),

constraint pk_titles primary key (isbn)

)

;

create table authorISBN (

authorID int NOT NULL,

isbn varchar (20) NOT NULL,

constraint fk_authorISBN_1 foreign key (authorID)

references authors (authorID),

constraint fk_authorISBN_2 foreign key (isbn)

references titles (isbn)

)

;

create table bookusers

(

userId numeric identity,

account varchar(20) not null,

password varchar(20) not null,

name varchar(20) not null,

createTime datetime