public void Process(string sourceConnectionString, string sourceTableName, string destinationConnectionString, string destinationTableName) { destinationTableName = Helper.GetDestinationTableName(destinationTableName); SqlConnectionStringBuilder sqlConnStrBldr = new SqlConnectionStringBuilder(destinationConnectionString); Ivfptosqlbulkcopy com = new vfptosqlbulkcopyClass(); com.SetPath(HostPath); String result = com.ProcessConversionActions(destinationTableName, sqlConnStrBldr.DataSource, sqlConnStrBldr.InitialCatalog); if (!String.IsNullOrEmpty(result)) { throw new Exception(result); } }
public void Process(string sourceConnectionString, string sourceTableName, string destinationConnectionString, string destinationTableName) { destinationTableName = Helper.GetDestinationTableName(destinationTableName); VfpConnectionStringBuilder vfpConnStrBldr = new VfpConnectionStringBuilder(sourceConnectionString); String vfpFileName = Path.Combine(vfpConnStrBldr.DataSource, Path.ChangeExtension(sourceTableName, "DBF")); SqlConnectionStringBuilder sqlConStrBldr = new SqlConnectionStringBuilder(destinationConnectionString); Ivfptosqlbulkcopy com = new vfptosqlbulkcopyClass(); String result = com.UploadMemos(vfpFileName, destinationTableName, sqlConStrBldr.DataSource, sqlConStrBldr.InitialCatalog); if (!String.IsNullOrEmpty(result)) { throw new Exception(result); } }