The other day something happened that caused the insert part of me running the SQL Azure Migration Wizard to abort, leaving me with a bunch of local .dat files and no data on my destination server.
To upload the data, you need to run the following command:
bcp database.dbo.tablename in dbo.tablename.dat -n -U username -P password -S remote.server.address.com -b 200 -h"TABLOCK"
You can play with various values for -b, the batch size. I found 200 worked reasonably although I didn’t investigate too much.