2 # Convert MySQL wiki database dump to a Microsoft SQL-Server compatible SQL script
\r
3 # NB This is not a general-purpose MySQL->SQL-Server conversion script
\r
5 # Author: Andrew K. Pearson
\r
8 # Example usage: perl translate_mysql.pl dump.sql > dump2.sql
\r
10 # NB I did not use sed because the version I have is limited to input lines of <1K in size
\r
16 $newvalue =~ s/\\\"/\'\'/g;
\r
17 $newvalue =~ s/\\\'/\'\'/g;
\r
18 $newvalue =~ s/\\n/\'+char(10)+\'/g;
\r
19 $newvalue =~ s/TYPE=MyISAM;//g;
\r
20 $newvalue =~ s/int\(.+\)/int/g;
\r
21 $newvalue =~ s/mediumtext/text/g;
\r
22 $newvalue =~ s/^#/--/g;
\r