Click here to Skip to main content
15,889,877 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
I need help on deploying a windows form application to a production environment. I have successfully created the application in visual studio 2010 and i used Entity Framework as the data store that is mapped to a sql server 2008R2 edition.The application runs fine on my developement machine but when i create the exe file and run it at another pc the application cannot find the database and there is a sql server 2008R2 installed on the Production machine.I also read somewhere that it is better to use sql server compact edition as a database instead of the full blown expresss edition.The help i need is how can i transfer the data in the sql express 2008R2 edition to the compact edition and make my application used the compact edition instead.Secondly how can i deploy it to a production environment that is a Pc different from the development machine.I have been searching for the answer for quite sometime now and i have not been able to see what i am looking for.Please i will be grateful it i can be pointed to an article that deals with the issues. Thanks i am still a noob at this please any help is appreciated.
Posted

1 solution

For Migrating Database to Compact edition This OR This


and for your second question you must not use absolute path in your project. make sure that you add all necessary file in your setup project like all dlls of sqlce database,your database,imagefiles etc
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900