Is there a document that I can reference to set up a new SQL server for migration from the embedded database? Currently we have Jira and Confluence 50 user instance each running their own embedded database.
you can simply go to the Jira administration menu and backup your instance, then shut down Jira and remove dbconfig.xml file in your JIRA_HOME directory.
When you restart the instance, you will be prompted for the database setup, you can then enter your SQL Server connection details, and on the next screen will have an option to import data (the previously created backup).
This will import all data (Projects, Configuration, issues ...) into SQL Server.
The sizing will depend on how much data you're planning to have in a few months or years time. Basically, the issues will take up most of your storage so use this to size your database. For example, a 100k issue instance will be around 2 to 4GB.
For the CPU and Memory, you should refer to Microsoft documentation as it depends again on how many databases you're planning to host and the volume of data you'll have.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.