Deployment of a .NET application making use of SQL Server 2008
- by Victor John Saliba
I have searched the internet thoroughly for this type of issue, there were responses but hasn't really found a concrete solution yet.
I have an application which makes use of SQL Server 2008 R2 and thus it makes connections with a database file which I have set up. The application executes successfully, makes connections with the database and retrieves/inserts/updates data to and fro the database.
However when I come to create a deployment project i.e. a setup project, I fail to transfer my database files to other computers and make database connections. I have checked the SQL Server 2008 prerequisite in the publish settings of the application and has also included the database files.
Can anyone suggest the best way to this type of setup?
Thanks