11 October, 2020

On-Premises SQL Server to Oracle ADB on the Cloud -- 2

 Having configured connectivity between an On-Premises SQL Server Database to an Oracle ADB Database in the Oracle Cloud in the previous post, I will now copy data from SQL Server to Oracle


  • Create the Target Table in Oracle ADB 

SQL Developer


  • Verify Existing Rows in SQL Server


SQL Server Management Studio

  • Insert into Oracle with Select from SQL Server

SQL Server Management Studio


  • Verify Rows Inserted into Oracle

SQL Developer


  • Create New Row in SQL Server and Verify that it is NOT present in Oracle
SQL Server Management Studio


The last screenshot is literally a NOT IN query between SQL Server On-Premises and Oracle in the Cloud.












No comments: