Include database in windows forms setup project

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

, +

I created a windows application and i created database for that application in sql server 2005.then i add connection to the database from server explorer(right click on Data connections-->add new connection)every thing works fine in my system.when i create the setup file by creating the new setup template or by clicking on publish.the files .msi or .exe wont work on other computers because the database is not included in the project.
how to include the databe in the executable file(not sql server express simply database only)

Posted 7-Jan-11 18:34pm

krishna_goluguri

Add a Solution

4 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Valery Possoz · Answer 1 · 2011-01-08T00:44:00

Hi,

You could use custom actions in your visual studio installer project to install your database on the target computer.

A good start would be to read this very good article that will explain you how to do it.

Deploy SQL Server databases easily with an Installer class[^]

You can also consult msdn for detailed information.

Valery.

Kasson · Answer 2 · 2011-01-07T18:45:00

Solution 1

Hope this[^]will give you an idea.

Posted 7-Jan-11 18:45pm

Kasson

Comments

krishna_goluguri 8-Jan-11 3:09am

through the links its not worked please give me step by step description by taking a small example please

Sandeep Mewara · Answer 3 · 2011-01-07T20:17:00

Solution 2

Also, have a look at these discussion links:
Link 1[^]
Link 2[^]
Link 3[^]

Posted 7-Jan-11 20:17pm

Sandeep Mewara

Comments

krishna_goluguri 8-Jan-11 3:09am

through the links its not worked please give me step by step description by taking a small example please

MohamadHajkhodabakhshi · Answer 4 · 2011-01-08T04:30:00

you should copy file database with file .exe and install sqlserver2005
and use this code in load form
string mypath = string.Empty;

mypath = Application.StartupPath.ToString();
SqlConnection attachCon = new SqlConnection("server =(local);database=master;Integrated Security=True");

SqlCommand cm = new SqlCommand();
cm.CommandType = CommandType.Text;
cm.CommandText = "sp_attach_db @dbname = N'Metal', " +
" @filename1 = N'" + mypath + "\\DB\\Test_Data.MDF" + "'," +
"@filename2 = N'" + mypath + "\\DB\\Test_Log.LDF" + "'";
attachCon.Open();
cm.Connection = attachCon;
cm.ExecuteNonQuery();

Include database in windows forms setup project

4 solutions

Solution 3

Solution 1

Solution 2

Solution 4

Add your solution here

Preview 0