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.
DB Update Script
Re: DB Update Script
the code has the script built into convertdatabase.cs
Re: DB Update Script
Wonderful, thank you!
-
jordansparks
- Site Admin
- Posts: 5770
- Joined: Sun Jun 17, 2007 3:59 pm
- Location: Salem, Oregon
- Contact:
Re: DB Update Script
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
http://www.opendental.com
Re: DB Update Script
I had to clear the VlaueString for the WebServiceServerName preference so it would let me update, but I got it working.