I'm not sure about SQL Compact Edition but there is something just to remember as following:
Instead of running the SQL script may be it's better to use SMO,
(SQL Server Management Object)
Create Table in SQL Server 2005 Using C# and SQL Server Management Objects (SMO) - Code Generation (by David Hayden)
http://davidhayden.com/blog/dave/archive/2006/01/27/2775.aspxOr you can run it by generating a new process, initialize it and then
start the process. Anyway, I didn't test this one, my favorite solution
is SMO.
Executing SQL script using C# (MSDN .NET Forum)
http://social.msdn.microsoft.com/Forums/en-US/netfxbcl/thread/56ecc5a6-0e00-4df3-9ddf-0c74863f3f5eHTH
> I've created a SQL script to create a database from existing database.
> I have the project Dolphin scanner that already has several projects in it. One is web service, one is a form. To this project I tried to add a new database item (SQL Compact edition). It then created an empty dataset. My question is - how can I run the script (saved sql) to create my tables?