Microsoft Retail Management System (RMS) SQL customization

Microsoft Retail Management System serves retail single store as well as retail chains clientele.  The customization scenarios, described in this article deal with the chains, when Microsoft RMS has multiple stores databases and Headquarters.  Microsoft RMS is SQL Server-based application, so we will consider SQL programming