Lawrenceville, NJ (PressExposure) August 30, 2013 -- Wharfedale Technologies, Inc. today announced successful deployment of SAP System Refresh solution for a giant Biotechnology firm. The customer's system refresh requirements were studied by SMEs (Subject-Matter Experts) at Wharfedale Technologies and a scripted solution was designed to address all of the limitations of a data replication software that the customer acquired. In addition to this, WFT also provided flexibility and extra features that made the solution very powerful.
The data replication software was offered as a solution by a vendor, for SAP System Refresh in a large-scale Windows Server 2008 R2/SQL Server 2008 R2 environment. It was soon discovered that this product was not a good fit for a couple of reasons. The first reason was that, it has a few limitations in Microsoft Failover Cluster environments. Additionally, there were some manual steps that needed to be performed for every new System Refresh scenario. Another reason behind not using the software product was that, the customer had to refresh SQL Databases running on the same 2-node cluster (between nodes or within the same node), which was NOT a supported feature of the product. Finally, the customer required database logical and physical file names to be renamed after refresh, which was also not supported.
WFT studied the customer's System Refresh requirements and designed a scripted solution to address all of the limitations. This was done in addition to providing flexibility and extra features, which made the solution very powerful. The script was written in Microsoft PowerShell using SMO (SQL Management Objects) to deal with DB operations. This solution does not require any configuration file(s), it automatically queries the source and target on the fly and performs the complete SAP system refresh. The script also takes full advantage of Windows PowerShell Remoting transport and is written in such a way that it can be executed on any server in the SAP Landscape. Further, the script developed by Wharfedale, is written as several modules and is capable of working with any leading storage array in the market. The script can be executed using a scheduler to run in unattended mode or can be completely interactive if required and provides a detailed log for each execution and manages the log location automatically.
The scripted solution provided by WFT proved to be a reliable and a flexible solution to perform SAP system refresh in a Microsoft Windows Server 2008/SQL Server 2008 failover cluster environment.