🖧 Multiple MS SQL Server databases - switching between network databases
📌 Function purpose
The "Multiple MS SQL Server databases" function is intended for manufacturers who use EasyCeiling in a branching structure: branches, divisions, or work by time periods. It is available when the Network Database feature is connected and allows:
connect to different databases from one or several computers;
differentiate employee access to specific databases;
optimize productivity and order management.
🏢 Examples of use
🔹 1. For branch offices and distributed teams
Separate databases are created for each branch office.
The databases can be hosted on different servers
or on the same SQL server with different database names.
Managers
only have access to their own database.
A manager or head office
can connect to all databases from a single window.
Benefits:
Differentiation of data by branches.
Reduced server load.
Increased security and manageability.
🔹 2. For period allocation
You can create a separate database for each calendar year or quarter.
When a period ends, work continues in the new database without losing old data.
Old bases remain available for viewing and reporting.
Advantages:
The speed of work is increased due to "lightweight" databases.
Administration and archiving is simplified.
Working with a laser projector
When working in multiple databases with a laser projector, you need to set the "Print database prefix in the barcode" setting so that the program knows which database to use when scanning barcodes. Additionally, you need to check the "EasyCeiling" box on the PC where the laser program is installed.
It is important that the EasyCeiling program shows the list of databases when it starts on a PC with a projector. To do this, the default database must be the same everywhere.