topic Re: Migrating a Versioned SDE database from SDE 9.2 to SDE 9.3.1 in Data Management Questions

Migrating a Versioned SDE database from SDE 9.2 to SDE 9.3.1

RandyKreuziger — Wed, 29 Sep 2010 16:01:58 GMT

We are moving from an old SDE 9.2 / SQL 2000 server to servers running SDE 9.3.1 / SQL 2008. Moving non-versioned databases has not been a problem but I haven't tried versioned SDE databases yet. Should I insist that the SDE databases be unverioned before moving to the new servers? On the old servers we used SQL logins but are moving to Windows Authentication on the new. This leaves the versions orphaned in a way when they are restored/upgraded on the new server. Or is this were sp_change_users_login is used?

Thanks

Re: Migrating a Versioned SDE database from SDE 9.2 to SDE 9.3.1

OvidioRivero — Thu, 07 Oct 2010 03:42:49 GMT

It is possible to do a direct upgrade from 9.2 to 9.3.1 but since you are also upgrading the database and server it may be easier/cleaner to unversion the data and copy it to the new database. If you work in an environment where there are multiple users you may want them to complete their versions and bring the database to state 0 while you get the new system ready, then copy the data over and grant permissions. That way your downtime is mostly limited to the time it takes you to transfer the data.