how to Install vb.net window application on client system with database

[pinna_hari]

Hello, I am making one windows application in C#. I am using SQL Server as database.So, my question is I want to deploy the .exe file to the client with out installing sql server in clients system. to do that what files I should supply to him with SetUp exe.? If it is necessary to install SQL Server in client system how can i do? I want to install this exe in almost 100 systems. As I am new to Windows Application, can anyone explain about it... or give some article links so I can understand the whole processfrom creating application to End User deployment.

Pinna

[The Man from U N C L E]

You should not need to deploy any SQL engine or code to your client systems. You should have one SQL Server to which the clients connect. They just need to have the relevant connection string. If you are deploying this as a separate database for each user I would suggest something lighter such as SQL Server Express Edition. This for the secondary reason that the Express Edition is free whereas installing a full SQL edition on 100 machines will cost you upwards of £400,000 (gbp) that is $700,000 (usd). That is the approx going rate for an academic licence installation of SQL 2008 * 100 which is the cheapest licence available.

If you have knowledge, let others light their candles at it. Margaret Fuller (1810 - 1850) www.JacksonSoft.co.uk

[Christian Graus]

If the computers all run their own local DB, then an Access DB may have been better from a deployment POV, or SQL Server Compact. As it stands, you may need to install SQL Server Express, configure a connection string and deploy your DB onto it.

Christian Graus Driven to the arms of OSX by Vista. Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.