Geeks With Blogs

News

This blog has moved to ericnelson.wordpress.com

 Subscribe in a reader

Add to Google Reader or Homepage


Links
View my teams slideshare
These postings are provided "AS IS" with no warranties, and confer no rights.



IUpdateable has moved to ericnelson.wordpress.com Please visit http://ericnelson.wordpress.com

As I mentioned earlier this week, we now have a CTP release of a version of SSMS that is SQL Azure aware.

I thought it might be useful to share my first few minutes with it. First up, I cleared out my SQL Azure account using the portal (dropped all my databases).

image

And I made sure the firewall setting would allow me to connect: (for simplicity I just opened up everything. Don’t do that!)

image 

Then I downloaded (155MB) SSMS R2 Nov CTP (32bit or 64bit) and installed it:

ssms installed

Which gave me a new menu group for R2:

image

Launching SSMS R2 I filled in my server name, admin name and password copied over from the portal:

image

Which then gave me the usual catalogue view:

image

And allowed me to do a Create Database using the new SQL Azure templates (no dialogue boxes):

image

Which was there waiting for me in the portal:

image

I have not done an exhaustive check – but looks like we have SQL Azure templates for most/all :-)

image

Nice and simple. I also just spotted a similar post – check that out as well.

Enjoy

DotNetKicks Image
Posted on Friday, November 13, 2009 3:06 PM Data , Cloud Computing | Back to top


Comments on this post: Using SQL Server Management Studio R2 with SQL Azure

No comments posted yet.
Your comment:
 (will show your gravatar)


Copyright © Eric Nelson | Powered by: GeeksWithBlogs.net | Join free