title: Run script in SQL Server CE database
body: <p>I've used the <code>Databases &gt; Tasks &gt; Generate Script</code> functionality in SQL Server Management Studio Express to generate and save a few tables to a script in a <code>.sql</code> file. Now that I have the <code>.sql</code> script I'd like to run I've added a SQL Server CE database to the <code>App_Data</code> folder of my ASP.NET application but I can't seem to figure out how to run the script in my <code>.sql</code> file on the SQL Server CE database.</p>
  
  <p>By the way, I've already tried to copy the SQL Server CE database from my application to the folder my other database files are stored in and attempted to attach the SQL Server CE database to the "Databases" in my SQL Server Management Studio Express. However we're evidently unable to attach SQL Server CE databases. This means, evidently we're also unable to run scripts on a SQL Server CE databases in SSMSE.</p>