Issues while Migrating the SQL Server tables to Sybase IQ

[#1]

Hello Friends,

Kind Help!!!

We have a below scenario:

Current Scenario:

ECC-->Data Services-->SQL Server Database-->Universe-->Webi Reports

Now due to poor performance of the BOBJ reports, Our client replaced the SQL Server with the Sybase IQ. So We need to know what are the steps that we need to be taken care of in this scinario.

As per new Scenario: Client has decided to replace the SQL Server database to Sybase IQ for better performance.

ECC-->Data Services-->Sybase IQ-->Universe-->Webi Reports

How it affects the current webi reports after the migratin of the SQL Server tables to Sybase IQ. Please let us know the steps to follow so that all the existing webi reports should work normally.

Thanks in advance friends.

Regards,

Bhaskar Reddy,

09699233676

[Former Member]

There is no automation available for this kind of database migration.

After the migration is done you will have to create a new universe on top of IQ and replicate all the objects or features of the SQL server universe with the Sybase IQ functions and SQL.

Once the new universe is ready you would need go to each webi report and add a new query and replace and map all the report objects from the old universe to the new one..

[Former Member]

Hi Mishra,

Thanks for your reply.

If this is the case, then this is like re developing from the scratch. I think there should be a way to tackle this so that we can't re build the universes and change all the webi universes.

Regards,

Bhaskar