Hi,

I am not sure if this is the right forum for this question.

How do i deploy and install the sql server database?
I do not want to include it with the .Net application.
I want it as as seperate file.

I am looking for this particular method: generate script for the database and install the database.
I did not find a proper article explainig the steps for this.
I want to know the process or steps for this method of deployment.
Any information or articles on this will be helpful.

Thanks in advance

Hi rowter,

It is not clear to me whether you want to
1. Install Sql Server during the installation of your application?
Or
2. Sql Server has already been installed, you want to create database, tables, stored procedure during the installation of your applicaiton?

If you mean the first one. What version of Sql Server do you want to install? Sql Server Express edtion or enterprise edition? You can install express edition easily by select it as prerequisite. You can do this as: right click your setup project -> properties -> prerequisite.

If you mean the second one. Here is a topic talking about that.
http://msdn.microsoft.com/en-us/library/49b92ztk%28VS.80%29.aspx
The topic use custom action to create database, table, stored procedure via SqlCommand. All these sql script should be coded first into a txt file. Then read the script to run it.

If you have any question about it, please feel free to tell me.

Sincerely,
Kira Qian

---

Please mark the replies as answers if they help and unmark if they don't.

Hi rowter,

It is not clear to me whether you want to
1. Install Sql Server during the installation of your application?
Or
2. Sql Server has already been installed, you want to create database, tables, stored procedure during the installation of your applicaiton?

If you mean the first one. What version of Sql Server do you want to install? Sql Server Express edtion or enterprise edition? You can install express edition easily by select it as prerequisite. You can do this as: right click your setup project -> properties -> prerequisite.

If you mean the second one. Here is a topic talking about that.
http://msdn.microsoft.com/en-us/library/49b92ztk%28VS.80%29.aspx
The topic use custom action to create database, table, stored procedure via SqlCommand. All these sql script should be coded first into a txt file. Then read the script to run it.

If you have any question about it, please feel free to tell me.

Sincerely,
Kira Qian

---

Please mark the replies as answers if they help and unmark if they don't.