[phpwiki-checkins] CVS: phpwiki/admin translate_mysql.pl,NONE,1.1.2.1

[Steve W. <wai...@us...>]

Update of /cvsroot/phpwiki/phpwiki/admin
In directory usw-pr-cvs1:/tmp/cvs-serv13508/admin

Added Files:
      Tag: release-1_2-branch
	translate_mysql.pl 
Log Message:
Missed these but they will be in the 1.2.2 release. Code for Microsoft
SQL Server.


--- NEW FILE ---

# Convert MySQL wiki database dump to a Microsoft SQL-Server compatible SQL script
# NB This is not a general-purpose MySQL->SQL-Server conversion script

# Author: Andrew K. Pearson
# Date:   01 May 2001

# Example usage: perl translate_mysql.pl dump.sql > dump2.sql

# NB I did not use sed because the version I have is limited to input lines of <1K in size

while (<>)
{
	$newvalue = $_;

	$newvalue =~ s/\\\"/\'\'/g;
	$newvalue =~ s/\\\'/\'\'/g;
	$newvalue =~ s/\\n/\'+char(10)+\'/g;
	$newvalue =~ s/TYPE=MyISAM;//g;
	$newvalue =~ s/int\(.+\)/int/g;
	$newvalue =~ s/mediumtext/text/g;
	$newvalue =~ s/^#/--/g;

	print $newvalue;
}