- 3,722,876 Users
- 2,244,428 Discussions
- 7,850,123 Comments
Forum Stats
Discussions
Categories
- 16 Data
- 362.2K Big Data Appliance
- 7 Data Science
- 2K Databases
- 599 General Database Discussions
- 3.7K Java and JavaScript in the Database
- 32 Multilingual Engine
- 496 MySQL Community Space
- 7 NoSQL Database
- 7.7K Oracle Database Express Edition (XE)
- 2.8K ORDS, SODA & JSON in the Database
- 421 SQLcl
- 59 SQL Developer Data Modeler
- 185K SQL & PL/SQL
- 21.1K SQL Developer
- 2.4K Development
- 3 Developer Projects
- 32 Programming Languages
- 135.6K Development Tools
- 12 DevOps
- 3K QA/Testing
- 327 Java
- 10 Java Learning Subscription
- 12 Database Connectivity
- 71 Java Community Process
- 2 Java 25
- 11 Java APIs
- 141.2K Java Development Tools
- 8 Java EE (Java Enterprise Edition)
- 153K Java Essentials
- 135 Java 8 Questions
- 86.2K Java Programming
- 270 Java Lambda MOOC
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 14 Java SE
- 13.8K Java Security
- 4 Java User Groups
- 22 JavaScript - Nashorn
- 18 Programs
- 147 LiveLabs
- 34 Workshops
- 9 Software
- 3 Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 4 Deutsche Oracle Community
- 16 Español
- 1.9K Japanese
- 3 Portuguese
Migrating Oracle 9i release 9.2.0.6.0 production to SQL server 2019
Hi All,
- i have an oracle 9i and needs to migrate it to SQL server 2019.
- I can access the database as a admin but when i try to export the database and tries to login to Oracle management server it says invalid credentials.
- i was thinking to upgrade it but due to security reasons i am not allowed to access internet.
Can anyone please help me or can show me a way out.
Thanks
Comments
-
Can you debug code that you cannot see?
What, exactly, do you mean by "oracle management server"? Exactly how are you trying to log in to it?
Exactly what are you expecting to 'export', such that it can be migrated to SQL Server?
-
Hi Ed,
I am new to database migrations and my company recently decided to get rid of their old infrastructure.
- no i cant debug the code.
- when i try to export or backup i give me the error login to OMS. Screen shot is attached.
- If there is a way where i can migrate the oracle 9i to upgraded version and then migrate it from intermediate database to SQL server 2019.
Thanks
-
Ok, first off, the tool you are using is "SQL Developer".
It appears that you are trying to connect to Oracle Management Server, which I'm guessing from my quick google search is the interface to a database on Oracle's Cloud service. I have no experience with Oracle Cloud (other than a semi-annual email from the latest market rep trying to sell it to me) but when I googled "connect oracle sql developer to OMS" I got several promising hits.
-
You don't need to connect to that OEM Management Server to do an export, you can just run the exp utility and do it from the command line. However, you don't need to do that either, because there is no way you can use an export to copy data into a SQL Server. Why not? Because an export dump is an Oracle proprietary format that only another Oracle database can read.
If you need to copy data into SQL Server, you'll have to look at either connecting from the Oracle database to the SQL Server and pushing the data across (look up "Oracle HS Services") or connecting from the SQL Server to the Oracle database and pulling the data out (lookup "linked server"). Both those options are straightforward IF there is compatibility between the releases of Oracle and SQL Server. Is there compatibility between Oracle 9i and SQL Server 2019? Certainly not certified (because 9i went out of premier support over 10 years ago) but you can probably make it work. Or pay a consultant to make it work for you (my boss would be happy to give you a quote 🙂 ).
-
Hi,
I also have a 2008 SQL server. so there any tool via which i can migrate oracle 9i to sql server 2008 and than 2019.
because oracle 9i is not directly compatible with sql server 2019.
Thanks
-
because oracle 9i is not directly compatible with sql server 2019.
I suspect that Oracle 19c is not directly compatible with sql server 2019.
If you want to migrate data from database vendox X to database vendor Y, you should ask the experts of database Y. (In your case: SQL Server)
Warning database agnostic code is a myth.
