JIRA Schema

[cmbollareddy]

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. jiraschema).

[Alexis Robert · Accepted solution]

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

[cmbollareddy]

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?

[Alexis Robert]

Hello, 

you should create a new user and password.

[cmbollareddy]

Hi @Alexis Robert 

We have  JIRAUSER and JIRASCHEME for Existing databases. 

Can i use same jirauser and jiracheme for new DB or create new one.

[cmbollareddy]

Hi @Alexis Robert 

We have JIRAUSER(dbo) and JIRASCHEME (jiraseheme) for existing database. 

Can i use same name for JIRAUSER (dbo) and JIRAScheme  (jiraseheme) for new DB. 

or create new name?

[cmbollareddy]

@Alexis Robert 

Please reply to my query. 

[cmbollareddy]

@Alexis Robert 

I'm mid of work..please suggest us