Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Celebration

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root

Avatar

1 badge earned

Collect

Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!

Challenges
Coins

Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.

Recognition
Ribbon

Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!

Leaderboard

Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,463,405
Community Members
 
Community Events
176
Community Groups

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

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

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.

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?

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