Modify web.config with powershell

Question

I need to try to update a web.config file to change the IP address only of the web.config I have included the section of code Im looking at for powershell to script the change.

<connectionStrings>
    <add name="connectionString" connectionString="provider=SQLOLEDB;Server=192.168.1.100;database=sample;Trusted_Connection=Yes" providerName="System.Data.OleDb" />
    <add name="sqlConnectionString" connectionString="Data Source=192.168.1.100;Initial Catalog=sample;Trusted_Connection=Yes" providerName="System.Data.SqlClient" />
  </connectionStrings>

I would like a very simple solution to this just update the ServerIP address.

Anyone know an easy way to do this with PowerShell.

Harald F. · Accepted Answer · 2013-05-30 07:10:55Z

11

I'd to the following

$cfg = [xml](gc web.config)
# Replace all references of the IP in all connection string
$cfg.configuration.connectionStrings.add|%{
   $_.connectionString = $_.connectionString -replace "192.168.1.100", "1.0.0.1";
}
$cfg.Save("Web.config");

If you are just looking to replace a specfic connection string, I'd fetch it like this:

$con= $cfg.configuration.connectionStrings.add|?{$_.name -eq "SqlDataCon"};
# Replace the content
$con.connectionString = $con.connectionString -replace "192.168.1.100", "1.0.0.1"

answered May 30, 2013 at 7:10

Harald F.

4,8431 gold badge29 silver badges30 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

JPBlanc · Accepted Answer · 2013-05-30 05:12:43Z

5

You can try :

$xml = [xml](Get-Content c:\temp\web.config)
$conString = $xml.connectionStrings.add[0].connectionString
$conString2 = $conString -replace '192.168.1.100','10.10.10.10'
$xml.connectionStrings.add[0].connectionString = $conString2
$conString = $xml.connectionStrings.add[1].connectionString
$conString2 = $conString -replace '192.168.1.100','10.10.10.10'
$xml.connectionStrings.add[1].connectionString = $conString2
$xml.Save('c:\temp\web2.config')

This do the job for the two connection strings. If you don't want to hard code the old IP address you can use :

$conString -replace 'Server=.*;','Server=10.10.10.11;'

answered May 30, 2013 at 5:12

JPBlanc

73.1k17 gold badges137 silver badges180 bronze badges

1 Comment

Pathead Over a year ago

For me I had to make the regex non greedy otherwise it would erase any of the keys after Server: $conString -replace 'Server=.*?;','Server=10.10.10.11;'

Collectives™ on Stack Overflow

Modify web.config with powershell

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related