TOTVS Fluig English

Árvore de páginas

Versões comparadas

Versão antiga 9

changes.mady.by.user Denise De Deus

Gravado em

comparado com

Nova versão Atual

changes.mady.by.user Denise De Deus

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 Platform | Portability matrix

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

TOTVS Fluig Platform 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.


...