Connecting JIRA applications to Azure SQL
These instructions will help you connect JIRA Server or JIRA Data Center to an Azure SQL database.
はじめる前に
- If you're Migrating JIRA applications to another server, create an export of your data as an XML backup. You will then be able to transfer data from your old database to your new database, as described in Switching databases.
- If you're not too familiar with Azure, you can use our official templates to easily deploy JIRA Data Center into Azure.
1. Azure SQL データベースを作成する
Azure SQL データベースを作成します。「クイックスタート: Azure で単一のデータベースを作成する」を参照してください。
要件
- Collation: When creating the database, make sure to set the right collation in Additional settings, as you won't be able to change it later. Collation types supported by JIRA are
SQL_Latin1_General_CP437_CI_AI
andLatin1_General_CI_AI
.
2. Allow JIRA to connect to the database
You need to add the IP address of your JIRA server to the database's firewall rules to allow JIRA to connect to your Azure SQL database. See Azure SQL database firewall rules.
3. Jira を構成してデータベースに接続する
There are two ways to configure your JIRA server to connect to your Azure SQL database.
接続文字列を見つける
When connecting JIRA to the database, you’ll need to provide connection details, such as hostname, port number, and database name. You can find them in the Azure portal by opening your deployed database and going to Connection strings.
Using the JIRA setup wizard — Use this method, if you have just installed JIRA and are setting it up for the first time. Your settings will be saved to the
dbconfig.xml
file in your JIRA application home directory.Using the JIRA configuration tool — Use this method, if you have an existing JIRA instance. Your settings will be saved to the
dbconfig.xml
file in your JIRA application home directory.
データベース接続フィールド
The sections below describe the fields you'll need to fill out when connecting JIRA to your database.