SQL Developer: The Next Generation Number One & Number Two Jeff Smith & Brian Spendolini Copyright © 2021, Oracle and/or its affiliates 1

Our 16 year Mission... Explore strange new databases Seek out new platforms and applications To boldly go where SQL*Plus never went before To easily copy data from one database to another, Cloud or otherwise. Copyright © 2021, Oracle and/or its affiliates 2

SQL Developer launches in 2005 • SQL scratchpad • PL/SQL IDE • Schema browsing • Database Administration • Data modeling • REST • 3rd party DBMS migration to ORCL • TimesTen, Data Miner, OLAP, … https://www.oracle.com/sqldeveloper Used by over 5 million database pros

Data Pump Wizard: Copy to OSS/Import

Jeff Smith

SQLcl • Modern command-line interface • Auto complete SQL syntax • Command history • Output json, csv, html, inserts, xml… • Liquibase schema versioning • Scripting friendly • No Oracle Home required • OCI & OSS Integration https://www.oracle.com/database/technologies/appdev/sqlcl.html SQL Command Line

Ridiculously Easy to Get Started • Installed by default with Oracle Database • Installed by default in Oracle CloudShell • yum & brew • https://download.oracle.com/otn_software/java/sqldeveloper/sqlcl-latest.zip

Data Pump • Client • DBMS_DATAPUMP PL/SQL API • DBMS_CLOUD integration • Interfaces in SQL Developer & SQL Developer Web • ORDS & DB API • OEM • …

SQL Developer Web • SQL Worksheet • Load data • Monitor and manage your DB • Schema diagramming • REST development interface • JSON Document Store (SODA) • User management • … and, Data Pump!!! https://www.oracle.com/database/technologies/appdev/db-actions.html

Monitor jobs, check logs, download DMPs

Oracle REST Data Services • Microservices & REST APIs for your database • Declaratively defined using SQL, PL/SQL • Desktop, CLI, Browser, and PL/SQL interfaces • Auto REST enable tables, views, stored procedures • JSON Document Store (SODA for REST) • Database Management REST APIs • REST Enabled SQL Service • Type III JDBC Driver https://www.oracle.com/rest HTTPS Results JSON SQL Meta Data Repo

ORDS DBAPI & Data Pump

datapump (dp) export • Create and start job that exports current schema • DATA_PUMP_DIR • JOB Name: {schema}.ESQL_### • Output: ESQL_####.DMP ESQL_####.LOG

Flags, lot of flags • Need to deviate from defaults? • No problem!

All the options dp help syntax

dp help examples

Generate and show me the code

Run & Monitor

…and now…the rest of the story! • Live Demos • Cloud magic!