August 4, 2015 at 4:50 am
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:
http://msftdbprodsamples.codeplex.com/releases/view/37304
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.
August 4, 2015 at 11:54 am
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
August 5, 2015 at 5:41 am
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 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy