Hi I am new to Geodatabase.
We have a database in Oracle for Geodatabase. We need to migrate it to the MS SQL Server. There is one column as data type "ST_GEOMETRY" in Oracle table. What should the data type in MS SQL Server to match it?
How are you migrating the table from the Oracle Enterprise Geodatabase to SQL Server?Are they at the same version?That ST_Geometry field is specific to Oracle Geodatabases. What is the geometry that you are using in the SQL Geodatabase?
Is the data versioned?To be honest, the best way to migrate (safest way) is to copy / paste from Oracle --> SQL Server with ArcGIS Pro client.
Hi George,
Thank you for your reply.
I don't know the version of the Geodatabase, how can I check it.
I know that the Oracle Geodatabase is using ArcMap 10.4 to create. The MS SQL Geodatabase is using ArcGIS Pro 2.8 to create.
The problem for me is that our ArcGIS Pro has issue to connect to our Oracle database, that why we need to switch to MS SQL server.
What does the sde.version table say in Oracle?Using non-ArcGIS clients / tools to migrate from Oracle --> SQL Server may not work as expected.What is the error connecting to the Oracle GDB from Pro?
The sde.version in Oracle is "10.6.1 Geodatabase". It is a infrastructure issue that the location of ArcGIS Pro computer cannot access the Oracle database.
Signed in members can post, follow updates, and more. New here? Register a free account.
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.
