I have an MS sql data base file which I need to import it into Mysql. Is this possible? If yes, how to do that?
I tried the following but failed:
Created a new dbase and called it dbase. Then:
PHP Code:
mysql -u root -p
password:
mysql> use mydbase
mysql> SOURCE /path/to/my/MSsql/file.sql;
I got the following:
PHP Code:
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IF @p_where_str IS NOT NULL
SET @l_where^str = @l_where_str + 0