when I said that many made such migrations, I meant many customers. I am not a customer, I am working in Oracle Support. We can help you if you have dedicated problems. Questions about experiences can only be answered by other customers, but if no other customer replies in this forum, I can only suggest that you use SQL Developer to do the migration, and if you encounter a problem that you can't solve yourself then you can log a Service Request with Oracle Support.
If you are migrating to Oracle RDBMS I suspect you have a license to use Oracle RDBMS. And normally our customers also sign a support contract if they buy the license, otherwise it makes not much sense. Oracle is not for free. But SQL Developer is free. And if you have a support contract for Oracle RDBMS, this includes support for SQL Developer.
If you don't have the possibility to log a Service Request, you can always discuss your questions in this forum. But there is no guarantee that we can always help, and the priority to answer questions in this forum is much lower than working on Service Requests.
But to come back to your remark "i am stuck at the moment". Your questions up to now were only extremely general. I have no idea what you have tried so far, whether you tried already a migration using SQL Developer and read the documentation how to do that. But if you can tell me what you did so far and where you stuck then I might be able to help you. Precise questions can be answered precisely. General questions can only result in suggestions to read something.
ok what i am currently doing is i have like 30 procedures for an application tio run in SYABSE.
I am taking one procedure at a time from sybase anc converting it to pl/sql using translation scratch editor.
Is this the correct way?
I really don't understand what you mean. The SQL Developer Migration Workbench is a tool that automates the migration.
I assume you have:
- installed SQL Developer
- made a connection in SQL Developer to your Oracle database
- made a connection in SQL Developer to your Sybase database
- created a migration repository in your Oracle database
- read the SQL Developer documentation
Then you are able to click on Tools - Migration - Migrate, and that will open the Migration Wizard which will lead you through the migration.
It is always advisable, if you use this tool the first time, to start with a little test database that you can migrate online. Then using the Migration Wizard for such an online migration is just a few mouse clicks, and finally all your objects and data will be migrated to an Oracle schema. Automatically.
The issue is a little bit more time consuming if your Sybase database is big, then an offline migration is much better and faster. But also an offline migration is automated and you don't have to migrate each object manually. You just need to read carefully the documentation to understand the difference between online and offline migration. Click on Help - Table of Contents, and then the chapter about Migrating Third-Party Databases.
This is a philosophical question. The person who can answer that at best are yourself. We always learn for life and don't know whether we need the learned things again or not. That starts in school and ends at the end of life.
SQL Developer can be used for migration from SQL Server, Sybase etc, to Oracle.
SQL Developer is a GUI tool to connect to an Oracle and some non Oracle DB. It can be used for issuing Ad-hoc SQL command and to manage PL/SQL objects. It is written in Java and needs JRE.
SQL Developer does not need to be installed by OUI. It is not installed in an Oracle Home but self-contained. To install it just download it from Oracle Corporation web site and unzip it. That’s it. Now you can launch it by running sqldeveloper.exe in Windows.
To run in UNIX set the DISPLAY=127.0.0.1:0.0 (or whatever your ip address) and then run sqldeveloper.sh
From my experience It is very beneficial to have migration experience from non oracle to oracle DB.
Hi i gt connected to my sybase database through sql developer and named it as Sybase_DB.
Now i created a schema Oracle_Db to store alll the objects of Sybase_DB.
What should be my next step ?
I ma not able to proceed.I want to do online migration.
What privileges are needed for Oracle_Db user.
I was able to create a captured and converted model but both had the sybase code :(