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)
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
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.