Using c# to move data from one sql server to another.

Question

We just redesigned, and rewrote, our application with brand new designed database schema. My next job is to write c# code that will convert and move the data from the old database to the new database. . I'm a simple man. I just want to read the data, massage the data to convert it to the new tables' format, and insert the data into the new database. .  The system architech wants to use reflection, POCO, Json and maybe even a dictionary to do this. I'm asking myself why make this so complicated? I don't even know if I know how to do what he wants. Can someone give me a hint of what the architech is talking about?    Thank you.

Amit Gupta · Answer

Json is widely used and can be easily travel over the web, it can be used for building API and for exporting there were several ways to achieve.

Vinay Singh · Answer

Hi Please check the below link https://www.youtube.com/watch?v=nNT1blpxvR4  https://www.c-sharpcorner.com/article/bulk-copy-operations-in-ado-net-2-0/ https://docs.microsoft.com/en-us/dotnet/framework/data/adonet/sql/multiple-bulk-copy-operations?redirectedfrom=MSDN