Upgrading from a "Free" version to an Enterprise version with either SQL Server or Oracle as the DB

Peter Slater February 7, 2018

As my bio indicates, the managers are tracking AGILE projects using a "free" version ($10 a month) and want to move to the enterprise version.  It appears that use of the trial version would work via an XML export/import but I don't know if that is possible with from the "free" version.

1 comment

Jobin Kuruvilla [Adaptavist]
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 8, 2018

Whether the JIRA version is free or licensed, you could use SQL server or Oracle. And you can upgrade it as long as you have a valid license. Both XML export/import and upgrading using the installer will work.

Peter.Slater February 22, 2018

Regarding specifics - It is reasonable to assume the database schemas are the same if an XML export/import can be used - especially if triggers populate default values for not null columns that may be different between the two versions - but are there differences in column lengths, datatypes that are automatically changed in the XML import, stored procedures, and most important, are there any columns in the enterprise version that have significantly different or even nuanced different from the same column in the "free" version?

Can you use the Oracle's Data Pump export/import utility  instead of the XML?  And will SQL Developer/Toad/Enterprise Manager Express | Grid Control be used for managing both "free" and licensed versions.   For Microsoft, will the XML output be used to import into both Excel and Access as well?

Jobin Kuruvilla [Adaptavist]
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 23, 2018

There are no differences in data between the free and enterprise version. Having said that, you can also use the Oracle utilities to export/import data to the new version and just point the JIRA instance to the new DB.

Do it in a test instance since you are attempting it for the first time ;)

Comment

Log in or Sign up to comment
TAGS
AUG Leaders

Atlassian Community Events