public static void Load(string ilrPath, string schema, string srvr, string db, string security, bool createTables)
{
var loader = new SQLXMLBulkLoad4();
loader.ConnectionString = $"Provider=sqloledb;Server={srvr};Database={db};{security};";
loader.ErrorLogFile = "LoadErrors.xml";
loader.KeepIdentity = false;
loader.SGDropTables = createTables;
loader.SchemaGen = createTables;
loader.Execute(schema, ilrPath);
}
private void LoadXmlToTempDb()
{
var objBL = new SQLXMLBulkLoad4
{
ConnectionString = temp_connStringPart,
ErrorLogFile = "error.xml",
SchemaGen = false,
SGDropTables = false,
};
foreach (var key in filesNamesMasks)
{
var schemePath = schemes[key];
var xmlPath = versionFiles[key];
objBL.Execute(schemePath, xmlPath);
}
}
