Database Requirements

# Database Requirements

To work with LogicPos we need a data store, currently we can use MySql Server, Miscrosoft SqlServer or Sqlite, bu technically we can use any data source comopatible with eXpressPersistent Objects™ (XPO)

Note

To work with MySql Server or Miscrosoft SqlServer we need first to install server To Work With Sqlite we dont need to install anything Tip

Recommended data sources: Mysql and SqlServer Configure LogicPos Database Connection After we choose a data store we need to configure it in application config

Open and edit config logicpos\bin\Debug\logicpos.exe.config

Configure Database

# Option #1 : Mysql

To work with MySql we need to edit xpoConnectionString to connect to local or remote MySql Server Instance

local

Note

For remote server change localhost with remote ip, for ex 192.168.1.1 Dont forget to change user id, password according your needs.

## Option #2 : SqlServer To work with SqlServer we need to edit xpoConnectionString to point to our SqlServer Server Instance

local

Note

Dont forget to change user id, password according your needs.

## Option #3 : SqlServer Express To work with SqlServer Express we need to edit xpoConnectionString to point to our SqlServer Express Instance, the connection string is a little diferent

## Option #4 : Sqlite