MSSQL default export (2008)
--------------------


1. Create a database
https://confluence.atlassian.com/display/JIRA/Connecting+JIRA+to+SQL+Server+2008

Create database, ensure that Collation is 'SQL_Latin1_General_CP437_CI_AI'


2. Download a standalone version of JIRA
https://www.atlassian.com/software/jira/download-archives\
Version: 6.3

// extract and set home directory
unzip atlassian-jira-6.3.zip
cd atlassian-jira-6.3-standalone/
mkdir home
echo "jira.home=`pwd`/home" > atlassian-jira/WEB-INF/classes/jira-application.properties

// db driver
download
https://github.com/Microsoft/mssql-jdbc/releases/download/v6.2.1/mssql-jdbc-6.2.1.jre8.jar

cp mssql-jdbc-6.2.1.jre8.jar lib/

// start jira
bin/start-jira.sh

//configure db

// insert following license
 

// admin details

Full name: Administrator
Email: admin@example.com
Username: admin
Password: admin

// notifications
don't configure email options

// finally the dashboard

// stop JIRA

// execute following updates:

UPDATE propertystring SET propertyvalue = './data/attachments' where ID = (SELECT ID FROM propertyentry where ENTITY_NAME = 'jira.properties' and ENTITY_ID = 1 AND PROPERTY_KEY = 'jira.path.attachments' AND propertytype = 5);
UPDATE propertystring SET propertyvalue = './export' where ID = (SELECT ID FROM propertyentry where ENTITY_NAME = 'jira.properties' and ENTITY_ID = 1 AND PROPERTY_KEY = 'jira.path.backup' AND propertytype = 5);

// Do a db export

Right click > Tools > Generate Script

Choose Objects -> select all tables (this excludes the database itself)
