Page Comparison

Prerequisites

1. The users' role must have access to the Web Database feature by enabling Add app operation for the feature in Admin - Security - User - Role

1.  through Desktop POS Manager- Utilities - Configure.
2. Microsoft SQL Server must be installed. 
3. SQL Server Management Studio (SSMS) must be installed.

Step-by-step guide

The following steps are to be executed:

1. Go to 

1. POS Manager - Utilities - Configure - Web Database.
   

2. Web Database Migration module opens.

3. Click on Add button.

4. The Web Database Migration Detail window will open.
   Image Added
5. Effective Date: Select the Effective Date from the provided calendar. Effective Date must be grater than the System Date.
6. 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.
7. Port: It is the IP or Web Address as provided by the company hosting web services for the user.
8. 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.
9. 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.
10. Click on the Create Database with Object.
11. The new database connection will be established and one new database will be created the specified database name.
12. After creating the database connection, you can test the connection by clicking on the Test Connection button.