Hey guys,
We want to migrate our JIRA database from the default instance found on an SQL Server 2008 R2 to a named instance on SQL Server 2014.
The server hosting both the SQL Server 2008 R2 and SQL server 2014 is the same. I am aware of the file named "dbconfig.xml". Inside this file I see the following connection string:
<url>jdbc:jtds:sqlserver://SQLSERVERNAMEHERE.OURDOMAIN.LOCAL:1433/JIRA_DATABASE</url>
Could I take a Full backup with SQL management studio and manually create a new database on SQL Server 2014 then do a restore of the backup taken with the REPLACE parameter? I would then have to configure the "dbconfig.xml" file with a proper connection string. Problem is, I don't know how to specify the instance name of our SQL Server 2014 in the connection string.
Let me know what you think,
thanks!
