Page 1 of 1

DB Update Script

Posted: Thu Nov 12, 2020 9:07 am
by dcrider
Is there a script you can provide to update the database tables from one version to the next? We're currently on 19.3 and would like to move to 20.4, but I'd rather not have to go through each table, identify the differences, and write the changes myself if I can avoid it. Currently I'm building both versions from the source in my testing environment.

Is a script like that something you could provide? Is there a better way to do what I need to do? I cannot upgrade any live instances at this time.

Re: DB Update Script

Posted: Thu Nov 12, 2020 6:47 pm
by drtech
the code has the script built into convertdatabase.cs

Re: DB Update Script

Posted: Fri Nov 13, 2020 8:18 am
by dcrider
Wonderful, thank you!

Re: DB Update Script

Posted: Fri Nov 13, 2020 12:01 pm
by jordansparks
The "script" is in C#. You can't run in separately. When you are ready to update, launch 20.4 and connect to the 19.3 db. It will prompt you to update the db.

Re: DB Update Script

Posted: Mon Nov 16, 2020 10:40 am
by dcrider
I had to clear the VlaueString for the WebServiceServerName preference so it would let me update, but I got it working.