I have an SDE geodatabase. I need to load a shapefile and replace all of the data in a layer with the new data coming in. For example there is a roads layer in the geodatabase and once a month I get a new roads layer. I'm looking to just replace the entire layer and add the new data that I have received in a shapefile format. Is there an easy way to do this?
+23- Enthusiast
Since you are replacing the data each time, you might look into setting the SDE writer to "truncate existing" which will remove all existing data and load the new data into that feature class.
+10- Contributor
I agree with @Chris Warren set the writer to truncate existing. This will keep the table structure as is, remove the existing data and then insert your new data into the table....
+10- Contributor
ingalla wrote:
I agree with @Chris Warren set the writer to truncate existing. This will keep the table structure as is, remove the existing data and then insert your new data into the table....
If you click on the cog within the writer you will see the properties. The truncate existing can be found in the General / Table Handling section
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.