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

Popular posts from this blog

sublimetext3 - what keyboard shortcut is to comment/uncomment for this script tag in sublime -

java - No use of nillable="0" in SOAP Webservice -

ubuntu - Laravel 5.2 quickstart guide gives Not Found Error -