I am looking at creating a vb script to replace a value in multiple xml files quickly. It is a single xml file called dbid.xml and it is in each project folder. There are thousands of projects under different file folders under one main directory. Also would like to create a log of change to help validate change.
I have all the location in a variable file so just need code to run.
I need to replace the value in the parameters <PHYSICAL_DIRECTORY> </PHYSICAL_DIRECTORY>
Example
From
<PHYSICAL_DIRECTORY>\\server21\qc\Test_Target_Project1\</PHYSICAL_DIRECTORY>
To
<PHYSICAL_DIRECTORY>\\server311\qc11\Test_Target_Project1\</PHYSICAL_DIRECTORY>
Sample dbid.xml file
<?xml version="1.0" encoding="UTF-8"?>
<ProjectDescription>
<PROJECT_NAME>Test_Target_Project1</PROJECT_NAME>
<DB_TYPE>2</DB_TYPE>
<DESCRIPTION>Created on 2013-08-02 09:36:37</DESCRIPTION>
<DB_CONNSTR_FORMAT>jdbc:mercury:sqlserver://testqlserver:1433</DB_CONNSTR_FORMAT>
<DB_NATIVE_AUTHENTICATION>Y</DB_NATIVE_AUTHENTICATION>
<DB_NAME>project1_db</DB_NAME>
<DBSERVER_NAME>testdbserver</DBSERVER_NAME>
<DB_USER_PASS>qwertyuio</DB_USER_PASS>
<PR_HAS_VCSDB>N</PR_HAS_VCSDB>
<PHYSICAL_DIRECTORY>\\server21\qc\Test_Target_Project1\</PHYSICAL_DIRECTORY>
<USERS_QUOTA>-1</USERS_QUOTA>
<PR_IS_ACTIVE>Y</PR_IS_ACTIVE>
<SAQ_IS_ACTIVE>N</SAQ_IS_ACTIVE>
<VM_REPOSITORY></VM_REPOSITORY>
<PR_LANGUAGE>English</PR_LANGUAGE>
<PROJECT_TYPE>Standard</PROJECT_TYPE>
<IS_TEMPLATE>N</IS_TEMPLATE>
<PROJECT_UID>lkjhgfdsa11234</PROJECT_UID>
<PR_SMART_REPOSITORY_ENABLED>Y</PR_SMART_REPOSITORY_ENABLED>
<PR_IS_QPM_AUTO_CALC_ENABLED>Y</PR_IS_QPM_AUTO_CALC_ENABLED>
</ProjectDescription>
Open in new window
~bp