使用C#从SQL中检索数据并将所有数据重新插入到db中。

using System;
using System.Data.SqlClient;

class Program
{
    static void Main()
    {
        string connectionString = "Data Source=数据库服务器地址;Initial Catalog=数据库名称;User ID=用户名;Password=密码";
        
        using (SqlConnection connection = new SqlConnection(connectionString))
        {
            connection.Open();
            
            string selectQuery = "SELECT * FROM 表名";
            using (SqlCommand command = new SqlCommand(selectQuery, connection))
            {
                using (SqlDataReader reader = command.ExecuteReader())
                {
                    while (reader.Read())
                    {
                        // 读取每一行数据
                        // 根据需要进行数据处理
                        
                        // 插入数据到目标数据库
                        string insertQuery = "INSERT INTO 目标表名 (列1, 列2, 列3) VALUES (@Value1, @Value2, @Value3)";
                        using (SqlCommand insertCommand = new SqlCommand(insertQuery, connection))
                        {
                            insertCommand.Parameters.AddWithValue("@Value1", reader["列1"]);
                            insertCommand.Parameters.AddWithValue("@Value2", reader["列2"]);
                            insertCommand.Parameters.AddWithValue("@Value3", reader["列3"]);
                            
                            insertCommand.ExecuteNonQuery();
                        }
                    }
                }
            }
            
            connection.Close();
        }
        
        Console.WriteLine("数据检索和插入完成。");
    }
}