deploy wpf app with sql database

Question

I am using Visual Studio Setup and Deployment deploying my wpf app. My aim is to package my wpf app so that I can install and run it in any machines which don't have sql installed and machines don't have internet access. I am using sql server express 2008 r2 and VS2010. I did some research, migration might be the solution but I have no idea how to use it and I don't find helpful tutorials for that. Please help me. Thanks in advance.

Answer 1

You can use Microsoft SQL Server Compact Edition with a private deployment. See this good article

Answer 2

In your setup Project, Go to project properties, Click for prerequisite button and check sql server version you are using for your project, also check the .Net version of the project.

if the host computer don't have the internet than select "specify the install option" as Download the prerequisites form the same location as my application.

This will create a full package of your application and ready to be deployed in any machine.