Apologies, Azure newbie here.

We have a custom built ERP solution (currently installed with +50 clients).

Our architecture is based on a single database for each financial entity + a pointer database to tie them all together. Certain clients have many companies (meaning multiple databases). Financial reporting requires many cross database procedures.

All of our current clients run their own server infrastructure, but we're looking at some current opportunities where clients would like to offload this requirement to the cloud.

1. Am I correct in my understanding that Azure doesn't support any cross database joins or calls?

2. If so, can SQL server be configured so that it is exposed via an external IP address?

Many thanks :)

• Moved by benjaminperkinsMicrosoft employee Friday, January 30, 2015 10:30 AM The question is about SQL and not Azure Websites

Hi ReflexRob,

No need to apologize - thank you for reaching out!  Currently, Azure SQL Database does not offer cross database queries.  However, I'd like to learn more about your scenario.  Can you please email me at joseidz at microsoft.com.

• Proposed as answer by Joseph IdziorekMicrosoft employee 7 hours 31 minutes ago

Hi ReflexRob,

No need to apologize - thank you for reaching out!  Currently, Azure SQL Database does not offer cross database queries.  However, I'd like to learn more about your scenario.  Can you please email me at joseidz at microsoft.com.

• Proposed as answer by Joseph IdziorekMicrosoft employee 7 hours 42 minutes ago

Hi ReflexRob,

No need to apologize - thank you for reaching out!  Currently, Azure SQL Database does not offer cross database queries.  However, I'd like to learn more about your scenario.  Can you please email me at joseidz at microsoft.com.

• Proposed as answer by Joseph IdziorekMicrosoft employee Sunday, February 01, 2015 12:26 AM

Hi ReflexRob,

No need to apologize - thank you for reaching out!  Currently, Azure SQL Database does not offer cross database queries.  However, I'd like to learn more about your scenario.  Can you please email me at joseidz at microsoft.com.

• Proposed as answer by Joseph IdziorekMicrosoft employee Sunday, February 01, 2015 12:26 AM
• Marked as answer by ReflexRob Monday, February 02, 2015 3:16 PM