topic Re: SDE to Shapefile to Personal Geodatabase Script in Data Management Questions

SDE to Shapefile to Personal Geodatabase Script

RichardNorzagaray__IV_ — Tue, 02 Oct 2012 20:46:14 GMT

I'm hoping someone can help - I am bound in using ArcGIS 9.3.1 due to dependencies beyond my control. So here is what I am trying to accomplish: Develop a script that will run nightly to export out an SDE layer based on a filter that is in the layer file into a shapefile or import into a personal geo-database and/or do both. I can only use a a personal geo-database or shapefile because the other application(s) will only use these two types of formats. I am told that FME dos a nice job of this process however we do not use it here. I was thinking maybe either a python or a C #/++ type script would do the job. Any help with this would really be appreciated.

Re: SDE to Shapefile to Personal Geodatabase Script

AntonyPaul_M1 — Wed, 03 Oct 2012 05:25:30 GMT

Hi Norzarr

I recomend to write a python script to do this.

If you are not proficient in python scripting use the model builder to make the model and then export the model to python script. Then schedule the job. Hope this helps.

Cheers
Antony

Re: SDE to Shapefile to Personal Geodatabase Script

RichardNorzagaray__IV_ — Thu, 04 Oct 2012 14:09:58 GMT

Thank you, Anthony I have completed the python script (Model builder) and it does just what I need.

Re: SDE to Shapefile to Personal Geodatabase Script

AntonyPaul_M1 — Fri, 05 Oct 2012 03:02:52 GMT

Cool good to know that

Cheers
Antony