Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

database does not change with new winforms installation

Posted on 2011-03-05
2
Medium Priority
?
400 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

Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

Question has a verified solution.

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

Monitor input from a computer is usually nothing special.  In this instance it prevented anyone from using the computer.  This was a preconfiguration that didn't work.
Windocks is an independent port of Docker's open source to Windows.   This article introduces the use of SQL Server in containers, with integrated support of SQL Server database cloning.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

772 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