MTK can't find schema in Sybase to EPAS migration

[omandee]

Hi everybody, 

I'm trying to test a Sybase to EPAS migration. I have a Sybase ASE 15.7 running on Docker and an EPAS 12 installation on Centos 7. I set up my properties.toolkit file and started migration with /usr/edb/migrationtoolkit/bin/runMTK.sh -sourcedbtype sybase -targetdbtype enterprisedb parca command. When I send it, I see that both database connection has been set but MTK couldn't find the targeted schema though it is there. Error I got is below. What could be wrong? 

Connecting with source Sybase database server...
Connected to ASE, version '15.70'
Connecting with target EDB Postgres database server...
Connected to EnterpriseDB, version '12.1.2'
Importing sybase schema parca...
MTK-10050: The schema parca not found on source database.

One or more schema objects could not be imported during the migration process. Please review the migration output for more details.

[MuhammadIkram]

Please use same case for the schema/username as it is in Sybase. e.g. Parca , parca, PARCA all are different for migrationtoolkit. If in Sybase it is Parca (initcap)  then parca won't work. In this case

/usr/edb/migrationtoolkit/bin/runMTK.sh -sourcedbtype sybase -targetdbtype enterprisedb Parca

should work

[slonkar]

Hi @omandee,

Could you please try with the username at the end of the command as below :

/usr/edb/migrationtoolkit/bin/runMTK.sh -sourcedbtype sybase -targetdbtype enterprisedb <user name>

Please make sure the username provided at the end of the command has privileges to do the migration.

Regards,

Sudhir

[omandee]

Hi @slonkar, 

Thanks for the reply, but it is not working too :(

I think that the problem is how epas, oracle and sybase consider a schema. 

My sybase is running on docker. I am using the container over here https://hub.docker.com/r/ifnazar/sybase_15_7

and tested that I could reach it. I created a new database and tables under it. 

When I set up my MTK toolkit.properties file as in an Oracle migration, it just doesn't work.

It says that the schema doesn't exist but I have a database, I have a superuser that could do anything on it.

I don't understand what could be wrong? 

[chaitalirs]

Hi omandee ,

Can you try this once again with schema name in the upper case?

[omandee]

Hi chaitalirs,

I tried all caps, but the error didn't change.

Log says "MTK-10050: The schema PARCA not found on source database." but I got the schema.