SDE备份与还原

来源：互联网发布：全国地区编码 sql 编辑：程序博客网时间：2024/06/06 00:11

sde的备份与还原本可以通过ArcGIS的导出和导入XML工作空间文档来实现。但是由于数据质量和ArcGIS稳定性问题，在SDE数据库导出到XML过程中，会发生ArcGIS的崩溃，所以特写了以下两个脚本。

1.SDE的备份。通过将SDE数据库导出为GDB。

代码如下：

# -*- coding: utf-8 -*-import arcpyfrom arcpy import envtry:    arcpy.CreateFileGDB_management("D:/","SDEPrepare.gdb","CURRENT")    if isinstance("D:/SDEPrepare.gdb<GDB>Create Succeed",unicode):        print ("D:/SDEPrepare.gdb<GDB>Create Succeed").encode('gb2312')    else:        print ("D:/SDEPrepare.gdb<GDB>Create Succeed").decode('utf-8').encode('gb2312')except Exception as inst:    if isinstance("D:/SDEPrepare.gdb<GDB>Create Failed",unicode):        print ("D:/SDEPrepare.gdb<GDB>Create Failed").encode('gb2312')    else:        print ("D:/SDEPrepare.gdb<GDB>Create Failed").decode('utf-8').encode('gb2312')env.workspace="数据库连接/Connection to tjch3650m31.sde"fcs=arcpy.ListFeatureClasses("*")for fc in fcs:    try:        arcpy.FeatureClassToGeodatabase_conversion(fc,"D:/SDEPrepare.gdb")        if isinstance(fc+"<FeatureClass>Import Succeed",unicode):            print (fc+"<FeatureClass>Import Succeed").encode('gb2312')        else:            print (fc+"<FeatureClass>Import Succeed").decode('utf-8').encode('gb2312')    except Exception as inst:        if isinstance(fc+"<FeatureClass>Import Failed",unicode):            print (fc+"<FeatureClass>Import Failed").encode('gb2312')        else:            print (fc+"<FeatureClass>Import Failed").decode('utf-8').encode('gb2312')print "游离的要素类导入成功"datasetList= arcpy.ListDatasets("*", "All")for dataset in datasetList:    try:        arcpy.CreateFeatureDataset_management("D:/SDEPrepare.gdb",dataset.split('.')[1])        if isinstance(dataset+"<Dataset>Create Succeed",unicode):            print (dataset+"<Dataset>Create Succeed").encode('gb2312')        else:            print (dataset+"<Dataset>Create Succeed").decode('utf-8').encode('gb2312')        env.workspace=u"数据库连接/Connection to wl05031.sde"+"//"+dataset        dsfcs=arcpy.ListFeatureClasses("*")        for dsfc in dsfcs:            try:                arcpy.FeatureClassToGeodatabase_conversion(dsfc,"D:/SDEPrepare.gdb"+"/"+dataset.split('.')[1])                if isinstance(dsfc+"<FeatureClass>Import Succeed",unicode):                    print (dsfc+"<FeatureClass>Import Succeed").encode('gb2312')                else:                    print (dsfc+"<FeatureClass>Import Succeed").decode('utf-8').encode('gb2312')            except Exception as inst:                if isinstance(dsfc+"<FeatureClass>Import Failed",unicode):                    print (dsfc+"<FeatureClass>Import Failed").encode('gb2312')                else:                    print (dsfc+"<FeatureClass>Import Failed").decode('utf-8').encode('gb2312')        if isinstance(dataset+"<Dataset>Import Succeed",unicode):            print (dataset+"<Dataset>Import Succeed").encode('gb2312')        else:            print (dataset+"<Dataset>Import Succeed").decode('utf-8').encode('gb2312')    except Exception as inst:        if isinstance(dataset+"<Dataset>Create Failed",unicode):            print (dataset+"<Dataset>Create Failed").encode('gb2312')        else:            print (dataset+"<Dataset>Create Failed").decode('utf-8').encode('gb2312')print "Complete SDE DB Prepared in D:/DBPrepare.gdb. Please Notice the Message"

图片如下：

2.SDE还原。通过将GDB导入到SDE。

代码如下：

# -*- coding: utf-8 -*-import os.pathimport arcpyfrom arcpy import envinputGDB = "D:/SDEPrepare.gdb"if(os.path.exists(inputGDB)!=True):    print inputGDB+" Not Found"    exitsdepath=u"数据库连接/Connection to wl05031.sde"env.workspace="D:/SDEPrepare.gdb"fcs=arcpy.ListFeatureClasses("*")for fc in fcs:    try:        #arcpy.FeatureClassToGeodatabase_conversion(fc,sdepath)        if isinstance(fc+"<FeatureClass>Import Succeed",unicode):            print (fc+"<FeatureClass>Import Succeed").encode('gb2312')        else:            print (fc+"<FeatureClass>Import Succeed").decode('utf-8').encode('gb2312')    except Exception as inst:        if isinstance(fc+"<FeatureClass>Import Failed",unicode):            print (fc+"<FeatureClass>Import Failed").encode('gb2312')        else:            print (fc+"<FeatureClass>Import Failed").decode('utf-8').encode('gb2312')print "游离的要素类导入成功"datasetList= arcpy.ListDatasets("*", "All")for dataset in datasetList:    try:        arcpy.CreateFeatureDataset_management(sdepath,dataset)        if isinstance(dataset+"<Dataset>Create Succeed",unicode):            print (dataset+"<Dataset>Create Succeed").encode('gb2312')        else:            print (dataset+"<Dataset>Create Succeed").decode('utf-8').encode('gb2312')        env.workspace=u"D:/SDEPrepare.gdb"+"//"+dataset        dsfcs=arcpy.ListFeatureClasses("*")        for dsfc in dsfcs:            try:                arcpy.FeatureClassToGeodatabase_conversion(dsfc,sdepath+"/"+dataset)                if isinstance(dsfc+"<FeatureClass>Import Succeed",unicode):                    print (dsfc+"<FeatureClass>Import Succeed").encode('gb2312')                else:                    print (dsfc+"<FeatureClass>Import Succeed").decode('utf-8').encode('gb2312')            except Exception as inst:                if isinstance(dsfc+"<FeatureClass>Import Failed",unicode):                    print (dsfc+"<FeatureClass>Import Failed").encode('gb2312')                else:                    print (dsfc+"<FeatureClass>Import Failed").decode('utf-8').encode('gb2312')        if isinstance(dataset+"<Dataset>Import Succeed",unicode):            print (dataset+"<Dataset>Import Succeed").encode('gb2312')        else:            print (dataset+"<Dataset>Import Succeed").decode('utf-8').encode('gb2312')    except Exception as inst:        if isinstance(dataset+"<Dataset>Create Failed",unicode):            print (dataset+"<Dataset>Create Failed").encode('gb2312')        else:            print (dataset+"<Dataset>Create Failed").decode('utf-8').encode('gb2312')print "Complete SDE DB recovered in "+sdepath+" .Please Notice the Message"

图片如下：

0 0