|I have a SQLite DB attached to a VB.Net app. I have about two years of data I would like to not loose.
So with DB Browser I can change the two fields from TEXT to INTEGER.
Then make necessary changes in the code to reflect the changes in the DB.
Below are the variables that are declared in a Data Module used for searching
Public gvYear As String
Public gvFromMonth As Integer
Public gvToMonth As Integer
Only change here gvYear will become an Integer
Here is the code that created the original DB
Public Sub makeTxData()
'create table TxDataTable String for cmd
Dim create_table As String = String.Empty
create_table = "CREATE TABLE IF NOT EXISTS TxData(
TID INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
Dim dbTable As String = "TxDataTable"
Changes here txYear and txSearchMonth will be INTEGERS txSearchMonth int that reflects month of year
Steps for Process
Copy DB and Paste DB in another folder
Make Changes to Code that creates the DB
Make Changes in the DB manually with DB Browser
Uninstall the app and make new exe file with Inno Setup with new GUID
Create the new DB and delete the DB that is created then Paste the OLD DB in the new app version
I am sure I am overlooking something here so I guess the question is
Will this work ?
Is there a better way to accomplish this ?
Because this is a Check Book app I hate to loose the data.
What are the risks of this happening ?