Once I got the initial data transfer up and running, I needed to place the whole thing into a transaction, I was doing multiple table transfers (with some data manipulation). I could not have half a database transferred, even if I did throw an error.
I simply threw in an SqlTransaction, and made everything run inside that.
However, I hit an exception when using the SqlCommandBuilder to create the insert command:
The task was straightforward, or so I thought; create a small application that transfers an applications configuration information from the test database into the production database
DataAdapter