It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

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

1 answer

1 accepted

0 votes
Answer accepted
Alexis Robert Community Leader Oct 21, 2019

Hi @Chandramouli Bollareddy , 

 

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?

Alexis Robert Community Leader Oct 21, 2019

Hello, 

 

you should create a new user and password.

Like Chandramouli Bollareddy likes this

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.

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?

@Alexis Robert 

 

Please reply to my query. 

@Alexis Robert 

 

I'm mid of work..please suggest us

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted in Jira

Demo Den Ep. 7: New Jira Cloud Reports

Learn how to use two new reports for next-gen projects in Jira Cloud:  Cumulative flow diagram and Sprint burndown chart. Ivan Teong, Product Manager, Jira Software, demos the Cumulative ...

303 views 1 3
Join discussion

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you