topic Migrating 9.1 SDE Data to 10.0 in Data Management Questions

Migrating 9.1 SDE Data to 10.0

Udaya_BhaskerCheerala — Wed, 07 Nov 2012 05:19:44 GMT

Dear All,

Currently we have Geodatabase on ArcSDE 9.1, we are plannig to migrate it to ArcSDE 10.0.

My plan is
1. create Geodatabase on ArcSDE 10.0 and
2. Copy datasets from ArcSDE 9.1 Geodatabase and paste it into ArcSDE 10.0 Geodatabase.

Is it right approach? if not please suggest me correct approach.

Note: Our Geodatabase on MS SQL Server.

Thanks in advance,
Uday

Re: Migrating 9.1 SDE Data to 10.0

VinceAngelo — Wed, 07 Nov 2012 10:34:38 GMT

ArcSDE 9.1 support was not a feature of 10.0. The geodatabase compatibility matrix tells
the tale.

I'd recommend using ArcSDE export files, but I'm pretty sure this *won't* work, because
HIGH precision was introduced at 9.2, and BASIC precision is not supported with geodatabase
functionality at 10.0 (you'd need to be *really* sharp on coordinate reference issues to plan
on using all HYBRID storage as the result of an upgrade). ASCII files would be more reliable
than shapefiles, but If you can find a copy of 9.2 Desktop, you could make file geodatabases
as an exchange format. 9.1 personal geodatabases are probably your best option.

- V

Re: Migrating 9.1 SDE Data to 10.0

AnnalieseVollick — Fri, 09 Nov 2012 10:22:34 GMT

To bring some data from our 9.1 environment into 10.1, I have exported from 9.1 into a personal Geodatabase and then imported it into my existing ArcSDE 10.1 (I'm using Oracle 11g). While you can connect to your 9.1 data from 10.0/10.1 and view it, you can't copy/paste (unsupported). This might not be the best way to do it, but it did work for me to get some of our existing 9.1 data into the newer 10.1 setup.

Annaliese

Re: Migrating 9.1 SDE Data to 10.0

GordonSumerling — Wed, 14 Nov 2012 10:14:19 GMT

Annaliese,

I have just been through this exact process. We had a 9.2 GDB to go to a 10.1 GDB. WHile 10.1 can connect to the SDE application service of 9.1/9.2 it cannot directly upgrade the GDB. We in fact installed the SDE 9.3.1 SDE binaries on a machine and used the 9.3.1 post install tools to connect to the 9.2 GDB and perform a 9.3.1 upgrade. WIth this done we could make a 10.1 gdb connection and perform the 10.1 upgrade.
A few hoops to jump but it worked. We did find that the 10.1 upgrade was more sensative than the 9.3.1 upgrade and there were some gdb errors that need fixing but mostly it was smooth.

Good Luck
Gordon