Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

OS-DB migration procedure

Dear all,

We are having our PRD system on ECC5.0 HP-UX /oracle 9i platform... as part migration project we need to migrate our Test server from HP-UX / Oracle environment to

Windows 2003 / MSSQL 2005 environment.

I am not aware of the options for OS-DB migration .. could anybody let me know where can i find procedure for the same ... and also do i require Staging machine along with source and Target machine. Appreciate your help.

Regards,

RR

Former Member
replied

> Could you suggess any specific note which talks about settings i need to make in order to avoid performance problems on target MSSQL platform once migrated from Oracle.

Performance tuning is of course difficult to generalize. If you have e. g. created secondary indexes for Oracle, they may slow down the system on SQL server. However, this is something that need to be looked after once the system is migrated.

To speed up import (significantly) check 1156361 - R3load: Fastload doesn't support LOB-columns

I would copy the production system, migrate it and then ask some key users to do their normal daily tasks and tell you if they see any differences.

After the migration I would

- run SGEN to generate all loads

- run "dbcc checkdb"

- do an update statistics

For further parameterization you can check the following notes:

1054852 - Recommendations for migrations to MS SQL Server

799058 - Setting Up Microsoft SQL Server 2005

Markus

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question