Jump to content


Photo

Windows Azure Database


  • Please log in to reply
1 reply to this topic

#1 kenajones

kenajones

    New Member

  • Members
  • Pip
  • 1 posts

Posted 28 July 2010 - 04:37 PM

Hi Sriram,

I'm interested in the database component of Windows Azure. Is this based on SQL Server? If so, is the implementation version-specific e.g. SQL 2005 or SQL 2008? I'm wondering if a company's DBA's need to learn any scripting other than standard SQL Server T-SQL and if current apps and scripts will work without modification. Also, and I promise this is the last question, how would we migrate an existing database to Azure?

Thanks very much for this book club, and, of course, your book!

Ken

#2 sriramk

sriramk

    Active Member

  • O'Reilly Author
  • PipPip
  • 16 posts

Posted 28 July 2010 - 11:28 PM

QUOTE (kenajones @ Jul 28 2010, 04:37 PM) <{POST_SNAPBACK}>
Hi Sriram,

I'm interested in the database component of Windows Azure. Is this based on SQL Server? If so, is the implementation version-specific e.g. SQL 2005 or SQL 2008? I'm wondering if a company's DBA's need to learn any scripting other than standard SQL Server T-SQL and if current apps and scripts will work without modification. Also, and I promise this is the last question, how would we migrate an existing database to Azure?
Ken


I'm not sure what you mean by implementation specific but in terms of lineage, it is very close to SQL 2k8. The core idea is that you get to reuse any SQL expertise so all your T-SQL skills will be handy smile.gif.

As for data migration, look at SSIS or http://www.microsoft...azure/datasync/







0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users