3

I am able to successfully move an ArcSDE geodatabase from one SQL Server 2008 R2 Express to another SQL Server of the same version using the restore backup method. Now I tried to move it the same way to an SQL Server 2012 Enterprise. But it does not work. If I connect to the geodatabase on SQL Server 2012 via ArcCatalog I only see Tables no Feature Classes. The user and logins of the two DBs are same.

What am I missing? How would you move the geodatabase?

Thanks for your help.

|improve this question
2

ArcGIS is very sensitive to database names. You cannot restore data unless the database name is identical. You will need to use Feature Class to Feature Class or a copy/paste, or any of the other ways to copy data with Desktop or ArcPy (the list of options can be daunting). All transfers should be done as the data owner(s), not as the administrative 'sde' user.

|improve this answer
  • What do you mean by "Featureclass to Featureclass"? Regarding copy/paste as owner how can I do that? Would I need to run ArcCatalog under the user "sde" and copy paste from one db to the other? – oolol Oct 8 '14 at 11:54
  • 1
    You should never load any data as the 'sde' user, ever. You said you have duplicate logins -- use them. – Vince Oct 8 '14 at 13:59

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.