Solved

database does not change with new winforms installation

Posted on 2011-03-05
2
392 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

910 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now