Upgrade SAPDB 7.3.0.20 to MaxDB 7.7 (latest version)

[Former Member]

Hi DB Experts,

Please help on following MaxDB Upgrade requirement

Source

SAPDB 7.3.0.20

Windows 2000

32 Bit

Target

MaxDB 7.7

Windows 2003

64 Bit

Question :

How we should proceed with database upgrade

At what point/phase we need to migrate database from 32 bit (Win2000) to 64 bit (Win 2003)

Info available:

I understand first I need to upgrade to minimum SAPDB version 7.3.0.25, which is base for upgrade to next version.

I am not sure about 32 bit to 64 bit conversion.

Please suggest how to proceed.

Thanks & Regards,

Mayur Dahiya

[lbreddemann]

>

> Hi DB Experts,

>

> Please help on following MaxDB Upgrade requirement

>

> Source

> SAPDB 7.3.0.20

> Windows 2000

> 32 Bit

>

> Target

> MaxDB 7.7

> Windows 2003

> 64 Bit

>

> Question :

> How we should proceed with database upgrade

> At what point/phase we need to migrate database from 32 bit (Win2000) to 64 bit (Win 2003)

I'd propose:

Perform the upgrade to 7.7 on the source system.

Afterwards perform the system copy to the 64 Bit system (it's just backup + restore).

For the upgrade - don't just upgrade to 7.3 Build 25 or something like that.

Use the latest (build 62 I think) build and make sure that everything works afterwards.

(you really shouldn't have used build 20 all that time...)

regards,

Lars

[Former Member]

Dear Lars,

Thank you very much for your detailed answer.

I need some more clarification, please help.

1 ) Regarding reply "Afterwards perform the system copy to the 64 Bit system (it's just backup + restore)"

Please confirm

a) I need to install latest DB software on target (win 2003). Same version (with patch) which i have upgraded

on source (win 2000). Ensuring DB version on both source (upgraded) and target (installed) are same.

b) perform DB backup of source DB (win 2000), and restore the same on target (win 2003). Apply logs if any

upto last moment.

c) Perform load system table as last step and DB is ready for normal operation.

OR

a) copy MaxDB software files from source (win 2000) to target (win2003)

b) and perform DB backp (on source) and restore (on target)

c) Perform load system table as last step and DB is ready for normal operation.

2) As windows 2000 and windows 2003 are different version of operating systems, with backup + restore will work or we need to perform migration (export on source and import on target).

Waiting for your reply.

thanks once again for all your help.

Thanks & regards,

Mayur Dahiya

[lbreddemann]

>

> Dear Lars,

>

> Thank you very much for your detailed answer.

>

> I need some more clarification, please help.

>

> 1 ) Regarding reply "Afterwards perform the system copy to the 64 Bit system (it's just backup + restore)"

> Please confirm

> a) I need to install latest DB software on target (win 2003). Same version (with patch) which i have upgraded

> on source (win 2000). Ensuring DB version on both source (upgraded) and target (installed) are same.

Yes!!

> b) perform DB backup of source DB (win 2000), and restore the same on target (win 2003). Apply logs if any

> upto last moment.

Just take a complete new backup (e.g. in ADMIN mode) and restore this on the target system.

No logs will be required then.

> c) Perform load system table as last step and DB is ready for normal operation.

Right!

> OR

>

> a) copy MaxDB software files from source (win 2000) to target (win2003)

-> you NEVER do that.

All that this does is messing the installation up!

Use SDBSETUP/SDBINST to install the software. Nothing else.

> b) and perform DB backp (on source) and restore (on target)

Yes.(same as above)

> c) Perform load system table as last step and DB is ready for normal operation.

Yes, again. (same as above)

> 2) As windows 2000 and windows 2003 are different version of operating systems, with backup + restore will work or we need to perform migration (export on source and import on target).

The OS version does not matter.

Not even the OS itself.

What matters is the byte-order and the database software version.

So you may perfectly backup and restore a Win/32 database to a Linux/X64 instance.

Ok, I guess with that you should be able to perform a test migration.

regards,

Lars