x

Azure Compatibility

Seeder question: I have been asked by one of my clients to make my client application SQL Azure compatible. While I have tested and there are only a few tweaks to make, I now need to make sure that my client application can reliably determine when it is connected to SQL Azure. How might I do that?

more ▼

asked Oct 24 '09 at 06:05 PM in Default

Matt Whitfield gravatar image

Matt Whitfield ♦♦
29.4k 61 65 87

(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first

You could try

SELECT @@VERSION

Not sure what that returns on SQL Azure but you might be able to differentate using it.

James

more ▼

answered Oct 25 '09 at 11:38 AM

James Moore gravatar image

James Moore
178 2 2 3

I'm going to accept this one, although what I'd have really like to have seen is something like SELECT CASE WHEN CHARINDEX('Azure', @@VERSION) > 0 THEN 1 ELSE 0 END as IsAzure
Oct 28 '09 at 10:10 AM Matt Whitfield ♦♦
(comments are locked)
10|1200 characters needed characters left

SQL Azure has a few extra things in it, like a system view called sys.bandwidth_usage. Therefore, you could test for its existence. This will give you 0 if there is no such view, and 1 if there is:

SELECT SIGN(ISNULL(SUM(object_id),0)) AS IsAzure FROM sys.all_objects WHERE name = 'bandwidth_usage' AND schema_id = 4; 
more ▼

answered Oct 25 '09 at 08:42 PM

Rob Farley gravatar image

Rob Farley
5.7k 15 18 20

Can you think of a way that would work on any SQL Server Version? My theoretical app needs to connect to any SQL Server version including 2000...
Oct 26 '09 at 06:24 AM Matt Whitfield ♦♦
Well, otherwise you can check the server properties. I just don't know if there's one that indicates it's Azure.
Oct 26 '09 at 07:07 AM Rob Farley
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x20

asked: Oct 24 '09 at 06:05 PM

Seen: 939 times

Last Updated: Oct 24 '09 at 06:05 PM