SDE to Shapefile to Personal Geodatabase Script

[RichardNorzagaray__IV_]

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.

[AntonyPaul_M1 · Accepted solution]

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

[RichardNorzagaray__IV_]

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

[AntonyPaul_M1]

Cool good to know that

Cheers
Antony