Blog Post

Kirill Gavrylyuk and Josh Twist: Inside Windows Azure Mobile Services

Sign in to queue

The Discussion

  • User profile image
    BuddyP

    My biggest hurdle, at the moment, centers around the fact that my existing database is on SQLAzure "SouthCentralUS" and is not supported (only Eastern) in mobile services.  I experimented with creating a new "EasternUS" db in SSMS, but, because of restricted TSQL for SQLAzure, I could not find a way to hydrate my database from the original.  I'm sure there is a way, but I am not a db administrator type.

  • User profile image
    Duncanma

    @BuddyP: If you'd like to make a copy of your database into Eastern US, I believe these instructions should work: https://msdn.microsoft.com/en-us/library/windowsazure/ff951631.aspx#TsqlProcedureCrossServer

     

  • User profile image
    fm2000

    Great interview!  Clarified many things.  Thanks.

  • User profile image
    BuddyP

    Thanks Duncanma.  I finally got the db copied to 'Eastern'.  I wound up 'exporting' the db in azure portal , then 'importing' to a new 'Eastern' server.  It was very convoluted, but finally worked.  As I remember though, to get the table to import to a mobile service,  the owner of the table had to be the same prefix as the mobile service name.  it would not work with 'dbo.' as owner.

Add Your 2 Cents