Solved

database does not change with new winforms installation

Posted on 2011-03-05
2
395 Views
Last Modified: 2012-06-27
My winforms application uses a SQLServerCE database.  The project file was set to copy always on the last build.  I want a new install to carry the values in the database from my machine to the target machine.   Currently, that is not happening.   I can use Add/Remove Programs to remove my winforms application from the target machine, but when I re-install, the values in the database are the same as the ones that were there when the application was first installed....this is kinda cool for updating my application later on in this process,  but not when I am first building and testing what should be a "clean" install.

I tried uninstalling MS SQLServer CE with Add/Remove Programs, but apparently removing the program does not remove the tables or the values they contain.

Any advice, suggestions, appreciated.  Thanks in advance!
0
Comment
Question by:codefinger
  • 2
2 Comments
 

Accepted Solution

by:
codefinger earned 0 total points
ID: 35044517
Found the answer.  I have to remove the database from the project and add it back just before I publish.
0
 

Author Closing Comment

by:codefinger
ID: 35044520
My solution is to remove the database from the project and then add it back just before I publish.  In that way the values in the database will travel into the target computer.
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question