One of the reasons that SQL Azure is such a powerful tool is that it's based on the same database engine as SQL Server. For example, you can connect to the Microsoft SQL Azure Database with the sqlcmd command prompt utility that is included with SQL Server. The sqlcmd utility lets you enter Transact-SQL statements, system procedures, and script files at the command prompt. MSDN has written a tutorial on how to do this. Take a look and get a feel for how easy it is to get started using SQL Azure.
Click here for the MSDN article
Is there any adapter available in order to connect from Biztalk 2010 to SQL Azure?
Hi, @Biztalk to SQL Azure: “I asked this to some of my peers within Microsoft, and they pointed me to these articles…”
You can certainly do it with the WCF-SQL adapter (with no DTC as Andreas points out), both from a BizTalk project:
and from code using the WCF-SQL adapter:
Thanks for greate links and quick response, we will give it a go and see if it works.
Nil - great! good luck.