1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112
|
using System;
using System.Collections.Generic;
using System.Text;
using System.Data.SqlClient;
using System.Data;
namespace Transfert1
{
class Program
{
static void Main(string[] args)
{
string connectionStringSource = "Data Source=SRVSQL2;Initial Catalog=ATE_Results;Persist Security Info=True;User ID=yy;Password=xxx";
string connectionStringDestination = "Data Source=SRVSQL2\\DEV;Initial Catalog=ATE_Results;Persist Security Info=True;User ID=yy;Password=xxx";
SqlConnection connectionSource = new SqlConnection(connectionStringSource);
SqlConnection connectionDestination = new SqlConnection(connectionStringDestination);
using (connectionSource)
{
SqlCommand command = new SqlCommand("SELECT * from dbo.Result;",connectionSource);
connectionSource.Open();
SqlDataReader reader = command.ExecuteReader();
string str = @"insert into dbo.Result(idsResult,idsATE,strConfiguration,strWorkOrder,strTestStage,lngLapPass,lngLapFail,
lngCycleCount,lngCycleFail,lngCycleFailCriteria,lngCyclePass,lngCyclePassCriteria,
lngCyclePassBegin,
lngCyclePassBeginCriteria,lngCyclePassEnd,lngCyclePassEndCriteria)
VALUES(@a, @b, @c, @d, @e, @f, @g, @h, @i, @j, @k, @l, @m, @n,@o, @p)";
connectionDestination.Open();
SqlCommand sqlCommand = new SqlCommand(str, connectionDestination);
sqlCommand.Parameters.Add("@a", SqlDbType.Int);
sqlCommand.Parameters.Add("@b", SqlDbType.Int);
sqlCommand.Parameters.Add("@c", SqlDbType.NVarChar,255);
sqlCommand.Parameters.Add("@d", SqlDbType.NVarChar,50);
sqlCommand.Parameters.Add("@e", SqlDbType.NVarChar,50);
sqlCommand.Parameters.Add("@f", SqlDbType.Int);
sqlCommand.Parameters.Add("@g", SqlDbType.Int);
sqlCommand.Parameters.Add("@h", SqlDbType.Int);
sqlCommand.Parameters.Add("@i", SqlDbType.Int);
sqlCommand.Parameters.Add("@j", SqlDbType.Int);
sqlCommand.Parameters.Add("@k", SqlDbType.Int);
sqlCommand.Parameters.Add("@l", SqlDbType.Int);
sqlCommand.Parameters.Add("@m", SqlDbType.Int);
sqlCommand.Parameters.Add("@n", SqlDbType.Int);
sqlCommand.Parameters.Add("@o", SqlDbType.Int);
sqlCommand.Parameters.Add("@p", SqlDbType.Int);
try
{
sqlCommand.Prepare();
}
catch (Exception e)
{
Console.WriteLine(e.ToString());
}
// Call Read before accessing data.
while (reader.Read())
{
sqlCommand.Parameters["@a"].Value = Convert.ToInt16(reader[0]);
sqlCommand.Parameters["@b"].Value = Convert.ToInt16(reader[1]);
sqlCommand.Parameters["@c"].Value = reader[2];
sqlCommand.Parameters["@d"].Value = reader[3];
sqlCommand.Parameters["@e"].Value = reader[4];
sqlCommand.Parameters["@f"].Value = Convert.ToInt16(reader[5]);
sqlCommand.Parameters["@g"].Value = Convert.ToInt16(reader[6]);
if (reader[7] != System.DBNull.Value)
{
sqlCommand.Parameters["@h"].Value = Convert.ToInt16(reader[7]);
}
else
{
sqlCommand.Parameters["@h"].Value = null;
}
sqlCommand.Parameters["@i"].Value = Convert.ToInt16(reader[8]);
sqlCommand.Parameters["@j"].Value = Convert.ToInt16(reader[9]);
sqlCommand.Parameters["@k"].Value = Convert.ToInt16(reader[10]);
sqlCommand.Parameters["@l"].Value = Convert.ToInt16(reader[11]);
sqlCommand.Parameters["@m"].Value = Convert.ToInt16(reader[12]);
sqlCommand.Parameters["@n"].Value = Convert.ToInt16(reader[13]);
sqlCommand.Parameters["@o"].Value = Convert.ToInt16(reader[14]);
sqlCommand.Parameters["@p"].Value = Convert.ToInt16(reader[15]);
try
{
sqlCommand.ExecuteNonQuery();
}
catch (SqlException sqlEx)
{
Console.WriteLine(sqlEx.ToString());
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
}
}
reader.Close();
} |
Partager