Migrating the Database of ReportNet MR3 from Oracle to SQL Server 2005

[satheesh_gouda]

Hi,

Did anybody migrated the database of ReportNet from Oracle to SQL Server 2005? We have migrated the database from Oracle to SQL Server 2005(both the databases have same structure) and validated the FM and ran one report but the SQL Server's query resulted multiple loops. How to avoid these loops? Do we need to create any aliases at FM Level? Thanks for your help.

[COGNOiSe administrator]

That depends on your DM design. SQL optimization engine is quite different from ORACLE, so what worked for ORACLE, might not neccessarily work for SQL. I'd recomend you take it case by case, while taking advatage of some of the cool features SQL 2005 has to offer.