New answers tagged java
Usually you would ask the features to give you their schema using: SimpleFeatureType schema = collection.getSchema(); You can then use that to generate the Oracle schema to write the data into.
If you are happy with Java then GeoTools provides SQLServer and Shapefile datastores that will allow you to do the conversion. But to be honest I'd use ogr2ogr, which is something like: ogr2ogr "MSSQL:server=.\MSSQLSERVER2008;database=geodb;tables=rivers;trusted_connection=yes" dst.shp
Top 50 recent answers are included