Using SQL update to update featureclass

QuinnMcCarthy

I have 400 polygons that need a attribute update and not looking forward to doing it 1 by 1. OUr data is based in SQL Server 2008 and I am wondering if anybody uses SQL update command to update FC? I need to update the GIS fc from data in another table. So I am looking at something like this.

update VectorReplica.dbo.PARCELS set PARCEL_ID = new_pid from Ranieranneaxparcels
where VectorReplica.dbo.PARCELS.PARCEL_ID = Ranieranneaxparcels.NEW_PID

I have done some updates on small basis but nothing like this.

I am working on the child of the replica with a file GDB backup too for safety reasons.

Thanks

Quinn

KenCarrier

jnderose,

I was thinking about my problem and using multiversioned views.

Can I get by with not using a MV view if I add all of the records from that layer and did a join field in arctoolbox? I have fields that I need

to delete first and then do a join field to get the data field I need filled in? Then syncronize and to update the parent. Would you need to do the schema changes first?

Thanks

Quinn

I would recommend doing the following

1. Rec and Post
2. Full compress
3. Sync replicas
4. Compress production db
5. Unregister versioned objects you need to make schema changes to
6. Perform schema and attribute updates
7. Delete the versioned data from the other replica
8. replicate only the data you made changes to as a new replica
9. Unregister both replicas
10. Create a new replica using existing data method