title: convert sql script into format that can run on sqlite
body: <p>I have a sql script generated by Entity framework which creates a very simple table.</p>
  
  <pre><code>create table [Destinations] (
      [Id] [int] not null identity,
      [Country] [nvarchar](max) null,
      [State] [nvarchar](max) null,
      [City] [nvarchar](max) null,
      primary key ([Id])
  );
  </code></pre>
  
  <p>I'm trying to run this on Sqlite database, but it seems the syntax is different.
  I have tried to write a replace method to replace the keywords with their sqlite version, which is not fully working. 
  I was wondering if there is a better way to make these changes or if there is a library to do this in C#?</p>
  
  <p>This is the converted script:</p>
  
  <pre><code>create table [Destinations] ( 
  [Id] INTEGER not null AUTOINCREMENT , 
  [Country] [nvarchar](max) null, 
  [State] [nvarchar](max) null, 
  [City] [nvarchar](max) null, 
  primary key ([Id]) 
  );
  </code></pre>