I have an mysql database that contains 38 tables. I used "SQL Server Migration Assistant for Mysql" tool to convert this database to SQL server Database. I successfully converted 37 tables. Only one table is making error. Can anyone write the exact code of this (mysql table) in SQL server. I am using SQL Server 2008. The code is;
CREATE TABLE `oc_t_item_description` ( `fk_i_item_id` int(10) unsigned NOT NULL, `fk_c_locale_code` char(5) NOT NULL, `s_title` varchar(100) NOT NULL, `s_description` mediumtext NOT NULL, PRIMARY KEY (`fk_i_item_id`,`fk_c_locale_code`), FULLTEXT KEY `s_description` (`s_description`,`s_title`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8
I want all keys to remain unchanged. In short the above code should be exactly changed to SQL server. so that i may create it manually.