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 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply