How to move a Netweaver 7.3 WAS Java SQL Server DB to a new SQL Server instance.

[Former Member]

I currently have a Netweaver 7.3 Java installation with the SQL Server instance on the same server. An appropriate SQL Server 2008 R2 cluster has become available and for the added security of the data I would like to move the database to the cluster whilst leaving the NW 7.3 Java instance on its existing server. I cannot find satisfactory documentation to support this move and would appreciate if anyone can to add to what I've found so far.

My intention is to: a) shutdown the Java instance b) detach the SQL db from the local SQL instance c) move the data files to the SQL cluster d) attach the SQL db to the SQL cluster instance e) modify the Java instance profile parameters in DEFAULT.PFL i.e. j2ee/dbhost and dbs/mss/server to the SQL cluster's virtual hostname f) restart the Java instance.

I don't know if anything else is required . For example is there anything that needs adjusting in the Java instance configuration.

If anyone has successfully done this then I would be pleased to hear how you achieved it.

[premsukh_bishnoi]

In case of Java system, Detach and ataach menthod would be successfull in case where your database(in your case) hostname is same on target and source system. Since you are going to change the hostname so it is not a recommended way to do.

There is lot of places where database host name are being used at file system level. By the doing troubleshooting you may be able to do movement but during upgrade, definately you will face lot issues.Please follow standrad way of system copy procedure export-import from SAPINST.

Regards, Premsukh

[HuseyinBilgen]

Why don't you follow standart SYstem Copy procedure with DB Specific Method?

[Former Member]

Hi Huseyin,

doesn't that miss the point? I only want to move the SQL database. I want the NW 7.3 Java instance to remain where it is but referencing the database in its new location. As I understand it, the documented System Copy would allow me to move both database and instance to new locations. To achieve my objective I simply need to change all the pointers to the database to it's new hostname. I'm just looking for confirmation that I've found all of them or for someone to point out to me the ones that I haven't discovered.

Keith

[HuseyinBilgen]

There are numeros places where the DB is pointed. So, I asked you to just follow standart SYstem Copy procedure for AS Java, where you can locate the DB on the new location and install the CI on the existing server by letting the SAPINST do the all necessary settings.