OS-DB migration procedure
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.
Markus Doehr 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