Repository Migration form 11.7 to 4.0 with Sybase to Oracle

dataservices job design
1

We are in process to migrate repository on DI 11.7 to DS 4.0 with Database migration from Sybase to Oracle.

Current Environment:
DI 11.7.3.0
Database: Sybase IQ 12.6
Server: HP-UX

To be Environment:
DS 4.0
Database: Oracle 10g
Server: AIX

We have followed following steps:

  1. Created ATL file from existing repository
  2. Imported ATL file in BODS 4.0
  3. Upgraded the repository to DS 4.0
  4. The schema and Table structure was created in Oracle as in Sybase
  5. Created new configuration for the datastores with Oracle DB connection info.
  6. Changed new configuration to LIVE configuration.

The new configuration was created assuming the same Datastores and Tables would be accessible in New repository as well,

However, when we are executing the job we are getting error:" Table does not exist".
When tried reimporting the table by clinking right click and import, again the table does not exist error is coming. However, when the table is imported using Import by name option, its successful.

Also, when we compare objects, the only difference is that for new object; database_object_type is table, however, for existing object it is NULL.

Are we missing any step? Won’t changing configuration work for Database migration?

Any help is highly appreciated.

Regards,
Deepti

deepti_passi (BOB member since 2006-09-11)

2

It isn’t clear to me what your system landscape is. In the old environment does the Sybase IQ database host both the repository and the source/target databases?

I would use DS 4.1 not DS 4.0.

At one point a while back I thought I read that you had to perform an interim upgrade to 12.x when going from 11.x to 14.x.

Here is what I would do:

  1. Use DI 11.7 Designer to export the repository to an ATL file.
  2. Create a new (empty) schema in Oracle.
  3. Use DI 11.7 Repository Manager to create a 11.7 repository.
  4. Import the ATL file to the new repository using DI 11.7 Designer.
  5. Use DS 14.x Repository Manager to upgrade the repository from 11.7 to 14.x. This is the step I’m not sure of. It’s worth trying, but in this step you may have to upgrade the repository using 12.x first and then 14.x.

eganjp :us: (BOB member since 2007-09-12)