topic Restore an ArcSDE database backup to a database with a different name? in Data Management Questions https://community.esri.com/t5/data-management-questions/restore-an-arcsde-database-backup-to-a-database/m-p/458002#M26166 <HTML><HEAD></HEAD><BODY><SPAN>I am using ArcSDE 10.1 and PostgreSQL 9.1/PostGIS 2.0. I have backups of a production database that I'd like to use for a development database. The name of the development database appends "_dev" to the database name to avoid confusion. However, when I restore the production backup to the development database, I receive the following error on connection:</SPAN><BR /><BR /><PRE class="lia-code-sample line-numbers language-none">2013-03-05 08:07:28 PST ERROR:&nbsp; cross-database references are not implemented: "cvag.sde.sde_object_ids" at character 21 2013-03-05 08:07:28 PST QUERY:&nbsp; SELECT base_id FROM cvag.sde.sde_object_ids WHERE id_type = i_id_type FOR UPDATE 2013-03-05 08:07:28 PST CONTEXT:&nbsp; PL/pgSQL function "sde_get_primary_oid" line 15 at FOR over SELECT rows 2013-03-05 08:07:28 PST STATEMENT:&nbsp; SELECT cvag_dev.sde.SDE_get_primary_oid ($1,$2) </PRE><BR /><BR /><SPAN>Which leads me to believe that one or more functions in the sde schema is defined with database names as a reference and restoring to a database with a different name doesn't work. </SPAN><BR /><BR /><SPAN>I have also tried creating the enterprise geodatabase first and then restoring a backup of the production database that excludes the 'sde' schema. The connection works, but now my 800+ feature classes are not registered with the geodatabase. </SPAN><BR /><BR /><SPAN>Are there any best practices published for working with production and development databases that might help me here?</SPAN><BR /><BR /><SPAN>Thanks.</SPAN></BODY></HTML> Sat, 11 Dec 2021 20:23:22 GMT deleted-user-1T_bOHag6M8d 2021-12-11T20:23:22Z Restore an ArcSDE database backup to a database with a different name? https://community.esri.com/t5/data-management-questions/restore-an-arcsde-database-backup-to-a-database/m-p/458002#M26166 <HTML><HEAD></HEAD><BODY><SPAN>I am using ArcSDE 10.1 and PostgreSQL 9.1/PostGIS 2.0. I have backups of a production database that I'd like to use for a development database. The name of the development database appends "_dev" to the database name to avoid confusion. However, when I restore the production backup to the development database, I receive the following error on connection:</SPAN><BR /><BR /><PRE class="lia-code-sample line-numbers language-none">2013-03-05 08:07:28 PST ERROR:&nbsp; cross-database references are not implemented: "cvag.sde.sde_object_ids" at character 21 2013-03-05 08:07:28 PST QUERY:&nbsp; SELECT base_id FROM cvag.sde.sde_object_ids WHERE id_type = i_id_type FOR UPDATE 2013-03-05 08:07:28 PST CONTEXT:&nbsp; PL/pgSQL function "sde_get_primary_oid" line 15 at FOR over SELECT rows 2013-03-05 08:07:28 PST STATEMENT:&nbsp; SELECT cvag_dev.sde.SDE_get_primary_oid ($1,$2) </PRE><BR /><BR /><SPAN>Which leads me to believe that one or more functions in the sde schema is defined with database names as a reference and restoring to a database with a different name doesn't work. </SPAN><BR /><BR /><SPAN>I have also tried creating the enterprise geodatabase first and then restoring a backup of the production database that excludes the 'sde' schema. The connection works, but now my 800+ feature classes are not registered with the geodatabase. </SPAN><BR /><BR /><SPAN>Are there any best practices published for working with production and development databases that might help me here?</SPAN><BR /><BR /><SPAN>Thanks.</SPAN></BODY></HTML> Sat, 11 Dec 2021 20:23:22 GMT https://community.esri.com/t5/data-management-questions/restore-an-arcsde-database-backup-to-a-database/m-p/458002#M26166 deleted-user-1T_bOHag6M8d 2021-12-11T20:23:22Z Re: Restore an ArcSDE database backup to a database with a different name? https://community.esri.com/t5/data-management-questions/restore-an-arcsde-database-backup-to-a-database/m-p/458003#M26167 <HTML><HEAD></HEAD><BODY><SPAN>As you've already mentioned, the database name is indeed referenced in a PostgreSQL geodatabase repository. You will need to restore the database with the same name. This issue also applies to a SQL Server geodatabase is described here : </SPAN><A href="http://support.esri.com/en/knowledgebase/techarticles/detail/36549">FAQ:&nbsp; Can I restore an ArcSDE geodatabase with a different database name in SQL Server? </A></BODY></HTML> Fri, 08 Mar 2013 22:30:44 GMT https://community.esri.com/t5/data-management-questions/restore-an-arcsde-database-backup-to-a-database/m-p/458003#M26167 MandarPurohit 2013-03-08T22:30:44Z