Answer: Express Technology Inc. software is designed for the Microsoft SQL ServerDatabase Engine. It will work with all versions of MS SQL Server.
All Maintenance Management Software is data intensive. It involves constant storing and retrieving of data which is likely to include documents and photos. For this reason the application must be built upon a powerful and completely reliable database engine.
ExpressMaintenance was built from day one to take full advantage of the Microsoft SQL Server database engine. SQL Server is a powerful tool for turning information into opportunity. Business today demands a different kind of database solution. Performance, scalability, and reliability are essential, and SQL Server provides it all.
At Express Technology, we’ve been developing applications for SQL Server for years. Most competitive maintenance management software is based on low performance database platforms that simply do not hold up with large volumes of data or multi-user environments. With SQL Server, your get rapid data retrieval and reported regardless how large your data becomes. And you’ll never experience data or index corruption.
The following information is provided by Microsoft. Microsoft® SQL Server™ is designed to be a client/server system. Client/server systems are constructed so that the database can reside on a central computer, known as a server, and be shared among several users. When users want to access the data in SQL Server, they run an application on their local computer, known as a client, that connects over a network to the server running SQL Server.
Having data stored and managed in a central location offers several advantages:
SELECT first_name, last_name
WHERE emp_title = 'Sales Representative' AND emp_state = 'OR'
The relational database only sends back the names of the salesmen in Oregon, not all of the information about all employees.
The server can be configured to optimize the disk I/O capacities needed to retrieve data, and clients can be configured to optimize the formatting and display of data retrieved from the server.
The server can be stored in a relatively secure location and equipped with devices such as an Uninterruptible Power Supply (UPS) more economically than fully protecting each client.
In large client/server systems, thousands of users may be connected to a SQL Server at the same time. SQL Server has full protection for these environments, with safeguards that prevent problems such as having multiple users trying to update the same piece of data at the same time. SQL Server also effectively allocates the available resources, such as memory, network bandwidth, and disk I/O, among the multiple users.
While SQL Server works very effectively as a server, it can also be used in applications that need a stand-alone database stored locally on the client. SQL Server can dynamically configure itself to run efficiently with the resources available on a client without the need to dedicate a database administrator to each client.
SQL Server applications can run on the same computer as SQL Server. The application connects to SQL Server using Windows Inter-process Communications components (IPC), such as shared memory, instead of a network. This lets SQL Server be used on small systems where an application needs to store its data locally.