TOTVS Fluig English

Árvore de páginas

Versões comparadas

Versão antiga 6

changes.mady.by.user Julia Larissa Schultz

Gravado em

comparado com

Nova versão 7

changes.mady.by.user Julia Larissa Schultz

Gravado em

Chave

  • Esta linha foi adicionada.
  • Esta linha foi removida.
  • A formatação mudou.

Index

Índice
maxLevel4
outlinetrue
exclude.*ndex
stylenone

Approved versions of SQL Server

To check the approved versions of Microsoft SQL Server, go to the Portability Matrixmatrix

Nota

As of the Liquid (1.6.5) update, it is no longer necessary to perform any database compatibility commands.

However, if you have a previous update, you must go to the Microsoft SQL Server Management Studio and define the database compatibility level for SQL Server 2012, by running the following command:

Bloco de código
languagesql
ALTER DATABASE database_name
SET COMPATIBILITY_LEVEL = 110

If you do not run the command, the platform’s startup process will be blocked.


Database creation

Fluig requires a database with Latin1_General_CI_AS encoding. To create the database with this characteristic, log in to SQL Server with the user that will be used by Fluig and run the following SQL command:

Bloco de código
languagesql
CREATE DATABASE database_name COLLATE Latin1_General_CI_AS;

Where database_name is the name of the database to be created.


Another alternative for the creation of the database is to use the Microsoft SQL Server Management Studio, following these steps:

Deck of Cards
effectDuration0.5
historyfalse
idcreate-db-studio
effectTypefade
Card
defaulttrue
id1
labelStep 1

Connect to the SQL Server instance through Microsoft SQL Server Management Studio, and then right-click the Databases folder and select the New Database...option.

Card
id2
labelStep 2

When the wizard screen opens, select the General option in Select a page. Then, enter the desired name for the database in the Database name field and select the user that will be used by Fluig in the Owner field.

Card
id3
labelStep 3

Next, select the Options option in Select a page. Then, select the Latin1_General_CI_AS value in the Grouping field.

Card
id4
labelStep 4

Finally, find the option The Confirmed Reading Snapshot is Active and change its value to True. Click the OK button to finish and create the database.


...