Uploading blob file to parse it and insert rows in sql azure

Question

For one subject in college I need to use Windows Azure. Notice that I am Java dev and a total newbie to Windows itself and cs.

My project is quite simple. I am going to do a Layar server.

I already have a Service which returs a mocked point of interest in json format. Now I would like to do my massive insert in the sql azure db to do spatial searches afterwards.

I was thinking of:

• Creating a cvs file with all rows.
• Upload it as blob.
• Parse it with a Worker role and insert it in the sql azure db.

Questions:

• Do you think this is the correct approach?
• Is cvs fine?
• What do you use for a massive insertion to sql azure?
• Is there a way to "Annotate" my model class to create an entity in my db? Should I do the mapping by hand?

Answer 1

There are various ways to import data into sql azure, here: http://blogs.msdn.com/b/sqlcat/archive/2010/07/30/loading-data-to-sql-azure-the-fast-way.aspx

You have basically the following options:

• SQL Server BCP Utility,
• SQL Server Integration Services (SSIS)
• Import and Export Data and SQL Server Studio (SSMS).
• Bulk Copy API