WFT's scripted solution provided unique functionality and enabled the customer to take advantage of some features which are not available in any data replication software currently available in the market today.
Princeton, NJ (PRWEB) August 28, 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.
About Wharfedale Technologies Inc.
Founded in 2000, Wharfedale Technologies, Inc. (WFT) is a leader in SAP infrastructure solutions. As a highly skilled SAP infrastructure consulting firm, WFT works closely with vendors, jointly delivering solutions to some of the largest clients in the financial, pharmaceutical, manufacturing and entertainment industries, as well as key government agencies. As an SAP certified provider of cloud services, Wharfedale also offers SAP solutions around - high availability, disaster recovery, advanced sizing for virtualization, back up/recovery Integration, systems refresh automation and landscape optimization.
SAP® and all SAP logos are trademarks or registered trademarks of SAP® AG in Germany and in several other countries. EMC® is a registered trademarks of EMC Corporation in the United States and other countries. All other product and service names mentioned are the trademarks of their respective companies.