I've been looking at the tool with a view to migrating our DB to Sql Azure and am pretty happy with it. Good job, and sure beats the hell out of the procedure recommended in MSDN
However, I would like to be able to customize the output path of the BCP files that are generated, as they seem to be building in my AppData\Local\Temp folder with randomly generated names. It would be great if I could specify the output
location and filename format (eg c:\Migration\Mytable.bcp c:\Migration\AnotherTable.bcp for tables called MyTable and AnotherTable)
I have a number of very large tables that I would like to generate BCP files for, but during migration testing I would like to trim the tables down to a managable size and genereate BCP files for the trimmed tables. This will allow me to test the migration
end to end in a speedy manner, and then simply swap in the actual BCP files when I want to run the migration for real when the rest of the app has been migrated.
Additionally, having the BCP files use a known name and location will allow me to checkin the trimmed BCP files in version control so that other developers in our team can run the migration against their own Sql azure instance without taking hours
to run the import