Data source migration 3.5 to 7

[Former Member]

Hi ,

Need to migrate 0CO_OM_WBS_6 datasouce from 3.5 to BI7..Can you please tell me the steps..

*(Transfer rules or update rules)Which one need to change into Transformation first?

*First need to do Datasource migration or need to create transformation?

*Shall i use the same start routine in transformation or need to modify?

Please suggest me .........

Vijay

[Former Member · Accepted solution]

Hi Vijay,

If you want to maintain the mappings in the update rules and transfer rules, then first migrate update rules,followed by infosource if any and transfer rules. Finally, migrate the data source.

Edited by: Satya Sainath on May 25, 2009 11:24 AM

[Former Member]

Hello Vijay,

There are 2 approached for migration

1) Top down appraoch: here we start from top ( update rules) to bottom ( datasource) . In this approach Infosource is mandatory and all the routines will be taken care by the system no need to do anything manually.

2) bottom up approach : here we start from bottom ( datasource) to top ( update rules) . here Infosource is optional and once you migrate 3.x datasource all the transfer rules will get deleted so we need to record the transfer some where before mirgration. here we have to write maually the code invlolved in the transformation in BI 7.0 terminology.

Note: In bottom up approach it is better to use migration with export so that you can restore the datasource back to 3.x whenever any unexpected problem occurs.

Please let me know if you any other information regarding migration

Regards,

Satish.

[Former Member]

Hi Vijay,

As suggested by others

First go to the data source and right click choose the option Migrate .It will ask for a option with export or without export,Choose with export only,so that in future if there is some error you can revert back to the orginal version.

Migrating about start routine , transfer rules,Update rules

First same like data source migration the Update rules by right clicking and selecting the option migrate so it will migrate to transformation and after that Start routine some code you need to manually change by going through this link u can get where all in the start rotuine you need to change :

[http://help.sap.com/saphelp_nw70/helpdata/EN/44/bd9b5be97c112ce10000000a11466f/content.htm ]

then finally activate the tranformation .

Hope it helps .

Thanks

$@ndhya

[Former Member]

Hi Vijay,

First migrate your updaterules by creating an infosource and then transfer rules. At the end migrate the datssource 'with export' option.

While migrating the rules; the routines are to be changed accordingly to the new version.I mean the logic would be the same but only change is in the syntax.

Regards,

Geetha

[former_member205352]

First migrate update rules.

This should ask you for generating infosource.Create a new one.

Now migrate Transfer rule.

Next migrate datasource (choose "with export" option prefarably).

All your start routine and field level routines will be migrated too.You need not rewrite it.

Hope this helps.

Edited by: Praveen G on May 25, 2009 5:50 AM

[Former Member]

hello,

You can look into help SAP on the same:

http://help.sap.com/saphelp_nw70/helpdata/EN/43/682cacb88f297ee10000000a422035/frameset.htm

Regards,

Dhanya

[Former Member]

You need to migrate the underlying objects first(say Infosource and Datasource for the case of transfer rules) then the migration of the tranfer/update rules comes.

When u migrate the rule, start routine is also migrated. So no further change needs to be done.

R$

[Former Member]

Hi Vijay,

First you need to do Datasource migration that. Go to the Datasource for which you need to migrate--Right click & then choose Migration option--A pop up message will ask you to either migrate with export option (or) without export.

Always choose with export option as only this option will allow us to recover back all the dependent objects viz ISMS, ISMP, ISTS back to 3.5 Version in case 3.5 to BI 7.0 Migration fails.

If at anytime if migration is creating a problem, then you can always restore the Dataosurce to original version by using RSDS T code----> restore button by giving the Datasource name.

Hope this helps in large extent.

Regards,

Venkat

[Former Member]

Hi,

In Transfer rules and update rules both have start routines.As per my knowledge in theis situation first needs to create transformations then need to migrate Datasource.Please suggest me .

[Former Member]

Hi Vijay,

Yes you can proceed with first start migrating the ISTS & UPDR to Transformation. But before doing this pls make sure that all the syntax are correct and that routines are active.

And then you can start migrating the Datasource.

Regards

Venkat