Solved

database does not change with new winforms installation

Posted on 2011-03-05
2
398 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
With User Account Control (UAC) enabled in Windows 7, one needs to open an elevated Command Prompt in order to run scripts under administrative privileges. Although the elevated Command Prompt accomplishes the task, the question How to run as script…
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.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

623 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