BCP from SQL Azure

Question

Hi All,

I am trying to BCP out from SQL Azure and found that BCP command doesnt take SQL Database name as a parameter and SQL Azure doesn;t like my Database.Schema.Table notations. Any ways to get through.

---

Thanks, Loonysan | http://mystutter.blogspot.com

Answer 1

Hello

BCP Out should work fine.

Here's a sample:

bcp database.dbo.Table out C:\Temp\testfile.dat -S server.windows.database.net -U admin@server -P pass@word

Answer 2

FYI - QueryOut option with SQL Azure doesn't work - Might have to wait for the next release !!!

---

Thanks, Loonysan | http://mystutter.blogspot.com

Answer 3

Any guess on why this error is produced while trying to BCP out from SQL Azure?

 

SQLState = S1000, NativeError = 0
Error = [Microsoft][SQL Server Native Client 10.0]Unable to open BCP host data-f
ile

---

mysorian

Answer 4

Did you get this to work?

 

---

mysorian

Answer 5

You need to use

tcp:serrvername.database.windows.net

and

username like in username@servername

 

Dinakar's command will not work

---

mysorian

Answer 6

Hi Jayaram

The sample code I posted should work. Are you seeing any errors?

Answer 7

As I said earlier you need to use tcp: ahead of server.database.windows.net otherwise in Windows 7 you would get a tcp/ip related error. SQL Azure works thru' tcp.

And the username should be usrname@servername

Otherwise your code will work.

You may need to add the option -w if you are intereseted in getting the output in recognizable ascii.

---

mysorian

Answer 8

Hi Jayaram

Your username has to be in the format login@server (as I mentioned in my original reply) however the server name does not have to be prefixed with "tcp:".

Answer 9

Thank you

---

Need Help

Answer 10

Hi Jayaram

Your username has to be in the format login@server (as I mentioned in my original reply) however the server name does not have to be prefixed with "tcp:".

Many thanks. It does work.