Copying entire geodatabase with relationship classes and domains and reproject all feature classes from wgs84 to state plane?

Question

I have an SDE geodatabase with several feature classes, tables, relationship classes, and domains. All the feature classes are currently in WGS84 coordinate system.

I need an exact copy of the entire geodatabase, but with all feature classes projected in the appropriate state plane coordinate system.

I used the feature class to feature class tool to copy the feature classes from one gdb to another and set the environment output coordinate system to state plane, but I lost all of the relationships and tables.

Is there a way to do this in one step without having to recreate all the relationship classes?

Answer 1

Thanks all for your responses. Unfortunately, none of the solutions mentioned did the trick for me, although I'm sure they would all work under slightly different circumstances.

The resolution is in the following steps:

1. Feature Class to Geodatabase (multiple) to copy all feature classes from the original geodatabase to the new empty geodatabase.
2. Set Environments on Feature Class to Geodatabase tool with Output Coordinate System specified in desired new coordinate system.
3. Table to Table tool (multiple) to copy all tables from the original geodatabase to the new geodatabase.
4. Manually recreate all relationship classes.

I wish there were a better solution to this, but I just couldn't get it to work without breaking all the relationship classes. I hope this helps someone in the future.

Answer 2

I think what you want to do can be done without too much trouble given that there are no feature datasets involved and all the coordinate systems are the same, although it's not a one-step process unless you script it.

1. Copy your feature classes to a new file geodatabase using Copy/Paste which brings over relationship classes and related tables. (side question, are there any GP tools that can do this? I think not)
2. Project all your original feature classes to the new coordinate system using an intermediate geodatabase
3. Delete the contents of all the feature classes in the output geodatabase using Delete Features
4. Redefine the coordinate system of all your feature classes in the output geodatabase using Define Projection
5. Append the projected feature classes from the intermediate workspace to their corresponding feature classes (now empty) in the output workspace

If there were feature datasets involved I think this approach would fail because Define Projection doesn't work on feature datasets that are not empty. In that case my fallback plan would be to export the geodatabase to an XML workspace document and munge it by hand or with Python or an XSLT file.

Answer 3

I had the same question, and I solved it the same way blah238 says : exporting the geodatabase(or its schema) into an XML File, then modify the Spatail Reference inside this XML file, and reimport it into the new Geodatabase.

Here are the steps :

1) Right click in your source geodatabase, and select "Export/XML Workspace Document"

2) Check "Schema Only", specify the XML output file

3) Press the "Include All" button to select all the features of your geodatabase

4) Then Finish

5) Open the XML file with an editor (like NotePad++)

6) Replace the content of all the "SpatialReference" tags with your new spatial reference

7) Set the content of all the "GridSize0" tags to 0 (useful to reinitiate the grids of the empty datasets

8) Save it

9) Create an empty geodatabase. Right click in it, and select "Import/XML Workspace Document"

10) Select your XML file

11) Once the geodatabase is created, you can append your reprojected data into tables and feature classes

11) You're Done !!

It seems to work well. You have to project all your data separately from the geodatabase, and reimport them (load or append) into the new one

Good luck.

Answer 4

If this is just a one-time job, you could simply copy the geodatabase in its entirety, then project all of the featureclasses to State Plane. Not very elegant, but it should work. Could be scripted in Python as well - copy the geodatabase then loop through the featureclasses, projecting as you go. You could build a dictionary that has the featureclass names as keys and the target state plane system(s) as the value(s), then call that as you project.

Answer 5

Here's an article for creating a replica where data in the child has a different coordinate system than the parent. You would just skip the replica creation in step 5:

HowTo: Create a replica where the child replica data is in a different coordinate system than the parent replica data

Answer 6

This is probably way late, but use X-Ray Add in for ArcCatalog. You set the GDB and the XML. In options you can set spatial reference.

Answer 7

The solution suggested by Tim Michael works perfectly. You don't need the last step: use the Create Replica Wizard to create replicas. In a sde geodatabase, you might need to first 1) register your dataset as versioned; and 2) add GlobalID. I use sde geodatabase as parent/source and a file geodatabase as child/destination.