I have a table in a local MS SQL Server database that has 72 columns and over 8 million records. Most of the columns are floats except for the primary key which is an INT Identity column. The table also has 3 indexes.
These records are the saved output from a utility I wrote that processed around 100 Billion calculations on different target audiences. I have saved the best and worst results for each target audience for future lookup. I would now like to move all these records into my staging server's database.
What is the best way to copy transfer these records?
I tried Red Gate, and it just dies and says out of disk space. My disk has 22 GB free. Thanks.