Create web application and site collection using powershell

Hi Folks,

Just came across a requirement of creating web application and site collections using power shell, posting it here.

Open an empty notepad file and copy paste below code segment :

Add-PsSnapin Microsoft.SharePoint.PowerShell

#My Parameters

$WebAppName = "MyWebApplication"
$WebAppHostHeader = "http://MyWebHost"
$WebAppPort = 7575
$WebAppAppPool = "AppPool_7575"

# This User has to be a Sharepoint Manager Account
$WebAppAppPoolAccount = "MyDomain\hirwani"

$WebAppDatabaseName = "WSS_Content_7575"
$WebAppDatabaseServer = "MySQLServer\SharePoint"
$template = Get-SPWebTemplate "STS#0"


# Create a new Sharepoint WebApplication

New-SPWebApplication -Name $WebAppName -Port $WebAppPort -HostHeader $WebAppHostHeader -URL ("http://" + $WebAppHostHeader) -ApplicationPool $WebAppAppPool -ApplicationPoolAccount ($WebAppAppPoolAccount) -DatabaseName $WebAppDatabaseName -DatabaseServer $WebAppDatabaseServer

# Create a new Sharepoint Site Collection

New-SPSite -Name "Root" -Url "http://in-mum-tfsport1:7575/" -Template $template -OwnerAlias "MyDomain\hirwani"

Save this notepad with .ps1 extension. Now execute it, you should get a new web application and site collection created.

Note : Change above parameters as per your requirement. Post here if you have any questions/suggestions.

Adding and activating solution in solution gallery

Fea days back, i came across this requirement to add solution to site solution gallery. I wrote below code segment :

ClientContext context = new ClientContext("http://in-air-eyshr2:1234/sites/ETD02");

//Activate Publishing feature
//Add wsp from file system to SP solution gallary
Folder destionationFolder = context.Web.GetFolderByServerRelativeUrl("_catalogs/solutions");
FileCreationInformation fci = new FileCreationInformation();
fci.Content = System.IO.File.ReadAllBytes("D:/WSPS/LDTest.wsp");
fci.Url = "LDTest.wsp";
fci.Overwrite = true;
Microsoft.SharePoint.Client.File fileToUpload = destionationFolder.Files.Add(fci);
context.Load(fileToUpload);
context.ExecuteQuery();

//Activate solution
DesignPackageInfo info = new DesignPackageInfo()
{
  PackageGuid = Guid.Empty,
  MajorVersion = 1,
  MinorVersion = 1,
  PackageName = "LDTest"
  };
  Console.WriteLine("Installing design package ");
  //Relative Path of Solution Uploaded in Solution Gallery
  //string fileRelativePath = "D:/WSPS/testwsp.wsp";
string fileRelativePath = "/sites/ETD02/_catalogs/solutions/LDTest.wsp";
DesignPackage.Install(context, context.Site, info, fileRelativePath);
context.ExecuteQuery();
Console.WriteLine("Applying Design Package!");
DesignPackage.Apply(context, context.Site, info);
context.ExecuteQuery();

and it gave me following output:

You can give me your suggestions or post relevant questions, if any