error:migrate a table with IDENTITY column from MS SQL to MySQL !
Posted by: mao yu
Date: January 12, 2006 08:00PM

i have tried to migrate MS SQLSERVER to Mysql. but the magration toolkit can't convert a table 'CtsiInfoRecord11' .
I am using the latest Service Packs to WinXP and am using MySQL5.0.Migration Toolkit is 1.0.21 rc.

table 'CtsiInfoRecord11' :
create table CtsiInfoRecord11
(
InfoFee int default 0,
IdCdr numeric identity,
)
go

migration report :
`ultralink_dbo`.`CtsiInfoRecord11`
----------------------------------
Incorrect column specifier for column 'IdCdr'

help! how can i migrate the column IdCdr from ms sqlserver to mysql!

thanks!

Options: ReplyQuote


Subject
Written By
Posted
error:migrate a table with IDENTITY column from MS SQL to MySQL !
January 12, 2006 08:00PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.