public long BulkCopy(string pNomeTabela, string pSqlCommand, BulkConfig pBulkConfig)
{
_rowsCopied = 0;
try
{
using (var reader = (SqlDataReader)ConnectSource.ExecuteReader(pSqlCommand))
{
if (reader.HasRows)
{
using (var bulkCopy = new SqlBulkCopy(ConnectTarget.Connection, pBulkConfig.Options, null))
{
bulkCopy.SqlRowsCopied += BulkCopy_SqlRowsCopied;
bulkCopy.NotifyAfter = 1;
bulkCopy.BulkCopyTimeout = pBulkConfig.CopyTimeout;
bulkCopy.BatchSize = pBulkConfig.BatchSize;
bulkCopy.DestinationTableName = pNomeTabela;
bulkCopy.WriteToServer(reader);
}
}
reader.Close();
}
}
catch (Exception)
{
throw;
}
return(_rowsCopied);
}
public void Disconnect()
{
if (_connectSource != null)
{
ConnectSource.Disconnect();
}
if (_connectTarget != null)
{
ConnectTarget.Disconnect();
}
}
public Dictionary <string, string> GetTables()
{
DataSet ds = ConnectSource.ExecuteDataset(Properties.Resources.get_tables);
Dictionary <string, string> ret = new();
if (ds != null && ds.Tables.Count > 0)
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
ret.Add(dr[0].ToString(), dr[1].ToString());
}
}
return(ret);
}
public string GerarScriptInsert(string pNomeTabela)
{
IDataReader dr = null;
try
{
dr = ConnectSource.ExecuteReader(string.Format("SELECT * FROM {0} WITH(NOLOCK)", pNomeTabela));
string result = "";
string values;
string path = Path.Combine(AppDomain.CurrentDomain.BaseDirectory, @"Insert");
if (!Directory.Exists(path))
{
Directory.CreateDirectory(path);
}
path = Path.Combine(path, pNomeTabela + ".sql");
if (File.Exists(path))
{
File.Delete(path);
}
using (StreamWriter sw = new(path, false, Encoding.ASCII))
{
while (dr.Read())
{
values = "";
for (int i = 0; i < dr.FieldCount; i++)
{
if (!object.ReferenceEquals(dr[i], DBNull.Value))
{
values += "," + GetFormatDataValue(dr[i].GetType(), dr[i].ToString());
}
else
{
values += ", NULL";
}
}
if (result != "")
{
result += ", (" + values[1..] + ")" + Environment.NewLine;