on 01-24-2015 12:30 PM
I have migrated several BW7x based on DB2 to NW7.4 based on Hana using DMO.
Now I see that migrated Hana DBs have the same schema name , e.g. SAPBIW.
Is there any way to change Hana DB schema name to another string , e.g. SAPHBW?
Thanks!
Hi Jenna,
As far as I know, we cannot rename the schema name in SAP HANA. Thus there is no RENAME SCHEMA statement from Data Definition Statements - SAP HANA SQL and System Views Reference - SAP Library
Best regards,
Wenjun
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Jenna,
just FYI, we can change the source schema name via DMO and need to be done on the early stage.
Just add below entry to SAPup.add.par
/migrate/targetschemasid = SID
Eventually, SAPSID will be created in your target HDB. You can refer to the DMO guide for more info.
Hope it is useful for your next DMO project.
Cheers,
Nicholas Chang
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
HI Jenna,
you can rename SID by SWPM tool , I have done that.
But we should also try below solution also for Schema Renaming.
Lets have a try on these.
Firstly take a full backup for the System. Also involve some BASIS guys here too as we need Some environment variable and profile Setting.
Use the sql “EXPORT "SAPBIW"."*" AS CSV INTO '/Backup_<SID>/SCHEMA_EXPORT_BACKUP' with THREADS 100;”
You can also export the the SAPBIW Catalog via studio and keep this is in some file System.
Then please create the empty schema : SAPHBW
Later try importing this with the SQL or studio
“IMPORT "SAPBIW"."*" AS CSV from '/Backup_<SID>/SCHEMA_EXPORT_BACKUP/' with RENAME SCHEMA "SAPBIW" to "SAPHBW" IGNORE EXISTING THREADS 100
I said to involve basis guys as you again need to make central instance connectivity from database . So BASIS Guys , would be knowing where to change all the profile path so that you can make your Central instance up .
if you have still question , please raise.
Regards,Dipak
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I am very sorry that I used the wrong terminology.
Actually what I want to rename is the "OWNER" field at system->status->database.
May I use hdblcm or hdbalm or sapinst/SWPM to change that from SAPBIW to SAPHBW.
I did some research but did not see any method.
In SP9, seems hdblcm can rename SID but not the DB "OWNER". I am between projects so I cannot verify.
Thanks!
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.