I have created a simple application in C#.net 3.5, where i use database to insert, update, view & delete records. Now i want to deploy that application in other computer. How to package it with the sql database, so that when i install the application on other pc, the database should also be deployed into it.
should the other machine have sql & .net framework installed..?
Any Help would be appreciated!!
You should use "Sql Server Compact" Edition...you can deploy it easily with your application...it will create an DB file which you can export with your application.
Also you can try Visual Studio Setup Project. This project can detect automatically wether Sql Compact Client is installed on target machine or not...and if NOT it will install it.
You can build your final release with spoon stedio,it have a lot of advantage like run .net application with out installing .net frame work and databases such as SQL Server
Spoon is the only virtualization engine in its class to support virtualization of both 32- and 64-bit applications; system services and databases such as SQL Server; and advanced software technologies such as DCOM and SxS.
Run .NET Without .NET
Embed runtime dependencies such as .NET, Java, AIR, and SQL CE directly into virtual applications. Launch on completely clean desktops.
Edited There is an article about: Deploy your Application and Database
