application deployment problem

[prestigio]

hi
i want my application when installed to make sure that my database is instaled on sqlserver if not than my application should created itself
my friend told me to write the code that create the datbase and the tables
( CREATE DATABASE var1 .........) in the class install
but i have more than 8 tables and that will be a long code to affect it to the SqlCommand
so is there any other way to make my application create the database when installed


PS : sorry for my english

 

[priyanks]

Hi Prestigio,

I can think of one way of doing that. How about you include the mdf file in your installation program. If the database doesn't exist, then create a database and attach the mdf file to that database.

 

[prestigio]

thanks priyanks for your answer but i found another solution
i add a text file to my project and write the sql code to create the tables and the database on it
and execute the code from the text file
http://msdn2.microsoft.com/en-us/library/49b92ztk.aspx Walkthrough: Using a Custom Action to Create a Database at Installation

 

[AlanLinden]

What if I am installing on another computer, and as per the MS instructions from that link, I am required to enter the name of the SQL server. If I don't know it, then what? Do I use localhost in my DB connection string, with no password or username? That is the question.

 

[AlanLinden]

Sorry, all I want is to be able to create a stand alone installer that only requires the client box to have SQL on it. Apart from that, they would just have to run the exe, and all is good. That is possible, isn't it?