Copy Data from Existing DAT files

Apr 14, 2014 at 4:24 PM
Edited Apr 14, 2014 at 4:25 PM
I have a folder of .dat files. I want to tell MW to copy the data from the dat files to AzureSQL. I do not have the script that created the 200 bcp command lines that I need. What do you suggest on how I might do this?
Apr 15, 2014 at 3:23 PM

What I would suggest is that you let SQLAzureMW export the data again and create the BCP commands. Just select your database and under the Advanced option, find "Script Table / Data" and set it to "Data Only". You should have everything that you need and then you can upload.

The other way would be to create the BCP commands by hand and put the commands in a batch file. Then run from a command prompt.

Apr 15, 2014 at 4:01 PM
Thank you George, for that guidance and the great tool you have created.