When upgrading multiple co-existing instances to 15.1 does anyone have a good process suggestion for being able to upgrade the databases seeing as how it requires an update to the license? We're using the multi-instance process for the web server but hate to install/uninstall the application on my desktop that many times to go through the upgrade process. If we didn't have to worry about the license we could just use the dbupgrader.exe directly. We are upgrading from 10.6 to 15.1.2 so we do not have the proper licensing to allow the upgrade using dbupgrader.exe without having the new licensing in place first.
iMis 15 Licensing with Multi-Instance
licensing script
On February 12th, 2010 AaronHaley says:
I actually took this idea from the NiUG Forum...
UPDATE System_Params
SET ShortValue=',MEMBERSHIP,MEETINGS,<snip>,'
WHERE ParameterName='System_Control.LicensedProducts'
UPDATE System_Params
SET ShortValue='<snip>'
WHERE ParameterName='System_Control.Checksum'
UPDATE System_Params
SET ShortValue='<snip>'
WHERE ParameterName='System_Control.UsersLicensed'
Aaron Haley| Senior Network Systems Architect| TMA Technical Information Systems 401 W. 15th St. | Austin, TX 78701 | : : 512.370.1474 | : 512.370.1693 | : aaron.haley@texmed.org
That's even quicker...
On February 12th, 2010 Henry Huey says:
Remember that if your LicensedProducts string is > 255 characters, it needs to be written to LongValue instead of ShortValue; set ShortValue to empty string.
Try editing the licensing in 10.6 desktop first...
...against each of your instances (File / System Setup), and then run dbupgrade.