Can a single warehouse database software cover multiple sites and locations?
Quick answer: Yes.
Top 3 negatives that you may hear about a single warehouse database software for your warehouse management system
>> Single point of failure, so if that server breaks, nobody can use the application
>> Speed to access from remote locations, meaning that as more and more people try and access the warehouse database software to see the warehouse and inventory data, the application may slow down in response time which can frustrate users
>> If the connection from a remote site goes down, due to the Internet failing for example at the remote location, then the people at the remote site will be unable to access the warehouse data
All of the above are true, too, for old legacy systems where functionality has been bolted on. For systems that are written in recent languages and reside in warehouse database software such as Microsoft SQL Server 2005 and 2008, the speed is very fast and the backup functionality is simple to ensure you have a data backup andresiliency in case of something going belly up.
Top 3 positives of single warehouse database software for your wms:
>> Easier, quicker and less investment required to set up
>> Replication issues between different databases eliminated. In other words, if the warehouse management system was not built to deal with these multi-site installations where perfect data replication is required, then you will have issues. This is not a concern with a single instance of warehouse database software.
>> Less cost than supporting multiple servers, especially when something goes wrong as there is only 1 place to look...so you are likely to locate the issue!
Conclusion is that one single database is best on modern systems with backup and resiliency in case of failure on the main server. Easier to install, support and upgrade.