要做迁移,通过自己和网上整理合并的。
一致的数据类型
BIGINT
BINARY
BIT
CHAR
CHARACTER
DATETIME
DEC,DECIMAL
FLOAT
INT,INTEGER
NCHAR,NATIONAL CHARACTER
NVARCHAR,NCHAR VARYING
NATIONAL CHAR VARYING,NATIONAL CHARACTER VARYING
NUMERIC
REAL
SMALLINT
TEXT
TIMESTAMP
TINYINT
VARBINARY
VARCHAR,CHAR VARYING,CHARACTER VARYING
时间范围略有差别,可能会造成重大灾难,需要确认数据。
需要做修改的数据类型
MSSQL
MYSQL
IDENTITY
AUTO_INCREMENT
NTEXT
NATIONAL TEXT TEXT CHARACTER SET UTF8
SMALLDATETIME
DATETIME
MONEY
DECIMAL(19,4)
SMALL MONEY
DECIMAL(10,4)
UNIQUEIDENTIFIER
BINARY(16)
SYSNAME
CHAR(256)
关键代码修改:
MSSQL
MYSQL
<>
<> 或 !=
+ (连接连接字符串)
Concat(默认) 或 || (ANSI或ORACLE)
YYYMMDD
YYYYMMDD
YYYYMonthNameDD
YY[YY]-MM-DD
MM/DD/YY[YY]
YY[YY]/MM/DD
MM-DD-YY[YY]
YY[YY]-MM-DD
MM-DD-YY[YY]
YY[YY]-MM-DD
MM.DD.YY[YY]
YY[YY].MM.DD
DATEADD(day,1,GETDATE())
DATE_ADD(NOW(),INTERVAL 1 DAY)
DATEDIFF(day,GETDATE(),GETDATE()-1)
DATEDIFF(NOW(),NOW() – INTERVAL 1 DAY)
DATENAME(month,GETDATA())
DATE_FORMAT(NOW(),’%M)
DAYNAME(NOW())
DATEPART(month,GETDATE())
DATE_FORMAT(NOW(),’%m%’)
DAY(DATEDATE())
DATE_FORMAT(NOW(),’%d’%)
DAY(NOW())
DATOFMONTH(NOW())
GETDATE()
NOW()
SYDATE()
CURRENT_TIMESTAMP
CURRENT_TIMESTAMP()
GETDATE()+1
NOW() + INTERVAL 1 DAY
CURRENT_TIMESTAMP + INTERVAL 1 DAY
GETUTCDATE()
UTC_TIMESTAMP()
MONTH(GETDATE())
MONT(NOW())
YEAR(GETDATE())
YEAR(NOW)
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/25379809/viewspace-703994/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/25379809/viewspace-703994/