Use T-SQL to create external tables for Oracle is cumbersome and error-prone. You may refer the article if you are interested.
Today I’m going to show you how to use ‘data virtualization’ extension of ‘Azure data Studio’ to do it.
You may still run into error , however you can modify the ‘script’ to correct it.
https://docs.microsoft.com/en-us/sql/azure-data-studio/download?view=sql-server-ver15
It’s available to use after installation. (Current version (1.1.0) supports SQL Server and Oracle)
Here is an example of connecting Oracle data source.
Here is an example
Optional, you can check each table to modify the target schema name, table name and the columns you need to export.
Here is an example. In case the creation fails, you can manually run the script to check.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.