How to compare Migrated Transformation to 3.x Update/Transfer rules

[former_member214778]

Hi,

I am recently migrated 3.5 UR and TR to 7.3 Transformations. Now, I need to compare both versions transfer rules/Update rules to Transformations.

I know the ABAP code also will be migrated accordingly. But do we have any simple comparison mechanisam instead of comparing one by one opening in two different screens.

Thanks in advance.

Regards,

Sai

[Former Member]

Hi,

There is no simple way to do that I know, also may not be direct answer to your question.

1. Copy the code into notepad and use compare tool (for example ultra edit)

2. In window system you can open two windows side to compare ? If this is an option

3. Why to compare the code..Test the result by means of unit test and regression test with both before and after image ?

Thanks,

[former_member214778]

Hi All ,

Thanks all for your replies.

Can I migrate on 3.5 flows again, it seems there are some changes happened and moved to prod  after the initial migration happened to 7.x flows. hence, it will be difficult for me to compare each flow between 3.5 flow and 7.x flow to see if any changes have been taken place and make the new changes to 7.x flow as accordingly.

If I can migrate again then the recent changes will automatically reflects in the 7.x flow. I think we have used migrate with export in the initial migration.

Regards,

Sai

[RamanKorrapati]

Hi,

No, before doing again migration, lets check/compare your migrated objects with dev system.

if thats also huge work then go to migrate again with export option.

but carefull while migrating. Go one by one data flow migration.

Tool/Tx -  RSMIGRATE.

Thanks

[former_member214778]

Hi Raman,

What do you mean by check/compare migrated objects within Dev system. You mean to compare the 3.5 flows and see if there are any changes happened after initial migration apply them to the 7.x flow.

That will be huge task. My point is simple If I delete the transformations and DTP's created in the initial migration and migrate using RSMIGRATE for all the 3.x flows,  will it be fine?

Regards,

Sai

[RamanKorrapati]

Hi,

No.

i said compare migrated objects which are dev and prod.

But don't delete any objects which is 7.x.

Just do again migration for one data flow and see.

if its goes well then continue to do for other data flows.

Thanks

[former_member214778]

Hi,

The Initial migrated objects didnt moved to Production. They are migrated longtime ago but not moved to Production. Meanwhile, other developers made few changes to 3.5 flows and moved the changes to Production. Now, because of that gap I need to compare each 3.5 flow to 7.x flow and see if there are any changes happened, if happened I need to modify the 7.x flow accordingly. So in that process I need to look each and every mapping and code to see if there are variances.

Regards,

Sai

[RamanKorrapati]

its fine and got your point.

lets do the migration and again and move changes to prod.

After that test/check/compare your 7.x functionality with 3.x data flows.

[former_member214778]

Hi Raman,

You mean to say, I can do re-migration although there are migrated objects existed in 7.x flow in Dev.

Have you ever done re-migration? Do I need to drop the Initial migrated objects like DTP's and Transformations before I re-migrate? or not required.

Regards,

Sai

[RamanKorrapati]

Hi,

i didn't done migration as of today.

But my suggestion is don't delete existing 7.x objects.

During transport you may get problems due to version comparisons.

Lets keep them and re migrate it.

Thanks

[former_member214778]

Ok Will try and let you know..

Thanks for your inputs throughout the post.

[former_member214778]

It didn't allowed me to create a transformation..It says there is transformation already existed. I think I have to delete the transformations and DTP's and then only I can create one.

[former_member214778]

Hi All,

Do I need to collect migrated data sources into QA and then PROD along with DTP's and Transformations?

or it is not required since I don't do any changes.

Regards,

Saimukesh

[RamanKorrapati]

Hi,

Yes, you need to collect migrated data source other wise changes will won't be exist prod/qua automatically.

Rather than collecting all objects one TR, please collect each object into new Transport Request(TR) and move to qua/prod. in case of any issues its easy to handle.

Collect migrated data source into TR1 and move to Qua/prod

collect target into TR2 and move to qua/prod

Collect transformation into TR3 and move to qua/prod.

Collect infopack and dtp into TR4 and move to qua/prod.

Thanks

[former_member214778]

Hi Raman,

Thanks for the answer.

Once data source migrates to 7.x flow, the blue icon will appear or disappear? After migration using RSMIGRATE I can still see the blue icon. Is it because of migrate with export option? the blue icon still appears?

Regards,

Sai

[RamanKorrapati]

Blue dot  will disappear on 7.x data source.

[former_member214778]

Hi Raman,

Thanks. Now I have a Question for Process chains collection.

1) I have made required changes to Process chains like changing the Info packs load till PSA.

2) Also added the DTP's in the PC's.

3) Also added few AND's in the PC's where ever required.

So If I just collect process chains in one TR as 3rd TR and planning to send after Info packs and DTP/Transformations released to QA.

While collecting Process chains in QA, there are new process variants to be transported like I said above AND's etc or every thing to be considered beginning with start variant to DTP's.

I think if I collect the recent changes in Dev and transport to QA that should be enough. Am I right?

[RamanKorrapati]

Hi,

I think if I collect the recent changes in Dev and transport to QA that should be enough. Am I right?

Yes.

But make sure at qua/prod all newly created /changed settings are moved correctly.

Later you can just transport your process chain structure from RSA1, Transport connection.

Thanks

[former_member214778]

Hello Raman,

Thanks. Just for confirmation in RSA1, Transport connection -> PC -> I need to collect only the new process variants like newly added  DTP's,  changed Infopacks and new AND's proceses etc.  rest all no need to select right like roll ups and activation of DSO's since these are already existed in QA and also I didn't make any changes to capture in TR.

Thanks

[RamanKorrapati]

You can transport newly changed info pack,dtp and transformations ..etc to qua/prod.

Later you can just collect your chain only.

don't collect info pak/dtps again here. collecting process chian into TR is enough.

transport to qua and test it there. based on qua result you can your PC TR to prod.

[former_member214778]

Hi Raman,

Okay, I moved the objects in QA now. Everything is alright. One last question, when I first run the DTP (delta) it run as delta init later Delta DTP. So is it going to take every record and put into next level. In production once I move changes the initial run of DTP will load as INIT DTP where it pulls all the records and pushes again which is nothing but duplicating. The Init were already done by Info packages in 3.5 flow and deltas are feeding but why only confusion how it is going to take initial DTP runs will it take as INIT DTP and pulls every thing or just take delta records.

Any thoughts on this will be much appreciated.

[former_member214778]

anyone to help me out on this.

Appreciate for your thoughts or ideas on this

[karthik_vasudevan]

Hi Sai

Although both 3.5 flow and 7.3 flow sits in the same system, both uses different methodologies to transform the data which you are aware of.

Hence we do not have a specific method to compare both. But if you haven't got any error during migration, it shows that the migration went well and there is no issues.

In few cases, some complex routines might not be migrated properly and it will throw error during that phase. If you haven't got any error, I think the migration went well and its all good now

If you still have doubts, no need to check all the fields as you might have many. Just choose one per rule type. like choose one field which has field routine and compare. choose one field from formulae and compare.

If you have encountered any issues, please post here, we will analyse and help you to resolve it

Regards

Karthik

[RamanKorrapati]

Hi Sai,

Lets load selective 10 records to target in two methods(3/x/7.x) and see the out from target.

whether it shows same data or different one.

if its different then find the field/object which have different data and dig at transformations mappings to specific object.

Thanks

[former_member214778]

Hi Raman,

Thanks for the reply

That will be too hectic to load and see for each and every flow. I have tens of transformations.

Anyways before sending it to QA I need to random tests the data is matching or not. But as of now my aim is simple way of comparing 3.5 UR/TR to 7.X Transformations?

Regards,

Sai

[RamanKorrapati]

Hi,

i don't see any other alternate method which is very simple to compare your transformations.

You may have two methods.

1. compare each rules/mappings in 3.x/7/x

2. load data and check  in two methods.

Another work around but time consuming one.

crate  a abap program and lets compare.

in program you can read transfer rules/update rules and transformations related tables data based on target.

or Get download data form tables to Excel sheet and lets compare it.

it will be useful for only direct mapping objects.

Thanks

[RafkeMagic]

if all you have are 1-1 mappings, than random testing would be an option (still not a safe one, but at least an option)

in case you don't have all 1-1 mappings (like 95% of the BW projects out there), you may want to spend quite some time in checking each and every flow

[mohan26050908]

This message was moderated.