O'Reilly logo

Oracle Database Administration for Microsoft SQL Server DBAs by Michelle Malcher

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required