mysql - SSMA Migration error -
i doing migration mysql sql server. 1 of table not migrated reason follows
create table `user_tb` (`user_id` int(11) not null auto_increment, `username` varchar(30) not null, `password` text not null, `salt_id` varchar(20) not null, `emailid` varchar(50) not null, `gender` enum('male','female') default null, `country` int(5) default null, `pincode` int(8) default '0', `dob` date not null default '0000-00-00',
column 'dob' not allow dbnull.value.
i using sql server migration assistant (ssma) please suggest..
int(8) default '0', dob date not null default '1500-01-01', >> yyyy-mm-dd
you musn't write default value 0, must 1. cause dob date not null
mean can't have null value, cause of default value 0 , become 0000-00-00
, null,, tried change 1
of course, date value not have 00 day , 00 month or impossible 0000 year. try set year default value minimum of years in database. 2000 or like
Comments
Post a Comment