Difference between revisions of "Install SQL Server"

From FMR Knowledge Base
Jump to navigation Jump to search
(→‎Overview)
(→‎Overview)
Line 2: Line 2:
 
[[Category:How_To V11]]
 
[[Category:How_To V11]]
 
=Overview=
 
=Overview=
−
Fusion Metadata Registry (FMR) needs an operating database to store the structural metadata, configuration settings and other operating information like audit logs. MySQL, Oracle and SQL Server are supported. If you already have one of those services available, use that and simply create a new schema for FMR to use.
+
SQL Server may be used to act as the persistant store for Registry information and the JDBC driver that communicates from the Registry to a SQL Server instance is provided within FMR.
−
+
 
−
For those without an existing database service, the rest of this guide explains how to install and configure SQL Server on Windows.
+
= Installation =
 +
It is beyond the scope of this article to explain how to install SQL Server, but at the current time of writing SQL Server may be [https://www.microsoft.com/en-GB/sql-server/sql-server-downloads downloaded from Microsoft for free].
 +
 
 +
= Setup for use in Fusion Registry =
 +
It is recommended to use an empty database in your SQL Server instance for FMR.
 +
 
 +
= Connection Details =
 +
FMR requires a database to be specified on the first page of the Install Wizard.  This can be changed at a later from the Administrator "Database Settings" page.
 +
 
 +
SQL Server by default uses port 1433.  If you wish to make a custom connection to SQL Server, the information you will likely need is:
 +
 
 +
{| class="wikitable" style="vertical-align:top; text-align:left;"
 +
! Connection String
 +
|| Of the form:
 +
jdbc:sqlserver://<server url>:<server port>;databaseName=<your database>
 +
<br/>
 +
e.g. jdbc:sqlserver://localhost:1433;databaseName=fusion_registry
 +
|-
 +
! Dialect
 +
|| org.hibernate.dialect.SQLServerDialect
 +
|-
 +
! Class Name
 +
|| com.microsoft.sqlserver.jdbc.SQLServerDriver
 +
|}
  
 
=Instructions=
 
=Instructions=
 
To be written
 
To be written

Revision as of 06:54, 13 October 2022

Overview

SQL Server may be used to act as the persistant store for Registry information and the JDBC driver that communicates from the Registry to a SQL Server instance is provided within FMR.

Installation

It is beyond the scope of this article to explain how to install SQL Server, but at the current time of writing SQL Server may be downloaded from Microsoft for free.

Setup for use in Fusion Registry

It is recommended to use an empty database in your SQL Server instance for FMR.

Connection Details

FMR requires a database to be specified on the first page of the Install Wizard. This can be changed at a later from the Administrator "Database Settings" page.

SQL Server by default uses port 1433. If you wish to make a custom connection to SQL Server, the information you will likely need is:

Connection String Of the form:

jdbc:sqlserver://<server url>:<server port>;databaseName=<your database>
e.g. jdbc:sqlserver://localhost:1433;databaseName=fusion_registry

Dialect org.hibernate.dialect.SQLServerDialect
Class Name com.microsoft.sqlserver.jdbc.SQLServerDriver

Instructions

To be written

Retrieved from "https://fmrwiki.sdmxcloud.org/index.php?title=Install_SQL_Server&oldid=6664"