Hi,
I have created NEW DB in SQL 2014 for JIRA Installation.
Based on below document,
https://confluence.atlassian.com/adminjiraserver/connecting-jira-applications-to-sql-server-2014-938846861.html
How to create a Schema in DB.
Create an empty 'schema' in the database for the Jira tables (e.g. <strong>jiraschema</strong>).
<strong>jiraschema</strong>
Hi @cmbollareddy ,
you can follow this script to create the schema and all the other settings for SQL Server : https://gist.github.com/SidShetye/f0d51beb5cc5858b92bb
Let me know if this helps,
--Alexis
Hi @Alexis Robert
I have one more Query:
In this SQL server 2014, We have JIRA, Confluence, BitBucket and etc databases available.
For New Installation of JIRA (New Linux Server), We will create a NEW DB(Atl_Jira) in SQL 2014 Server (Existing Server).
In this server, we have "jirauser" and "jirascheme" available for existing DB of JIRA, Confluence and etc.
So, Shall i create New JIRAUSER and JIRASCHEME for new JIRA installation for NEWDB in Existing SQL Server.
Or shall i user earlier JIRAUSER and JIRASCHEME?
Hello,
you should create a new user and password.
We have JIRAUSER and JIRASCHEME for Existing databases.
Can i use same jirauser and jiracheme for new DB or create new one.
It looks like you're new here. Sign in or register to get started.
