Database Migrations
You might need to learn Oracle because your company’s current database will be converted from SQL Server to Oracle. There are various ways to migrate, but all begin with a solid plan. The options available have varying inputs and outputs, as well as varying amounts of downtime and risk.
You will need an Oracle database, a way to convert the definitions of the tables from SQL Server datatypes to Oracle datatypes, a way to move the data over to the new system, and a way to convert the stored procedures and packages. Depending on how big and complex the database is, this could be a very simple or a very complicated move.
Not all of the datatypes can translate exactly from one platform to another. Table 1-3 shows just an example ...
Get Oracle Database Administration for Microsoft SQL Server DBAs now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
