Automating ArcSDE Geodatabase Maintenance - IGIC

heavyweightuttermostΜηχανική

5 Νοε 2013 (πριν από 3 χρόνια και 11 μήνες)

220 εμφανίσεις

A
UTOMATING

A
RC
SDE

G
EODATABASE

M
AINTENANCE

2011 IGIC Conference

Muncie, Indiana

Presenter: Trent Pell, GISP

H
ISTORY


MCCOG is a Metropolitan Planning
Organization(MPO)


MCCOG provides GIS and Planning support to
Madison County


Approximately 130,000 in population


Approximately 86,000 land parcels


Approximately 450 sqaure miles


County/Community in transition


Largest City: Anderson

GIS O
VERVIEW


Automation on a single SDE Geodatabase


Versioned w/global ID’s


Multiple Editors


RDMS is SQL Server 2008 R2 (processor license)


Windows 7 & Server 2008 R2


64 bit


ArcGIS Server 10sp1 Standard Enterprise
Edition



W
HY

A
UTOMATE
?


Performance


Streamlines process


After hours


Why not!




W
HAT

S
HOULD

BE

A
UTOMATED
?


Rebuild Database Statistics


Compress Database


Reconcile & Post database versions


Delete & Re
-
create Versions


Sync Database changes to Web Geodatabase


P
ROCESS


Rebuild Statistics


Compress Database


Reconcile & Post versions to Default


Kill all connections to Database


Stop Web Services


Delete all versions


Compress Database


Rebuild Statistics


Re
-
create Versions

R
EBUILD

S
TATISTICS


Analyze Tool


Updates database statistics of business tables,
feature tables, and delta(adds & deletes) tables


Create model & export as python script


Run on client machine

S
TATISTICS


C
OMPRESS

D
ATABASE


SDE command line


Sdeversion

o compress

u sde

p password

i
ServiceName
-
N


Batch file on server

C
OMPRESS

D
ATABASE

Uncompressed State Tree

Compressed State Tree

R
ECONCILE

& P
OST

V
ERSIONS

TO

D
EFAULT


Reconcile Tool


Create model & export as python script


Run on client machine

R
ECONCILE

& P
OST

V
ERSION

TO

D
EFAULT

K
ILL

C
ONNECTIONS

TO

D
ATABASE


SDE command line


sdemon
-
o kill
-
t all
-
p password
-
N
-
i
Madison_Managed


Batch file on server


Stop WebServices accessing database


AGSSOM arcscript command


Batch file on server


cd C:
\
Users
\
tpell
\
Desktop
\
AGSSOMv10.0


AGSSOM.exe
-
x WebServiceName

D
ELETE

V
ERSIONS


SDE command line


Sdeversion

o delete

V VersionName

N

u
VersionOwnerName

p VersionOwnerPassword

i
ServiceName


Batch file on server


Delete your QA version LAST!

D
ELETE

V
ERSIONS

C
LEANUP
!


Compress database again


Re
-
run Analyze/Re
-
build Statistics


Re
-
Create Versions


SDE command line


Batch file on server

F
INAL

C
OMPRESS

R
E
-
C
REATE

V
ERSIONS

A
UTOMATION


Utilize Windows Task Scheduler on both client
and server


Allow ample time for each task to complete

A
UTOMATION

T
IME
-
L
INE


1am
-

Rebuild Statistics


1:30am
-

Compress Database


1:45am
-

Reconcile & Post versions to Default


2am
-

Kill all connections to Database


2:15am
-

Stop Webservices


2:30am
-

Delete all versions


2:45am
-

Compress Database


3am
-

Rebuild Statistics


3:30am
-

Re
-
create Versions

A
UTOMATION



W
INDOWS

T
ASK

S
CHEDULE



A
UTOMATION



T
RIGGERS

A
UTOMATION



A
CTIONS


Browse to necessary program or file


For python scripts browse to the python.exe


Python scripts require arguments


Argument is just the


python file


For batch files just browse


to the .bat file

O
NE

S
TEP

F
URTHER


Automate changes to Web based applications

G
ETTING

CHANGES

TO

THE

W
EB


Each dataset needs to be versioned with Global
IDs


One way synchronization between internal
Geodatabase and ‘Web’ Geodatabase

T
O

THE

W
EB
!


Stop all web services


AGSSOM batch file on
server


Export, Compare & Import Schema Changes
between Managed & Web Geodatabase


python
script


Sync changes between Geodatabases


python
script


Start Webservices


AGSSOM batch file on server

S
CHEMA

C
HANGES

& R
EPLICATION

A
UTOMATION

T
IME
-
L
INE


1am
-

Rebuild Statistics


1:30am
-

Compress Database


1:45am
-

Reconcile & Post versions to Default


2am
-

Kill all connections to Database


2:15am
-

Stop
Webservices


2:30am
-

Delete all versions


2:45am
-

Compress Database


3am
-

Rebuild Statistics


3:30am
-

Re
-
create Versions


3:45am
-

Export Replica Schema


4:15am
-

Compare & Import Replica Schema


4:45am
-

Sync Managed & Web
Geodatabases


5:15am


Start
Webservices

U
SEFUL

T
OOLS


PythonWin


ArcScript AGSSOM tool


Geodatabase Toolset or GDBT


SDE command line is your friend

L
ESSONS

L
EARNED


Communicate


TEST!


Make Backups


Local security settings


Ensure user on server has Log as a Batch Job
privleges under Local Security Policy>User Rights
Assignment


Be flexible with your time
-
line and
implementation

T
HANK

Y
OU
!


Trent Pell, GISP

GIS Coordinator

Madison County Council of Governments

tpell@mccog.net

765
-
641
-
9695