Using shape across database links

227
1
02-21-2018 12:56 PM
Highlighted
MVP Regular Contributor

Has anyone every come up with a solution for pulling shape across a database link? Really tired of maintaining a pile of 200+ python scripts to move data back and forth between databases.

Shape CLOBS are 1.5m in some cases, so i cant convert to text.  

Thanks

Tags (2)
Reply
0 Kudos
1 Reply
Highlighted
Esri Contributor

Consider:

How to handle Oracle BLOB columns via Database Link 

as an example of ways that developers have been solving this problem.

Also, don't forget WKB for a smaller payload than WKT.

Also, Ask Tom mentions 12.2 and the lifting of some restrictions regarding LOBs:

Ask TOM "Transfer data from one db to another db over db li..." 

-Dale