How to install database using SQL script from .net deployment project in VS

[Nitin Singh]

We are using a VS Deployment Project to distribute an ASP.NET app.
Presently we take script files to client and run them in Query Analyser of
SQL Server. But we want to automate running of SQL scripts along with the
application installer.

We tried using a project which reads script files and run them by passing it
to SQL Client's Command object, but this accepts only ONE entity's script at
a time.

So in order to create about 100 tables and 500 sp, we require writing 600
calls to the function which sends the script to command object.

If we create the script for all objects in a single file, the "GO" keyword
throws and error.

Please help me.


Nitin Singh
ASP.NET Developer

India

 

[Jamie Bissett]

We are using a VS Deployment Project to distribute an ASP.NET app.
Presently we take script files to client and run them in Query Analyser of
SQL Server. But we want to automate running of SQL scripts along with the
application installer.

We tried using a project which reads script files and run them by passing
it
to SQL Client's Command object, but this accepts only ONE entity's script
at
a time.

So in order to create about 100 tables and 500 sp, we require writing 600
calls to the function which sends the script to command object.

If we create the script for all objects in a single file, the "GO" keyword
throws and error.

Please help me.


Nitin Singh
ASP.NET Developer

India

Check out this URL
http://www.codeguru.com/Csharp/.NET/net_security/encryption/article.php/c9601/

 

[Nitin Singh]

Thanks

the problem has been solved, by using the "regex " in the ExecuteSQL
function.

Nitin Singh

 

[prakashb]

Can you send me the code so that i can create for my project