topic Re: Migrating from ArcServer 9.3.1 to ArcServer 10.3.1 in ArcGIS Enterprise Questions

Migrating from ArcServer 9.3.1 to ArcServer 10.3.1

PaulHuffman — Wed, 08 Jul 2015 21:34:04 GMT

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?

Re: Migrating from ArcServer 9.3.1 to ArcServer 10.3.1

AsrujitSengupta — Wed, 08 Jul 2015 23:15:12 GMT

To be honest, SQL Server 2000 to SQL Server 2012 is quite a big jump. There was 2005, 2008, 2008 R2 in between. So, yes the wait for upgrade was quite long.

Even though you can connect to a SQL Server 2000 instance from SQL Server 2012 Management Studio, you cannot restore it on the SQL Server 2012 instance directly.

OLE-DB connections are read-only and cannot be used to load data or upgrade the sde geodatabase to a higher version, which you ultimately need. To do the upgrade, you will need a Direct Connection.

Re: Migrating from ArcServer 9.3.1 to ArcServer 10.3.1

George_Thompson — Thu, 09 Jul 2015 15:21:43 GMT

Here is a blog outlining the instructions for upgrading the database from SQL Server 2000 to SQL Server 2012.

Migration SQL Server 2000 to SQL Server 2012 - Microsoft SQL Server - Site Home - TechNet Blogs

Once the database is at SQL Server 2012, you could then make a connection in ArcCatalog and then upgrade the geodatabase to 10.3.1.

-George

Re: Migrating from ArcServer 9.3.1 to ArcServer 10.3.1

PaulHuffman — Thu, 09 Jul 2015 17:56:42 GMT

Well, I didn't find a suitable place to install SQL 2008 yet. Now my DBA is going off to float the Tatshenshini River in AK for three weeks. Looks like this is being postponed until August. I hope that there is not another release between now and then.

Re: Migrating from ArcServer 9.3.1 to ArcServer 10.3.1

AsrujitSengupta — Thu, 09 Jul 2015 17:59:02 GMT

How Big are the databases? If they are below 10GB, download a SQL Server 2008 R2 Express edition (for free). This should work on the new server and shouldn't take much time.

Re: Migrating from ArcServer 9.3.1 to ArcServer 10.3.1

PaulHuffman — Mon, 31 Aug 2015 18:43:44 GMT

Step 2 on that blog has no details at all, just says Step 2: Make a second migration from SQL Server 2008 to 2012.

But I got it to work. Took a 2008 backup, restored to 2012. Now I just need to figure out how update the geodatabase and set up the users.

Updating the geodatabase I got a fail:

Bad login user [42000:[Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot execute as the database principal because the principal "sde" does not exist, this type of principal cannot be impersonated, or you do not have permission.]

Bad login user

Unpaused the database.

Failed to execute (UpgradeGDB).

Looks like I need to be connected to the database as user sde, which was the admin user on the old server and using SQL authenification. Trying now to give my SQL account owner privileges or make the connection as user sde.

Re: Migrating from ArcServer 9.3.1 to ArcServer 10.3.1

AsrujitSengupta — Mon, 31 Aug 2015 19:02:40 GMT

I guess that is because, the Step-1 was to take a backup at SQL 2000 and restore on SQL 2008, and then Step-2 was to take a backup at SQL 2008 of that same database and restore on SQL 2012.

Re: Migrating from ArcServer 9.3.1 to ArcServer 10.3.1

PaulHuffman — Mon, 31 Aug 2015 23:47:31 GMT

This is a helpful article on getting the databases and user accounts all going again after a SQL Server restore: http://support.esri.com/ja/knowledgebase/techarticles/detail/29672. Got this tip from Asrujit SenGupta at ESRI Tech Support.

Re: Migrating from ArcServer 9.3.1 to ArcServer 10.3.1

PaulHuffman — Mon, 21 Sep 2015 23:25:43 GMT

Using Create ArcSDE Connection File tool in 10.3.1, I was able to make a connection to one of my 9.3.1 SDE databases. I highlighted a raster, right clicked, Copy, pointed at one of the new 10.3.1 SDE connection files listings, hit Paste, and eventually it piped the whole raster into the new location. So I guess it would be possible to copy feature classes and rasters one by one to the new installation this way.

Re: Migrating from ArcServer 9.3.1 to ArcServer 10.3.1

PaulHuffman — Thu, 22 Oct 2015 00:18:24 GMT

More on this. I completed the two step backup and restore process, got all my databases restored to the new SQL server. Add Database Connection was able to connect to all of them but one, the one with all my lidar data and products, the biggest one. Tried both operating system and database authentication. The database pulldown lists the lidar database, but the connection always fails, with "Failed to connect to the specified server".

Re: Migrating from ArcServer 9.3.1 to ArcServer 10.3.1

AsrujitSengupta — Thu, 22 Oct 2015 04:59:28 GMT

Did you rename the database while restoring it?

Re: Migrating from ArcServer 9.3.1 to ArcServer 10.3.1

PaulHuffman — Mon, 26 Oct 2015 22:32:35 GMT

It looks like the name on the old server is lidar09, while the name in the restored file list is lidar.

The other thing that is different about this geodatabase is that in the 9.3 version, it was one of the two that I somehow made the transactional version dbo.Default rather than the standard sde.Default.

I'm going to try to import the database features classes one by one from an SDE file connection. This seems to be moving, except I didn't find a way to create a new feature dataset on the new geodatabase.

Re: Migrating from ArcServer 9.3.1 to ArcServer 10.3.1

AsrujitSengupta — Tue, 27 Oct 2015 01:47:35 GMT

You cannot restore a Geodatabase with a different name in SQL Server.

Re: Migrating from ArcServer 9.3.1 to ArcServer 10.3.1

PaulHuffman — Wed, 28 Oct 2015 17:47:52 GMT

Although I was able to move a batch of Lidar data from my 9.3 SDE host over my network with the SDE file connection, feature datasets aren't coming across with right click imports or exports as intact feature datasets, just the feature classes within the feature datasets. So terrains will have to be recreated.

I've been trying to move the feature classes into new feature datasets on the 10.3.1 side, but having trouble getting the spatial references to match. This is strange. When I try to create a new feature dataset in the 10.3.1 enterprise goedatabase, there is no import button for the coordinate system to bring it in from one of the feature classes like I am used to, and like appears in the 10.3.1 help files, and this thread https://community.esri.com/message/77856#77856

Re: Migrating from ArcServer 9.3.1 to ArcServer 10.3.1

AsrujitSengupta — Wed, 28 Oct 2015 17:52:27 GMT

You cannot transfer Feature Datasets from one gdb to another using the 'Feature Class to Feature Class' tool. As you observed, only the feature classes will be transferred.

You will either have to use Copy\Paste or Exmport\Import XML Workspace Document tool for the Feature Datasets.

Re: Migrating from ArcServer 9.3.1 to ArcServer 10.3.1

PaulHuffman — Wed, 28 Oct 2015 20:43:49 GMT

Trying now to create new feature datasets to replace the terrain feature datasets on my 9.3 server. However, when I right click in 10.3.1 ArcCatalog or ArcMap Catalog Window > New > Feature Dataset, after naming the new feature dataset, the next window wants me to define the xy coordinate system. In my experience, and in the 10.3.1 and 10.2.2 help files, there is supposed to be an Import button on this window that allows me to get the coordinate system from an existing feature class. (as in the link above to another thread) I don't understand why it seems to be missing in both 10.3.1 enterprise geodatabases and with 10.2.2 file geodatabases. (see above image) Is there an option in Desktop that I need to set?

I've tried to set the xy and z coordinate systems of a new feature dataset carefully to match the feature classes that are going into it, but I still get a "the spatial references do not match" message when I try to move a feature class into the new feature dataset.

The Create Feature Dataset (Data Management) tool looks like it still has the option of getting spatial reference "

By referencing a feature class or feature dataset whose spatial reference you want to apply, such as C:/workspace/myproject.gdb/landuse/grassland. " so I could try this in a python window.

If this gets any more tricky, I'll have to go bug my DBA to backtrack and see if he can figure out where he changed the database name in the two step restore process

Re: Migrating from ArcServer 9.3.1 to ArcServer 10.3.1

PaulHuffman — Wed, 28 Oct 2015 21:39:17 GMT

When I tried copy/paste in 10.3.1 ArcCatalog, the paste failed with "Failed to paste lidar09.DBO.LD2011SwaleGrnd The application is not licensed to create or modify schema for this type of data"

Re: Migrating from ArcServer 9.3.1 to ArcServer 10.3.1

PaulHuffman — Tue, 03 Nov 2015 23:43:37 GMT

I wonder why Import XML Workspace Document tool gave me a crash of Desktop 10.3.1 to the "Serious Problem. Tell ESRI what you were doing" window. I'll try exporting just a feature dataset to xml next.

Re: Migrating from ArcServer 9.3.1 to ArcServer 10.3.1

DerekLaw — Thu, 05 Nov 2015 07:14:27 GMT

Hi Paul,

Please see my reply to you other similar post in this thread,

The Import XML Workspace Document tool with my enterprise goedatabase.

Hope this helps,

Re: Migrating from ArcServer 9.3.1 to ArcServer 10.3.1

PaulHuffman — Thu, 05 Nov 2015 17:09:47 GMT

The troublesome geodatabase, the one that didn't work when I did the two step backup/restore, created a 26 gb xml file. Now that that import xml workspace document option has been shown not to work for 9.3 to 10.3.1, I'll have to go back and repeat the two step process or track down where the DBAs inadvertently changed the database name.