Do I need multiple WMS databases for my multiple sites?

Posted on Aug 27, 2010

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 in the remote site will be unable to access the warehouse data
All of these above aretrue to for old legacy systems where functionality has been bolted on. For systems that are written in recent languages and reside on 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 andВ  resiliency 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.
To learn more about warehouse database software for your single and multiple sites, please call 0800 011 3218 or Instant Chat us now.

Related posts:

  1. What is cost of support for inventory management software?
No comments
Problems • Software • Warehouse management system