Generate Database Script from SQL Server for SQL Azure

Hello,

Today I am going to guide you about how to create database script in SQL Server 2008 above to simply let it work on SQL Azure. SQL Azure implements different rules to work with the databases including Primary Key constraint is mandatory for every table. Before running the script on SQL Azure make sure you have created a Primary Key in each table of database. The Screenshots below will help you to create the SQL database script for SQL Azure.
The First step is to right-click on the database you want to make script of for SQL Azure.

Secondly, Going onto tasks and click Generate Scripts

Generate Scripts will launch the Generate and publish scripts window. Press next and then again next. After that provide the location where to generate script and click on “Advance” button. Scroll to the property “script for the database engine type” and select SQL Azure from there, as shown below

Press Ok and press next after that and again next, then finish. The script will be generated for SQL Azure which you directly paste in the SQL Azure new query window under a Database you already have created on Windows Azure.

For more queries regarding Windows Azure, SQL Azure , feel free to contact at addresses below

Email: jkhan@programmer.net

Skype: jibrankhan1990

Get Current Location of Windows Phone Device

Hello,

Today this post will give you an idea about , how you can get the current location of your Windows Phone device. This can be easily achieved by using `GeoCoordinateWatcher` class under the namespace using System.Device.Location;
Here is the code by which you can get the Longitude and Latitude values of the device location.

This code gets the current position of Windows Phone device in the form of Longitude and Latitude. Using these values, many different Location features can be implemented such as distance finding between two locations , mapping the location on Bing and Google maps and more.

For any further query you can contact on below addresses:

Email: jkhan@programmer.net

Skype: jibrankhan1990