Sybase Refresh

[Former Member]

New to sybase so need clarification. We are refreshing a Netweaver 7.4 SPS5 system that is on Sybase 15.7. Per the SWPM system copy guide,

1) We need to create mainfest file on source system(Production system in our case)

2) Dump database to file system or whichever backup process is in place

3) Copy files from step 1 and 2 to target

4) Start SWPM, choose homogenous system copy

5) Select to use existing database installation

6) Give manifest file location along with database dump file when asked

Questions

1) Wouldn't copying manifest file warrant similar directory structures, passwords etc....on target system. What if directory structures between source and target are different. How can we address the difference. Do we edit manifest file to our directory structures on target system.

2) Should we only take DB backup or any other databases(master, systemtools etc....) are also needed

3) Sybase doesn't seem to work around DB SID. When i issue load command on target, should i be using source SID or target SID.  If its source SID, would SWPM be changing the SID and Schema because they seem to be hardcoded in SAP profiles for ODBC/JDBC connections. Please advise

Regards

Kalyan

[Johan_sapbasis · Accepted solution]

Hi Kalyana,

Apologies for the late reply have not been here lately birth of my daughter kept me away for a while. Please refer to my response on thread

You create the manifest file on your source system, your directory structure on the target system will look the same and name changes would be done by SWMP during the import phase.

In the below explanation I am saying your source system is SID and target SID=EXP

Two situations can happen:

(1) the device files are in the expected location (D:\sybase\EXP).

Then SWPM will rename SID_data_ <n>.dat to EXP_data_<n>.dat.

(2) the device names do not exist; SWPM will display a dialog where

you will be requested to fill in the effective path names on the

target host. The user-entered files will be used to mount the database

into the existing system then.

The recommended approach would be to have the device files from SID in

D:\sybase\EXP\sapdata_ <k> and D:\sybase\EXP\saplog_<k> so that the

file system layout matches the SWPM set standard.

So my understanding is the directory structures have to match, but my recommendation would be to actually just used the Backup/Restore method rather than the Detach/Attach method it is much simpler.

Kind Regards,

Johan

ps: hope this helps a little

[Former Member · Accepted solution]

Thank you Johan for taking time out to reply. This makes it easy

Congratulations on your Daughter