User Tools

Site Tools


installing_the_parameter_database_updated

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
installing_the_parameter_database_updated [2021/11/05 10:43]
mina
installing_the_parameter_database_updated [2023/01/20 17:03] (current)
ecoloco [Step 2 - Install User interface and Administration tool for Facilia Parameter database]
Line 7: Line 7:
 Instructions below assume that you don’t have any instances of the SQL Server installed which is usual situation for the end-user computer. If you are not sure, for example, if you have on the computer some software which might install SQL Server, then presence of SQL Server can be verified as shown here [[List instances of SQL Server installed|List instances of SQL Server installed]]. If any instance is listed there - skip Sep 1 Instructions below assume that you don’t have any instances of the SQL Server installed which is usual situation for the end-user computer. If you are not sure, for example, if you have on the computer some software which might install SQL Server, then presence of SQL Server can be verified as shown here [[List instances of SQL Server installed|List instances of SQL Server installed]]. If any instance is listed there - skip Sep 1
  
-===Step 1 - Install SQL Server Express===+=====Step 1 - Install SQL Server Express=====
 The latest version of the SQL Server Express (SQL Server 2019 Express Edition) can be found at https://www.microsoft.com/en-us/sql-server/sql-server-downloads The latest version of the SQL Server Express (SQL Server 2019 Express Edition) can be found at https://www.microsoft.com/en-us/sql-server/sql-server-downloads
  
Line 15: Line 15:
  
   * Select “Basic” installation. Basic installation will require minimal interaction from your side during the installation process.   * Select “Basic” installation. Basic installation will require minimal interaction from your side during the installation process.
-  * Download and install command-line tools for SQL Server [[command-line tools|command-line tools]]+  * Download and install command-line tools for SQL Server [[https://www.microsoft.com/en-us/download/details.aspx?id=53591|command-line tools]]
  
-===Step 2 - Install User interface and Administration tool for Facilia Parameter database=== +=====Step 2 - Install User interface and Administration tool for Facilia Parameter database===== 
-  - Download installation file available in the section Parameter database in the [[Downloads|Downloads]].+  - Download installation file using the link you will receive from our support.
   - Run installation file and follow instruction.   - Run installation file and follow instruction.
  
-===Step 3 - Create empty database facilia_db_template=== +=====Step 3 - Create empty database facilia_db_template===== 
-  After finishing of software installation in the previous step - find a sub-folder utilities in the Parameter Database software folder, typically C:\Program Files (x86)\Facilia DB\utilities +1. After finishing of software installation in the previous step - find a sub-folder utilities in the Parameter Database software folder, typically** C:\Program Files (x86)\Facilia DB\utilities**\\ 
-  Copy folder utilities to your desktop+2. Copy folder **utilities** to your desktop\\ 
 //Warning! If you have skipped Step 1, then you might need to edit a file inst.bat located in the folder utilities. This also required if you like to change default installation settings. Details are described in the section Advanced// //Warning! If you have skipped Step 1, then you might need to edit a file inst.bat located in the folder utilities. This also required if you like to change default installation settings. Details are described in the section Advanced//
-- Run file inst.bat located in the folder utilities by double-clicking on the file name in Windows Explorer. The process of database creation may takes several minutes. In the case of success you will get message “Database has been created” 
  
-In the case of errors you will get the message “Error! Check file log.txt”. Open file log.txt located in the same directory to review details about error. In the case of errors you might need to edit inst.bat as described in the Advanced section below.+3. Run file **inst.bat** located in the folder **utilities** by double-clicking on the file name in Windows Explorer. The process of database creation may takes several minutes. In the case of success you will get message **“Database has been created”** 
 + 
 +In the case of errors you will get the message **“Error! Check file log.txt”**. Open file **log.txt** located in the same directory to review details about error. In the case of errors you might need to edit inst.bat as described in the Advanced section below.
  
-===Step 4 - Start database tools first time, setup connection=== +=====Step 4 - Start database tools first time, setup connection===== 
-Run Facilia DB Administration tool.+Run **Facilia DB Administration tool**.
  
 Setup connection parameters and test connection to the server as described in the [[Starting the Parameter database|Starting the Parameter database]] Setup connection parameters and test connection to the server as described in the [[Starting the Parameter database|Starting the Parameter database]]
  
-===Step 5 - Create first project for your database=== +=====Step 5 - Create first project for your database===== 
-Run Facilia DB Administration tool.+Run **Facilia DB Administration tool**.
  
-Enter user in the Name fileld and fdb in the Password field in the login screen of the tool.+Enter **user** in the Name fileld and **fdb** in the Password field in the login screen of the tool.
  
-Warning! If you have edited the inst.bat you will need also to change the connection settings of the Facilia DB Administration Tool+//Warning! If you have edited the inst.bat you will need also to change the connection settings of the Facilia DB Administration Tool//
  
-Create new user account (using button Create user on the toolbar).+Create new user account (using button **Create user** on the toolbar).
  
-Create new project (using button Create project on the toolbar).+Create new project (using button **Create project** on the toolbar).
  
 Assign newly created user to the role of administrator of this project (using table Roles). Assign newly created user to the role of administrator of this project (using table Roles).
  
-Exit Facilia DB Administration tool.+Exit **Facilia DB Administration** tool.
  
-In the case of problems during the steps above - these materials will help you: +=====In the case of problems during the steps above - these materials will help you:===== 
-Installing the Parameter Database - Advanced topics+[[Installing the Parameter Database - Advanced topics|Installing the Parameter Database - Advanced topics]]
  
  
installing_the_parameter_database_updated.1636105417.txt.gz · Last modified: 2021/11/05 10:43 by mina