DB Update Script

This forum is for programmers who have questions about the source code.
Post Reply
User avatar
dcrider
Posts: 67
Joined: Sun Sep 29, 2019 11:03 am
Contact:

DB Update Script

Post by dcrider » Thu Nov 12, 2020 9:07 am

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.

User avatar
drtech
Posts: 1647
Joined: Wed Jun 20, 2007 8:44 am
Location: Springfield, MO
Contact:

Re: DB Update Script

Post by drtech » Thu Nov 12, 2020 6:47 pm

the code has the script built into convertdatabase.cs
David Fuchs
Dentist - Springfield, MO
Smile Dental http://www.887-smile.com

User avatar
dcrider
Posts: 67
Joined: Sun Sep 29, 2019 11:03 am
Contact:

Re: DB Update Script

Post by dcrider » Fri Nov 13, 2020 8:18 am

Wonderful, thank you!

User avatar
jordansparks
Site Admin
Posts: 5739
Joined: Sun Jun 17, 2007 3:59 pm
Location: Salem, Oregon
Contact:

Re: DB Update Script

Post by jordansparks » Fri Nov 13, 2020 12:01 pm

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.
Jordan Sparks, DMD
http://www.opendental.com

User avatar
dcrider
Posts: 67
Joined: Sun Sep 29, 2019 11:03 am
Contact:

Re: DB Update Script

Post by dcrider » Mon Nov 16, 2020 10:40 am

I had to clear the VlaueString for the WebServiceServerName preference so it would let me update, but I got it working.

Post Reply