MTK can't find schema in Sybase to EPAS migration

MTK can't find schema in Sybase to EPAS migration

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.

Accepted Solutions (0)

Answers (3)

Answers (3)

EDB Team Member

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

 

EDB Team Member

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

EDB Team Member

Hi omandee ,

 

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

 

Archived Discussions


Effective March 31st, we will no longer engage on PostgresRocks.


How to engage with us further?


  • Thought Leadership: EDB Blogs

  • Tips and Tricks: Postgres Tutorials

  • Customer Support: Create a Case Please note: Only customers with an active EDB support subscription and support portal authorization can create support ticket

  • Engage on Stackoverflow While engaging on Stackoverflow tag the question with EDB or EnterpriseDB.

© 2019 EnterpriseDB Corporation. All rights reserved.   |   Privacy Policy   |  Terms of Use   |   Trademarks