Web Database configuration is required to to have an automatic synchronization with the web database scheduled. This article describes how to configure and manage Web Database in Ginesys HO. Pre-requisites- The users' role must have access to the Web Database feature by enabling Add app operation for the feature in Admin - Security - User - Role through Retail Management - Utilities - Configure.
- Microsoft SQL Server must be installed.
- SQL Server Management Studio (SSMS) must be installed.
Step-by-step guideThe following steps are to be executed: Go to Retail Management - Utilities - Configure - Web Database.
Web Database Migration module opens. Click on Add button. - The Web Database Migration Detail window will open.
- Effective Date: Select the Effective Date from the provided calendar. Effective Date must be grater than the System Date.
- Host: In general terms, the 'host' term is usually attached to a powerful device or program that delivers services to some smaller and less capable device(s) or program(s). In this case, it is the system where the web database will be created or the web database already exists.
- Port: It is the IP or Web Address as provided by the company hosting web services for the user.
- User Name & Password: These are the credentials created by the user in time of installing SQL database and using which the system can log into the web location.
- Database: Provide here the name of the database to which it will be linking or the name of the database which you want to create.
- Click on the Create Database with Object.
- The new database connection will be established and one new database will be created the specified database name.
- After creating the database connection, you can test the connection by clicking on the Test Connection button.
| 