1
Vote

Silent Failure of BCP Upload when Azure SQL DB name contains a "."

description

All data successfully exports out of my MS SQL database - .dat files are generated and the SQL is created.

The database name was formatted as "XXXX.YY-AAAA1"

I connected to my Azure SQL server and selected the database (with the same name -- I created it by hand from the management interface in the Azure Management Portal) with no error. All the SQL statements themselves executed correctly - the schema was created. It reported that all BCP files had exported ALL their rows to the database - no errors.

The row export did NOT happen. I tried it in data-only mode as well. BCP seems to fail silently. I tried uploading the .dat files by hand and all I obtained was the message, "An error occurred while processing the command line".

I ended up just deleting the database and renaming it something without the period. It worked fine at that point.

comments

ghuey wrote Oct 17, 2012 at 12:26 AM

Wow, that is very interesting. I will see if I can replicate the issue. Thanks for the feedback. I hope the work around does not cause you too much pain.

Thanks again for the feedback.

Regards,
George

ghuey wrote Oct 17, 2012 at 6:34 PM

Hi,

Well bad news for me. I can't reproduce the problem. I created a database named [dbo].[XXXX.YY-AAAA1] and put 30 or so tables in with with data in each table. The export and import into SQL Database went well and all data got transfered. I hate to bother you, but if you could create a one or two table database that can repro the issue you reported and send it to me, that would be wonderful. If not, don't worry about it, I will keep this in mind and try different things until I find something. You can contabe me via codeplex if you are interested.

Thanks,
George

nate_leanserver wrote Oct 17, 2012 at 7:13 PM

Huh, okay. I'll get in contact with you George. Thanks.

Sign in to add a comment or to set email notifications