I am facing difficulties migrating data from a table with 6 million rows to another table in a SQL Server database due to resource limitations. The database is relatively small, and when I send 100,000 rows at a time, the DTU usage spikes to 100%, which compromises the performance and stability of the system.