Hi Farhad,

It's funny, I answered this question myself before, but somehow yesterday I was thinking I would be able to execute SQL Script from VS itself.

Thanks for the pointers.

>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.aspx
>
>Or 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-0c74863f3f5e
>
>HTH
>
>
>> 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?