topic Backup creates duplicates in Python Questions

Backup creates duplicates

TonyAlmeida — Fri, 17 May 2013 16:39:41 GMT

I have created a Geodatabase backup script for my sql geodatabase. Everything runs fine, except for it creates duplicates and adds a 1, 2 ,3 onto the end and i just want it to replace over it. What am I missing?

Here is my current code

import arcpy from arcpy import env   arcpy.env.overwriteOutput = True env.workspace = "C:\Temp\CCAP.gdb"   CCAP = r'Database Servers\DSD15_SQLEXPRESS.gds\TonyTwoWay (VERSION:dbo.DEFAULT)\TonyTwoWay.DBO.CCAP' CCAP2 = "C:\Temp\CCAP.gdb"   arcpy.FeatureClassToGeodatabase_conversion(CCAP, CCAP2)

Re: Backup creates duplicates

ChrisSnyder — Fri, 17 May 2013 21:48:01 GMT

Not sure why it's creating dulplicates, but I would either:

1. Delete the existing FGDB, before you run the FeatureClassToGeodatabase tool.
or
2. Create a FGDB, and then run the CopyFeatures tool.

Re: Backup creates duplicates

TonyAlmeida — Sat, 11 Dec 2021 23:45:55 GMT

I added arcpy.Delete_management to my code but it still creates duplicates...

import arcpy
from arcpy import env
import os

arcpy.env.overwriteOutput = True
env.workspace = "C:\Temp\CCAP.gdb"

TonyTwoWay_DBO_CCAP = "C:\Temp\CCAP.gdb\TonyTwoWay.DBO.CCAP"
if arcpy.Exists(TonyTwoWay_DBO_CCAP):           
    arcpy.Delete_management("C:\Temp\CCAP.gdb\TonyTwoWay_DBO_CCAP")

CCAP = r'Database Servers\DSD15_SQLEXPRESS.gds\TonyTwoWay (VERSION:dbo.DEFAULT)\TonyTwoWay.DBO.CCAP'
CCAP2 = "C:\Temp\CCAP.gdb"


arcpy.FeatureClassToGeodatabase_conversion(CCAP, CCAP2)

Re: Backup creates duplicates

ChrisSnyder — Sat, 11 Dec 2021 23:45:58 GMT

Actually I meant delete the FGDB. For example:

import arcpy, os
arcpy.env.overwriteOutput = True
arcpy.env.workspace = "C:\Temp\CCAP.gdb"
TonyTwoWay_DBO_CCAP = "C:\Temp\CCAP.gdb\TonyTwoWay.DBO.CCAP"
CCAP = r'Database Servers\DSD15_SQLEXPRESS.gds\TonyTwoWay (VERSION:dbo.DEFAULT)\TonyTwoWay.DBO.CCAP'
CCAP2 = "C:\Temp\CCAP.gdb"
if arcpy.Exists(CCAP2):           
    arcpy.Delete_managementCCAP2)
arcpy.FeatureClassToGeodatabase_conversion(CCAP, CCAP2)

Re: Backup creates duplicates

TonyAlmeida — Sat, 11 Dec 2021 23:46:00 GMT

Thanks for the replies. I have added delete FGDB and create file GDB and but it seems as my input features are not supported.
I would still just like to replace it instead of deleting the FGDB.

Traceback (most recent call last):
File "C:\GIS\Python\BackupCCAP.py", line 20, in <module>
arcpy.FeatureClassToGeodatabase_conversion(CCAP, CCAP2)
File "C:\Program Files (x86)\ArcGIS\Desktop10.1\arcpy\arcpy\conversion.py", line 1569, in FeatureClassToGeodatabase
raise e
ExecuteError: Failed to execute. Parameters are not valid.
ERROR 000732: Input Features: Dataset 'Database Servers\DSD15_SQLEXPRESS.gds\TonyTwoWay (VERSION:dbo.DEFAULT)\TonyTwoWay.DBO.CCAP' does not exist or is not supported
Failed to execute (FeatureClassToGeodatabase).

my current code

import arcpy
from arcpy import env
import os
from datetime import datetime as d
startTime = d.now()

arcpy.env.overwriteOutput = True
arcpy.env.workspace = "C:\Temp\CCAP.gdb"

TonyTwoWay_DBO_CCAP = "C:\Temp\CCAP.gdb\TonyTwoWay.DBO.CCAP"
CCAP = r'Database Servers\DSD15_SQLEXPRESS.gds\TonyTwoWay (VERSION:dbo.DEFAULT)\TonyTwoWay.DBO.CCAP'
CCAP2 = "C:\Temp\CCAP.gdb"

if arcpy.Exists(CCAP2):
    arcpy.Delete_management(CCAP2)


arcpy.CreateFileGDB_management("C:\Temp", "CCAP.gdb")

arcpy.FeatureClassToGeodatabase_conversion(CCAP, CCAP2)

try:
    print '(Elapsed time: ' + str(d.now() - startTime)[:-3] + ')'

except Exception, e:
    # If an error occurred, print line number and error message
    import traceback, sys
    tb = sys.exc_info()[2]
    print "Line %i" % tb.tb_lineno
    print e.message

Re: Backup creates duplicates

TonyAlmeida — Sat, 11 Dec 2021 23:46:03 GMT

This seems to work, but i would like to just replace the featureclass...

import arcpy
from arcpy import env
import os
from datetime import datetime as d
startTime = d.now()

arcpy.env.overwriteOutput = True
arcpy.env.workspace = "C:\Temp\CCAP.gdb"

TonyTwoWay_DBO_CCAP = "C:\Temp\CCAP.gdb\TonyTwoWay.DBO.CCAP"
CCAP = r'Database Servers\DSD15_SQLEXPRESS.gds\TonyTwoWay (VERSION:dbo.DEFAULT)\TonyTwoWay.DBO.CCAP'
CCAP2 = "C:\Temp\CCAP.gdb"

if arcpy.Exists(CCAP2):
    arcpy.Delete_management(CCAP2)


arcpy.CreateFileGDB_management("C:\Temp", "CCAP.gdb")

arcpy.FeatureClassToGeodatabase_conversion(CCAP, CCAP2)

try:
    print '(Elapsed time: ' + str(d.now() - startTime)[:-3] + ')'

except Exception, e:
    # If an error occurred, print line number and error message
    import traceback, sys
    tb = sys.exc_info()[2]
    print "Line %i" % tb.tb_lineno
    print e.message

Re: Backup creates duplicates

ChrisSnyder — Mon, 20 May 2013 17:31:52 GMT

That tool you are using (arcpy.FeatureClassToGeodatabase_conversion) is a bit "weird" in that it attempts to do multiple things at once - create a Geodatabase and then copy featureclasses to it. You might have better luck by being more explicit in what you want to do in your workflow, so for example:

1. Create a FGDB
2. Copy your features to it using the CopyFeatures tool.

Perhaps you can add some logic as to what to do if these items already exists.

Not sure why arcpy.env.overwriteOutput = True isn't working properly for you. Do you have a lock on the FC or FGDB?

Re: Backup creates duplicates

TonyAlmeida — Sat, 11 Dec 2021 23:46:06 GMT

Adding the logic on what to do if the items exsits worked. Thanks

import arcpy
from arcpy import env
import os
from datetime import datetime as d
startTime = d.now()

arcpy.env.overwriteOutput = True
arcpy.env.workspace = "C:\Temp\CCAP.gdb"

TonyTwoWay_DBO_CCAP = "C:\Temp\CCAP.gdb\TonyTwoWay.DBO.CCAP"
CCAP = r'Database Servers\DSD15_SQLEXPRESS.gds\TonyTwoWay (VERSION:dbo.DEFAULT)\TonyTwoWay.DBO.CCAP'
CCAP2 = "C:\Temp\CCAP.gdb"

CCAP3 = "C:\Temp\CCAP.gdb\TonyTwoWay_DBO_CCAP"

if arcpy.Exists(CCAP3):
    arcpy.Delete_management(CCAP3)

arcpy.FeatureClassToGeodatabase_conversion(CCAP, CCAP2)

try:
    print '(Elapsed time: ' + str(d.now() - startTime)[:-3] + ')'

except Exception, e:
    # If an error occurred, print line number and error message
    import traceback, sys
    tb = sys.exc_info()[2]
    print "Line %i" % tb.tb_lineno
    print e.message