从一个表读取并插入另一个表 - 一次一行

I am dealing with a huge database with millions of rows. I would like to run an SQL statement through C#, which selects 1.2 million rows from one database, and inserts them into another after parsing and modifying some data.I am dealing with a huge database with millions