I have ArcServer 9.3.1 running on Windows Server 2003 R2 with Sql Server 2000. Have a new Windows Server 2012 R2 with ArcServer 10.3.1 on a new virtual server with SQL 2012 running on a different virtual server. We were hoping that we might be able to make a connection between ArcServer 10.3.1 and Arc Server 9.3.1 and pipe the compatible data to the new server. The compatibility matrix at Client and geodatabase compatibility—ArcGIS Help | ArcGIS for Desktop seems to say I can connect to the 9.3.1 geodatabases to upgrade. But we haven't been able to make a gis server connection in Catalog to the old server.
Even though we could make a connection with SQL 2012 Management Studio to our SQL 2000 database, and I can establish an OLE DB connection in Catalog to old geodatabases, the ESRI database group has us restoring from the SQL 2000 backups. However, SQL 2012 couldn't restore from the old backups. The database group told us to restore to SQL Server 2005, 2008 or 2008 R2 first, change the compatibility, then back it up from there, then restore the new backup on SQL Server 2012. We found a license for SQL 2008, but found we couldn't install it on Windows Server 2012 R2. Now we are installing on an older server to see if this will work. Did I wait too long to upgrade?
The database group told us that we couldn't use the Management Studio connection, or the OLE DB connection to import files because that would only give us access to the DB tables, not the feature classes and image sets.
But isn't the restores from SQL backups just going to give us the same tables?