Installing Adventure Works databases in Sql Azure Virtual Machine

  • Morning,

    Wonder if anyone could help me with something that's got me stuck right now.

    Using my msdn subscription I've built a VM with sql server 2012 using the image gallery supplied. Everything is up and running fine but I'm trying to create the adventure works dbs so I can have a play with the data.

    I've been following the instructions on blogs or articles like this one:

    However when I follow the instructions I get the following error message when trying to run from cmd prompt as suggested:

    'CreateAdventureWorksForSqlAzure.cmd' is not recognized as an internal or external command, operable program or batch file.

    Any thoughts on what I'm doing wrong or have I missed something before getting to this point?

    My sql server is setup and has the standard Report server dbs and I can create my own dbs there without any issue.

  • Yeah, you're trying to create an Azure SQL Database copy of Adventureworks. You're in a VM. That's just like any other version of SQL Server. So you can go to the demos page[/url] and download a backup or an MDF file and restore or attach AdventureWorks. The other script is for creating the database within the Platform as a Service aspect of Azure.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • Grant thanks for the reply. Yes that's exactly what I did last night just did a standard restore from the mdf ldf files. I was a bit thrown by the other blogs posts and I had issues with access to the c drive on my VM. All part of the learning curve while trying azure for the first time!!

    All sorted now a:-)

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply