How to migrate your ArcGIS default geodatabase to an Enterprise Database
LeandroPastore 3100028DTY Visits (6555)
If you use a regular geodatabase in your ArcGIS Server and, for some reason, have to migrate it to an Enterprise Database (such as Oracle, SQL Server, et cetera), you can follow the process below (these steps are for Oracle databases only):
1. Create a standard Oracle database inside a server of your choice.
2. In order to be able to connect to your Oracle database, you will have to install Oracle Client in your ArcGIS environment. If you are having trouble to install it, follow the steps in this link> http
3. Open the Catalog inside your ArcMap.
4. Expand the Database Connections section.
5. Double-click Add Database Connection.
6. Fill the required fields:
7. Click OK.
8. Open the ArcToolbox inside your ArcMap.
9. Open Data Management Tools.
10. Open Geodatabase Administration.
11. Double-click Create Enterprise Geodatabase.
12. Fill the required fields:
13. Click OK.
14. Open the Catalog inside your ArcMap.
15. Right click the Folder Connections.
16. Click the Connect to Folder option.
17. Insert the path of the database which contains the data you want migrated and click OK.
18. Open ArcToolbox inside your ArcMap.
19. Open Data Management Tools.
20. Open Geodatabase Administrator.
21. Double-click Create Database User.
22. Fill the required fields:
23. Click OK.
24. Now you'll have to create a new Database Connection using the user you just created.
25. Delete the Database Connection created on step 6.
26. Inside your Catalog, open the Folder Connections and then the folder you mapped on step 17.
27. Right-click the database which contains the data to be migrated.
28. Go to Export and then click on To Geodatabase (multiple)....
29. Put the Database Connection you created on step 22 inside the Output Geodatabase field and click OK.
30. Wait for the process to finish.
I recommend you to check if everything went fine by looking at the results window of your ArcMap.
And that's it! Republish your Map Service and enjoy!