Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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.

share|improve this question
    
and the error message is...? We are not a code translation service. Tell us what the error is and we might be able to tell you how to fix the problem. But right now you're just basically saying "do my job for me". –  Marc B Jul 9 '13 at 21:21
    
The error i am having is: SSMA for MySQL does not support FULLTEXT indexes(1) Estimated manual conversion time: 1 hr(s)1 M2SS0045: SQL Server Migration Assistant for MySql Warning message: Prefix length was ignored during conversion(3)2 M2SS0046: SQL Server Migration Assistant for MySql Info message: Zero Date(1)3 M2SS0052: SQL Server Migration Assistant for MySql Info message: {0} literal was converted to {1} literal(39)4 M2SS0231: SQL Server Migration Assistant for MySql Info message: Zero-date, zero-in-date and invalid dates to not null columns:(1)5 –  Daniel Aziz Jul 9 '13 at 21:27
    
I am sorry for that, actually i am a student and not that much skilled in database –  Daniel Aziz Jul 9 '13 at 21:28
    
blogs.msdn.com/b/ssma/archive/2011/03/19/… –  Marc B Jul 9 '13 at 21:30
    
Yeah, its related to my problem. Thank you, it is of help –  Daniel Aziz Jul 9 '13 at 21:34
add comment

migrated from stackoverflow.com Jul 11 '13 at 7:07

This question came from our site for professional and enthusiast programmers.

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.