locked
How do I bcp from development storage? RRS feed

  • Question

  • Hi,

    I´ve found some tutorials how to download or upload data from cloud using bcp, but they all were about real cloud storage.

    bcp TestDB.dbo.Customer in "C:\Users\cesardl\Desktop\Arquitectura Marco .NET DPE Spain\_Windows Azure V\BCP\Customer.txt" -c -U mysqlazureuser@mysqlazureservername -S tcp:mysqlazureservername.database.windows.net -P mypassword

    How can I do something like this but on my local development storage?

     

    It actually doesn´t have to be BCP, if there´s other way how to copy data from local development storage to SQL server it would be helpful too.

    Friday, October 15, 2010 8:12 AM

Answers

  • I'm not sure if this would help but we released a utility in public beta earlier this week which has some PowerShell Cmdlets to download table data from Windows Azure Storage (and Development Storage) as well in CSV format. You can learn more about it on our website @ http://www.cerebrata.com/Products/AzureManagementCmdlets . May be you can use these cmdlets to download the table data in CSV format & then upload this CSV data in SQL Server. Once you're done with the analysis with data in SQL Server, you can upload the data back in Azure Table Storage (we don't have a cmdlet for that at this time) however we do have this capability in our other product Cloud Storage Studio where it can take data from SQL Server (or MySQL), flatten it and then upload it in Azure Table Storage. You can learn more about it on our website @ http://www.cerebrata.com/Products/CloudStorageStudio .

    Hope this helps.

    Thanks

    Gaurav

    • Marked as answer by Brad Calder Sunday, March 27, 2011 12:49 AM
    Friday, October 15, 2010 12:43 PM

All replies

  • Hi,

    When you say your local development storage, do you mean "local development storage" for Windows Azure (which gets installed as a part of SDK) or a local SQL Server? Can you describe your problem in somewhat more details?

    Thanks

    Gaurav Mantri

    Cerebrata Software

    http://www.cerebrata.com

     

    Friday, October 15, 2010 11:35 AM
  • Hello Gaurav,

    by local development storage I mean Azure storage which is part of SDK.

    The point is that I have to show benefits of Windows azure and my task is simulate mobile client, which uploads data to cloud storage and these data are later downloaded to our local SQL servers where are further processed.

    And I want to do this thing locally, so I run mobile client in emulator, it uploades data to my Azure development storage and I need download these data to another SQL server, process them, store into antoher table of local SQL server and send this new table back do Azure development storage.

    Here´s a simple picture of what I´m trying to do

    http://img100.imageshack.us/img100/9711/azure.png

    Friday, October 15, 2010 12:11 PM
  • I'm not sure if this would help but we released a utility in public beta earlier this week which has some PowerShell Cmdlets to download table data from Windows Azure Storage (and Development Storage) as well in CSV format. You can learn more about it on our website @ http://www.cerebrata.com/Products/AzureManagementCmdlets . May be you can use these cmdlets to download the table data in CSV format & then upload this CSV data in SQL Server. Once you're done with the analysis with data in SQL Server, you can upload the data back in Azure Table Storage (we don't have a cmdlet for that at this time) however we do have this capability in our other product Cloud Storage Studio where it can take data from SQL Server (or MySQL), flatten it and then upload it in Azure Table Storage. You can learn more about it on our website @ http://www.cerebrata.com/Products/CloudStorageStudio .

    Hope this helps.

    Thanks

    Gaurav

    • Marked as answer by Brad Calder Sunday, March 27, 2011 12:49 AM
    Friday, October 15, 2010 12:43 PM
  • Thanks for reply, I´ll try it for sure. I already have cloud storage studio and I was surprised that someone from company which created it replied to me (: ( in good way of course ). It´s really usefull tool, but I want to automatize whole proces ( without GUI tools that CSS provides )

    Friday, October 15, 2010 1:14 PM