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)
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Email to a Friend
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Email to a Friend
- Report Inappropriate Content
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?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Email to a Friend
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Email to a Friend
- Report Inappropriate Content