So my work is looking into Automating Hyper-V Servers for Test Environments, Basically in the end we want to have a sort of Web/Form interface for selecting a server spin up. Right now it's done manually but for the first part maybe scripting some of it would be a first part.

Ideally we'd like to be able to Automate it in the sense that we are able to assign a Hyper-V name/Ip configuration/ as well as Assigning a specific Microsoft SQL Server to it (like 2008 or 2012) and various specifics.

What would be the best way to "get started" with this. I know a book exists "SQL Server 2012 with PowerShell V3 Cookbook" might be helpful, but "Cookbooks" tend to sometimes be sparse on material.

There is also "Microsoft SQL Server 2008 Administration with Windows PowerShell" but would this be applicable to SQL Server 2012?

Also what about any books for Automating or Using Powershell for Setting up Hyper-V servers?

The language can be changed, Python/Perl/etc... but Powershell is just an idea, since everything we used is Microsoft based anyways.

Also is this a common/decently-easy thing to do? or am I looking at a task that might be more overwhelming than I thought?



I would start with the technet pages for HyperV cmdlets and SQL cmdlets, if you are well versed in powershell then you can cook your own recipes, so to speak. Using HyperV and SQL does give you a powershell advantage, although I believe HyperV cmdlets are only available when you are using Windows 8/2012 RSAT.

| improve this answer | |
  • So pretty much powershell is basically my only option when it comes to this (Which is ok with me)? – user57862 Mar 6 '13 at 15:47
  • 1
    I wouldn't say it's your only option, but in terms of what you want to do it's certainly the best option, imo of course. If you are new to powershell I recommend this book for the basics, everything as far as cmdlet reference go can be found on technet, and powershell.com has a daily mailing list that gives useful commands I reference back to from time to time. – MDMoore313 Mar 6 '13 at 15:52

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy