filmov
tv
Migrating Geospatial Data From MSSQL 2 Oracle Spatial Issues

Показать описание
We convert MSSQL Geography to WKT, Move the table and data to Oracle Autonomous Data Warehouse, Alter the Table to include a SDO_Geometry Column, then using geospatial constructor convert WKT to SDO_Geometry. Then we perform validation analysis on the data by using map view in SQL Developer, and also in Oracle Spatial Studio where errors are discovered with one exception.