Reply to thread

Message

One of the solutions I have done is this:

sql = sql.Replace("---", "#"); //Added by Dunkstar, MySQL dont use --- as comments
sql = sql.Replace("use master", " "); //Added by Dunkstar, there is no master database in MySQL
sql = sql.Replace("IF EXISTS (SELECT name FROM sysdatabases WHERE name = N'TvLibrary')", " "); //Added by Dunkstar, dont work in MySQL
sql = sql.Replace("IDENTITY(1,1) NOT NULL", "NOT NULL AUTO_INCREMENT"); //Added by Dunkstar, MySQL uses Auto_increment
sql = sql.Replace("IDENTITY(1,1)NOT NULL", "NOT NULL AUTO_INCREMENT"); //Added by Dunkstar, MySQL uses Auto_increment
sql = sql.Replace(" Version(", " Version ("); //Added by Dunkstar
sql = sql.Replace(" version(", " version ("); //Added by Dunkstar
sql = sql.Replace(" WITH CHECK ADD ", "ADD"); //Added by Dunkstar

Dont know what your thoughts are on this.

<blockquote data-quote="dunkstar" data-source="post: 108603" data-attributes="member: 28804">One of the solutions I have done is this:sql = sql.Replace(&quot;---&quot;, &quot;#&quot;); //Added by Dunkstar, MySQL dont use --- as comments&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; sql = sql.Replace(&quot;use master&quot;, &quot; &quot;); //Added by Dunkstar, there is no master database in MySQL&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; sql = sql.Replace(&quot;IF EXISTS (SELECT name FROM sysdatabases WHERE name = N'TvLibrary')&quot;, &quot; &quot;); //Added by Dunkstar, dont work in MySQL&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; sql = sql.Replace(&quot;IDENTITY(1,1) NOT NULL&quot;, &quot;NOT NULL AUTO_INCREMENT&quot;); //Added by Dunkstar, MySQL uses Auto_increment&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; sql = sql.Replace(&quot;IDENTITY(1,1)NOT NULL&quot;, &quot;NOT NULL AUTO_INCREMENT&quot;); //Added by Dunkstar, MySQL uses Auto_increment&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; sql = sql.Replace(&quot; Version(&quot;, &quot; Version (&quot;); //Added by Dunkstar&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; sql = sql.Replace(&quot; version(&quot;, &quot; version (&quot;); //Added by Dunkstar&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; sql = sql.Replace(&quot; WITH CHECK ADD &quot;, &quot;ADD&quot;); //Added by Dunkstar&nbsp; &nbsp; Dont know what your thoughts are on this.</blockquote>

[QUOTE="dunkstar, post: 108603, member: 28804"] One of the solutions I have done is this: sql = sql.Replace("---", "#"); //Added by Dunkstar, MySQL dont use --- as comments sql = sql.Replace("use master", " "); //Added by Dunkstar, there is no master database in MySQL sql = sql.Replace("IF EXISTS (SELECT name FROM sysdatabases WHERE name = N'TvLibrary')", " "); //Added by Dunkstar, dont work in MySQL sql = sql.Replace("IDENTITY(1,1) NOT NULL", "NOT NULL AUTO_INCREMENT"); //Added by Dunkstar, MySQL uses Auto_increment sql = sql.Replace("IDENTITY(1,1)NOT NULL", "NOT NULL AUTO_INCREMENT"); //Added by Dunkstar, MySQL uses Auto_increment sql = sql.Replace(" Version(", " Version ("); //Added by Dunkstar sql = sql.Replace(" version(", " version ("); //Added by Dunkstar sql = sql.Replace(" WITH CHECK ADD ", "ADD"); //Added by Dunkstar Dont know what your thoughts are on this. [/QUOTE]