topic Re: Copy SDE geodatabase (source; enterprise geodatabase, destination; enterprise geodatabase) in Geodatabase Questions

Copy SDE geodatabase (source; enterprise geodatabase, destination; enterprise geodatabase)

JohnMellor__GISP — Wed, 15 Mar 2017 15:20:21 GMT

What is the best way to make an entire copy of an SDE geodatabase to a "test" SDE geodatabase?

Re: Copy SDE geodatabase (source; enterprise geodatabase, destination; enterprise geodatabase)

Asrujit_SenGupta — Wed, 15 Mar 2017 15:37:49 GMT

The best method will be to do a Full database backup and restore.

Or else if you already have the test GDB created, you have got a few choices: Overview of copying geodatabases—ArcGIS Help | ArcGIS Desktop

Re: Copy SDE geodatabase (source; enterprise geodatabase, destination; enterprise geodatabase)

JohnMellor__GISP — Wed, 15 Mar 2017 16:13:54 GMT

Yes, I do have a TEST enterprise geodatabase already built.

But I am looking to have an exact duplicate, for testing purposes. I have read through the overview of copying and that doesn't seem to apply.

Should I delete the TEST enterprise geodatabase and do the SQL backup and restore?

Re: Copy SDE geodatabase (source; enterprise geodatabase, destination; enterprise geodatabase)

Asrujit_SenGupta — Wed, 15 Mar 2017 16:16:40 GMT

Yes, that should help and be quick.

Which kind of Database (Oracle, SQL Server,etc) are you working with?

Re: Copy SDE geodatabase (source; enterprise geodatabase, destination; enterprise geodatabase)

JohnMellor__GISP — Wed, 15 Mar 2017 17:47:04 GMT

SQL Server

Re: Copy SDE geodatabase (source; enterprise geodatabase, destination; enterprise geodatabase)

Asrujit_SenGupta — Wed, 15 Mar 2017 17:54:19 GMT

so just backup that SQL Server database and restore it on another Test instance and that should give you what you needed. An exact copy.

Re: Copy SDE geodatabase (source; enterprise geodatabase, destination; enterprise geodatabase)

JohnMellor__GISP — Thu, 16 Mar 2017 17:38:38 GMT

Can you explain "and restore it on another Test instance" ?

So do I need another existing instance, or am I creating the instance with restore?

Re: Copy SDE geodatabase (source; enterprise geodatabase, destination; enterprise geodatabase)

George_Thompson — Thu, 16 Mar 2017 18:30:23 GMT

An "instance" in SQL Server is a installation of SQL Server. Within that SQL Server instance, you can have multiple databases (as long as they do not have the same name). I think what Asrujit SenGupta‌ is saying is to restore to the new SQL Server instance.

Example: Machine1\SQLServer to Machine2\SQLServer

Database Engine Instances (SQL Server)

Re: Copy SDE geodatabase (source; enterprise geodatabase, destination; enterprise geodatabase)

JohnMellor__GISP — Mon, 20 Mar 2017 15:24:20 GMT

I'm still new to SQL; Does this mean that I have to move off the current instance? Would it be possible to make a duplicate (TEST) database on the same instance? Is instance synonymous with machine? Can I have two instances on the same machine?

Re: Copy SDE geodatabase (source; enterprise geodatabase, destination; enterprise geodatabase)

Asrujit_SenGupta — Mon, 20 Mar 2017 15:30:01 GMT

You cannot have two databases with same name on one instance.
You cannot rename an Enterprise geodatabase
Yes, you can have two instances on the same machine. Logically, you should always have a separate SQL Server instance for development and testing.

Re: Copy SDE geodatabase (source; enterprise geodatabase, destination; enterprise geodatabase)

JohnMellor__GISP — Mon, 20 Mar 2017 16:19:28 GMT

What would be the PROs & CONs of simply backing up the production database, and restoring to different named database (say, as TEST) in the same instance?

Re: Copy SDE geodatabase (source; enterprise geodatabase, destination; enterprise geodatabase)

Asrujit_SenGupta — Mon, 20 Mar 2017 16:25:30 GMT

You can restore with a different name, but that is not supported with ArcGIS. You will not be able to connect from ArcGIS Desktop.

Re: Copy SDE geodatabase (source; enterprise geodatabase, destination; enterprise geodatabase)

JohnMellor__GISP — Mon, 20 Mar 2017 16:26:16 GMT

Ok, I think I understand it now. Thank you for you help.

Re: Copy SDE geodatabase (source; enterprise geodatabase, destination; enterprise geodatabase)

EduardoAbreu-Freire — Tue, 09 Oct 2018 17:23:40 GMT

Asrujit SenGupta‌ and George Thompson's Blog‌

Since this is true (in SQL Server backup and restore a DB will not able ArcGIS to connect to it) what should be the way to make a copy of a full geodatabase (datasets, feature classes, tables, RCs, subtypes, domains)?

Re: Copy SDE geodatabase (source; enterprise geodatabase, destination; enterprise geodatabase)

George_Thompson — Tue, 09 Oct 2018 17:43:46 GMT

You CAN connect to a restored SQL Server DB as long as the name of the DB is UNCHANGED. In these cases you must restore to a different instance of SQL Server or remove the original DB and then restore to the original instance.

You can make a copy via Copy/Paste in Catalog once you reconcile/post/compress and verify that any versioned data is out of the delta tables.

Re: Copy SDE geodatabase (source; enterprise geodatabase, destination; enterprise geodatabase)

Asrujit_SenGupta — Wed, 10 Oct 2018 08:18:07 GMT

Use simple Copy\Paste OR Export using XML Workspace documents.....that will copy everything you needed.

Re: Copy SDE geodatabase (source; enterprise geodatabase, destination; enterprise geodatabase)

EduardoAbreu-Freire — Wed, 10 Oct 2018 09:24:16 GMT

Thank you for the suggestion. My hard situation came up because I was told not to reconcile due to editions we are working on and was having problems with old domains in some tables so did a DB restore and backup on the server side but since we are working on a single instance could not use the same name for the "clone" DB and then have faced the problem of not able to connect ArcGIS to that DB. We have cleaning tables and domains I was able to export as XML.

Re: Copy SDE geodatabase (source; enterprise geodatabase, destination; enterprise geodatabase)

George_Thompson — Wed, 10 Oct 2018 11:31:28 GMT

That is understandable but there are limited options in that instance.

Re: Copy SDE geodatabase (source; enterprise geodatabase, destination; enterprise geodatabase)

BugPie — Mon, 21 Jan 2019 20:23:36 GMT

Don't mind me jumping in mid thread here. I am trying to understand if I can

Restore a backup enterprise gdb with a new name to the same instance
Work on the gdb via SSMS tools. Mainly removing views and linked server
backup e gdb with new name / Remove existing e gdb
Restore e gdb with original name
Connect

Is there something when changing the name temporarily that will corrupt my egdb or is it just connecting via Arc with new name that doesn't work?

I need to do some basic db operations outside of Arc. Any idea if the concept of having a temp name , workign within SQL will work in this scenario?

Re: Copy SDE geodatabase (source; enterprise geodatabase, destination; enterprise geodatabase)

Asrujit_SenGupta — Tue, 22 Jan 2019 04:06:39 GMT

Yes, that should work.

But I am assuming, that you are not going to drop Views which are Registered with the Geodatabase.

Its just connecting via, that won't work. Otherwise it won't corrupt anything.