Database Administrator

Chakravarthi Ayyala

<div>
Oracle != PostgreSQL<br />
<br />
You'll requires some sort of custom script to convert your data from Oracle -&gt; PostgreSQL.
</div>


Oracle != PostgreSQL

You'll requires some sort of custom script to convert your data from Oracle -> PostgreSQL.

<div>
Thanks Alex. Let me go through that.<br><br>
</div>


<div>
<div class="content wysiwyg-content fr-view">
Other than using AWS DMS tool, can we migrate the initial load outside DMS from Oracle to Postgres?<br>If yes, may i know what are the methods?<br><br>Thanks.
</div>
</div>



Other than using AWS DMS tool, can we migrate the initial load outside DMS from Oracle to Postgres?
If yes, may i know what are the methods?
Thanks.

If i have an Oracle database of 2 TB, and for the initial load, can i used SCN based backups in oracle and restore them in Postgres? If yes, can you please explain the method please?

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.