I'm hoping someone can help me out here. I've completed my latest program and am ready to deploy it to an office here in town. However, I'm not sure what the best method is? Here is my situation.

I know I can't use click once, so i need to create a setup package using visual studios setup, or the other one many here us. (I don't remember the name right now but will find that later).

I have a database all setup on my machine that talks to my code. I need to deploy this program to my clients office and deploy this database with it. However, i want all the machines in the office to install the program, and they all talk to the same database on their server.

So what I'm thinking is, i need to copy the database to their SQL server, or SQL server express. Have the users in the office install my application then somehow hook the program that was once connected to the database on my development computer to theirs. But I'm thinking the program wont recognize the database on their server, and keep looking for myn?

If anyone has any advice i would really appreciate it.