Exporting table to sde
2785
3
11-04-2015 09:59 PM
by
by
by
Hi Nigel,
I only had about 20 minutes to actually test this out today so I'm going to update you with my assumptions based on what I've seen so far. I'm thinking that there may be a bigger problem at play here. Everything works fine for me when I output the tables to a file geodatabase. When I change the output workspace to an enterprise geodatabase thing begin to fail.
I ran a quick test in ArcMap and the Table to Geodatabaase tool is also failing there when the output workspace is an enterprise geodatabase. I'm not sure if there is something wrong with my enterprise geodatabase or if the tool is having a problem with the sde naming conventions.
I've pasted the code I used to test below. You should be able to modify it and test it on your machine. Could you let me know if you're able to get the Table To Geodatabase tool to work from ArcMap?
using System;
using System.Collections.Generic;
using ESRI.ArcGIS.ConversionTools;
using ESRI.ArcGIS.DataManagementTools;
using ESRI.ArcGIS.esriSystem;
using ESRI.ArcGIS.Geodatabase;
using ESRI.ArcGIS.Geoprocessing;
using ESRI.ArcGIS.Geoprocessor;
using Path = System.IO.Path;
namespace TransportTable
{
class Program
{
private static readonly LicenseInitializer m_aoInit = new LicenseInitializer();
private static readonly Dictionary<string, string> m_connProps = new Dictionary<string, string>
{
{"SERVER", "uzumaki"},
{"INSTANCE", @"sde:sqlserver:uzumaki\express2014"},
{"DBCLIENT", "SQLSERVER"},
{"DATABASE", "gdb"},
{"AUTHENTICATION_MODE", "DBMS"},
{"USER", "sde"},
{"PASSWORD", "sde"},
{"VERSION", "sde.DEFAULT"}
};
static readonly string m_gdbPath = Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments), @"ArcGIS\Default.gdb");
const string m_tblName = "MyCitiez";
static readonly string m_gdbPathOut = Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.Desktop), "MyGDBData.gdb");
static readonly string m_sdePathOut = Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.Desktop), "ConnToSDE.sde");
[STAThread()]
static void Main(string[] args)
{
//ESRI License Initializer generated code.
m_aoInit.InitializeApplication(new [] { esriLicenseProductCode.esriLicenseProductCodeAdvanced }, new esriLicenseExtensionCode[] { });
var in_ws = OpenWorkspace(m_gdbPath) as IFeatureWorkspace;
var table = in_ws.OpenTable(m_tblName);
var outGdbWs = OpenWorkspace(m_gdbPathOut);
var outSdeWs = OpenWorkspace(m_connProps);
foreach (var workspace in new [] {outGdbWs, outSdeWs})
{
foreach (var workflow in new [] {Workflow.UseObjects, Workflow.UseStrings})
{
Console.WriteLine("WORKSPACE IS {0} AND WORKFLOW USES {1}", workspace.WorkspaceFactory.WorkspaceType, workflow == Workflow.UseObjects ? "OBJECTS" : "STRINGS");
ExportToTable(table, workspace, workflow);
}
}
Console.WriteLine();
Console.Write("Press enter to exit...");
Console.ReadLine();
//ESRI License Initializer generated code.
//Do not make any call to ArcObjects after ShutDownApplication()
m_aoInit.ShutdownApplication();
}
private static void ExportToTable(ITable inTable, IWorkspace outWorkspace, Workflow workflow)
{
var fws = outWorkspace as IFeatureWorkspace;
if ((outWorkspace as IWorkspace2).NameExists[esriDatasetType.esriDTFeatureClass, (inTable as IDataset).BrowseName])
{
var table = fws.OpenTable((inTable as IDataset).BrowseName) as IDataset;
if (table.CanDelete())
table.Delete();
}
Geoprocessor gp = new Geoprocessor {OverwriteOutput = true};
try
{
TableToGeodatabase tool;
//TableToTable tool;
if (workflow == Workflow.UseStrings)
{
Console.WriteLine("*** USING OBJECTS ***");
tool = new TableToGeodatabase
{
Input_Table = inTable,
Output_Geodatabase = fws
};
//tool = new TableToTable
//{
// in_rows = inTable,
// out_path = workspace,
// out_name = (inTable as IDataset).BrowseName
//};
}
else
{
Console.WriteLine("*** USING STRINGS ***");
var tuul = new CreateDatabaseConnection
{
out_folder_path = Path.GetDirectoryName(m_sdePathOut),
out_name = Path.GetFileName(m_sdePathOut),
database_platform = "SQL_SERVER",
instance = m_connProps["INSTANCE"],
account_authentication =
m_connProps["AUTHENTICATION_MODE"] == "DBMS" ? "DATABASE_AUTH" : "OPERATING_SYSTEM_AUTH",
username = m_connProps["USER"],
password = m_connProps["PASSWORD"],
save_user_pass = "SAVE_USERNAME",
database = m_connProps["DATABASE"],
version = m_connProps["VERSION"]
};
var rezult = gp.Execute(tuul, null) as IGeoProcessorResult2;
gp.ClearMessages();
tool = new TableToGeodatabase
{
Input_Table =
string.Format(@"{0}\{1}", (inTable as IDataset).Workspace.PathName,
(inTable as IDataset).BrowseName),
Output_Geodatabase =
outWorkspace.WorkspaceFactory.WorkspaceType == esriWorkspaceType.esriLocalDatabaseWorkspace
? outWorkspace.PathName
: rezult.GetOutput(0).GetAsText()
};
//tool = new TableToTable
//{
// in_rows = string.Format(@"{0}\{1}", (inTable as IDataset).Workspace.PathName, (inTable as IDataset).BrowseName),
// out_path = rezult.GetOutput(0).GetAsText(),
// out_name = (inTable as IDataset).BrowseName
//};
}
var result = gp.Execute(tool, null) as IGeoProcessorResult2;
Console.WriteLine(result.GetMessages(0));
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
object sev = 2;
Console.WriteLine(gp.GetMessages(ref sev));
}
finally
{
Console.WriteLine("");
Console.WriteLine("##############################");
Console.WriteLine("");
}
}
private static IWorkspace OpenWorkspace(string wsPath)
{
var factoryType = Type.GetTypeFromProgID("esriDataSourcesGDB.FileGdbWorkspaceFactory");
var wsFactory = Activator.CreateInstance(factoryType) as IWorkspaceFactory;
if (System.IO.Directory.Exists(wsPath))
return wsFactory.OpenFromFile(wsPath, 0);
var wsName = wsFactory.Create(Path.GetDirectoryName(wsPath), Path.GetFileName(wsPath), null, 0);
var name = wsName as IName;
return name.Open() as IWorkspace;
}
private static IWorkspace OpenWorkspace(Dictionary<string, string> ConnProps)
{
var factoryType = Type.GetTypeFromProgID("esriDataSourcesGDB.SdeWorkspaceFactory");
var wsFactory = Activator.CreateInstance(factoryType) as IWorkspaceFactory;
var propset = new PropertySetClass();
foreach (var prop in ConnProps)
propset.SetProperty(prop.Key, prop.Value);
return wsFactory.Open(propset, 0);
}
}
enum Workflow
{
UseStrings,
UseObjects
}
}
by
