skip to main content

SAP NetWeaver Newbie

SAP Tools for SQL Server Administration


Tweaking the SAP installation tool SAPinst, SAP has provided as set of tools that can be used to perform the following tasks on MS SQL Server:

  • Perform a system copy (for SAP kernel <= 640)
  • Convert to a schema-based configuration from dbo-based one
  • Upgrade SQL Server 2000 to SQL Server 2005 or higher

You can download the SAP Tools for MS SQL Server (STM) from http://service.sap.com/msplatforms --> SQL Server.

Apply security patch from SAP note 1375494 before using the tool and change any DB specific profile parameters. Example: Change dbs/mss/server=$(SAPDBHOST) to dbs/mss/server=<db hostname>

Usage of the tool for above mentioned tasks is pretty straightforward. Once you have downloaded and extracted the tool, go to <Path to STM tool folder>STM\<Your Platform> and call sapinst.exe. The dialogue screens will guide you from there.

No comments:

Post a Comment

Email Subscription

Get every new post into your inbox by subscribing us.

Want a reason to subscribe?
1. This sitemap might convince you to subscribe.
2. We do not misuse email IDs. We respect privacy.

© 2008 - 2017 sapnwnewbie. All rights reserved.