🖧 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.
Video
What questions does this article answer?
What is the Multiple MS SQL Server databases feature in EasyCeiling?
How to work with multiple databases in a branching structure?
How to manage access to different databases?
What are the benefits of using multiple databases?
How to optimize database performance with multiple databases?
How to handle branch office data separation?
How to manage period-based database allocation?
What are the best practices for database organization?
How to ensure data security with multiple databases?
How to improve server performance with database separation?
How to manage distributed teams with multiple databases?
What are the advantages of period-based database allocation?
How to handle database archiving and maintenance?
How to troubleshoot multiple database issues?