Copy Data from Existing DAT files

Apr 14 at 4:24 PM
Edited Apr 14 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?
Coordinator
Apr 15 at 3:23 PM
Hi,

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.

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