SQL Server 2008 R2 and ArcSDE 9.2?

[JimSmith]

We have a user group that needs to keep a legacy application alive while it is being replaced. The legacy app, a MapObjects 2.x thing, is not compatible with geodatabase versions later than 9.2 (we tested it with 9.3 and it does not recognize certain features). The app requires a service connection via ArcSDE server because it is not an ArcMap extension, it is standalone. IT wants to migrate the server to virtual environment and also use SQL Server 2008, so we have built and tested a VM with ArcSDE 9.2 SP6 and SQL Server 2008. It seems to work.

Now IT wants to upgrade this virtual server to SQL 2008 R2 before we cut over the users.

Is there anyone who can give me some feedback on whether this will work?

Thanks.

[BugPie]

Was there ever feedback on this situation?  We are running into the same situation. We need to move and upgrade the current SDE 9.2 to a version 10. All on a new development server all while keeping our old customized IMS 9.2 and SDE running in production. Anyone have insight or great documentation?

[JimSmith]

The answer to my question, are SQL Server 2008 R2 and ArcSDE 9.2 compatible, is yes. We had to make one change to the dbtune table: set the DEFAULTS keyword UNICODE_STRING to FALSE.
Our old MO app would not recognize Unicode field values.

If you need to preserve a 9.2 geodatbase instance you will need to also keep one ArcSDE application server at 9.2; ArcSDE 9.3 or 10 cannot manage older versions of the geodatabase.