Abstract
![]() Managing & Migrating Multiple Instances of ArcSDE Across an Enterprise Track: Defense and Intelligence Author(s): Bernard Traphan, Allen Dooley Organizing Raster and Vector data in multiple instances of ArcSDE presents a unique set of challenges and opportunities. The complexity of this task is exacerbated by the need to move this data between production and development servers. This paper will discuss how these challenges are being addressed at the Joint Information Operations Center (JIOC) to provide easy and efficient access to multiple TerraBytes of map data and imagery. ArcSDE 9 allows ArcSDE instances to be multi or single spatial. It is possible to break apart databases from a multi-spatial instance into single spatials. Possible does not usually equate to easy though as evidenced by problems we have seen with User IDs and logins. The purpose of this presentation will be to present the procedures and SQL Server scripts that the JIOC has developed to successfully resolve these issues and be able to quickly move databases between servers and ArcSDE instances. Bernard Traphan JIOC J62 5804 Babcock RD ## 266 San Antonio , TX 78240 US Phone: 210-414-5226 Fax: 888-678-7315 E-mail: Bernard.Traphan@jioc.osis.gov Allen Dooley Contractor, SAIC Information Operations Division Joint Information Operations Center/J62 2 Hall Blvd, Suite 217 San Antonio , TX 78243-7008 US Phone: 210-977-4705 E-mail: Allen.Dooley@jioc.osis.gov |