How to move entire cognos FM model and reports from sql server to oracle

[cgb]

I have a model in FM with sql server as source with around 80-90 query subjects. Now We want same model but only in oracle. Views are created in oracle.  If structure (naming conventions) of views and columns are not same in  sql server and oracle then how can we achieve this.

Do we need to recreate entire model from scratch  right from importing data from oracle views, creating business and presentation layer  or

Is there any way to use existing model by mapping to save time and efforts.

[bus_pass_man]

Well might you use the term mapping for there is a remapping tool in FM.

https://www.ibm.com/support/knowledgecenter/SSEP7J_10.2.2/com.ibm.swg.ba.cognos.ug_fm.10.2.2.doc/t_remap_an_object_to_a_new_source.html

http://www.cognoise.com/index.php?topic=28359.0

http://www.cognoise.com/index.php/topic,31048.msg101299.html

http://www.cognoise.com/index.php/topic,29271.msg94664.html

http://www.cognoise.com/index.php/topic,29738.msg96731.html

https://www.safaribooksonline.com/library/view/ibm-cognos-10/9781849685764/ch08s02.html