+------------------------+---------------------------------------------+
| ![](m                  | **Checklist**![](medi                       |
| edia/image1.wmf){width | a/image2.jpeg){width="1.4583333333333333in" |
| ="2.104861111111111in" | height="0.7916666666666666in"} **for Schema |
| height="1.1875in"}     | Migrating from SDWIS/STATE Release 8.0 to   |
|                        | SDWIS/STATE Release 2.0**                   |
| United States          |                                             |
| Environmental          |                                             |
| Protection Agency      |                                             |
|                        |                                             |
| Office of Ground Water |                                             |
| and Drinking Water     |                                             |
|                        |                                             |
| CONTRACT NO. EPA BPA   |                                             |
| OARMSC-SYS-04          |                                             |
|                        |                                             |
| SDWIS Project          |                                             |
|                        |                                             |
| Product Control No.    |                                             |
|                        |                                             |
| Syst                   |                                             |
| alex-SDWIS-01-2.WIP156 |                                             |
|                        |                                             |
| November 26, 2007      |                                             |
+------------------------+---------------------------------------------+

**CHECKLIST**![](media/image2.jpeg){width="1.4583333333333333in"
height="0.8569444444444444in"} **FOR SCHEMA MIGRATING FROM SDWIS/STATE
RELEASE 8.0 TO SDWIS/STATE RELEASE 2.0**

**CONTRACT NO. EPA BPA OARMSC-SYS-04**

**SDWIS PROJECT**

**Prepared for:**

**United States Environmental Protection Agency**

**Office of Ground Water and Drinking Water**

**Drinking Water Protection Division**

**1200 Pennsylvania Ave., NW**

**Washington, DC 20460**

**Contracting Officer Representative**

**Clint Lemmons**

**Prepared by:**

**SAIC Solutions Delivery Center**

**Science Applications International Corporation**

**6565 Arlington Boulevard**

**Falls Church, VA 22042**

**CONTENTS**

[1.0 Overview 1-1](#overview)

[2.0 ChecklistS 2-1](#checklists)

**EXHIBITS**

[Exhibit 1. SDWIS/STATE Web 1Pre-Schema Migration
2-1](#__RefHeading___Toc183916125)

[Exhibit 2. SDWIS/STATE Web 1 Schema Migration
2-1](#__RefHeading___Toc183916126)

[Exhibit 3. SDWIS/STATE Web 1 Schema Migration 1.0.2 Update
2-3](#__RefHeading___Toc183916127)

[Exhibit 4. SDWIS/STATE Web 1 SIR Scripts
2-5](#__RefHeading___Toc183916128)

# Overview

This guide is designed to assist primacy agencies who choose to move
directly from using SDWIS/STATE 8.0 in production to using SDWIS/STATE
2.0 in production. Primacy agencies who choose not to use SDWIS/STATE
Web 1.0 in production will still need to schema migrate to that release
as part of moving to SDWIS/STATE 2.0. This guide is formatted as a
series of checklists to ensure your primacy agency performs the steps
required for data to be migrated from a SDWIS/STATE 8.0 schema through
the SDWIS/STATE Web 1.0 (SSWR1) schema, and finally to the SDWIS/STATE
2.0 schema.

Most of the referenced documentation and software is available for
download from the EPA website,
<http://www.epa.gov/safewater/sdwis_st/current.html>. The remainder of
the required software should be requested from SDWIS User Support. A
file containing the SSWR1 pre-schema migration package and all Software
Incident Report (SIR) scripts for your target DBMS will be provided to
you in a zip file named SS2.0 Checklist Scripts -- dbms.zip.

Although it is not a requirement that the SDWIS/STATE Web Release 1.0.3
application be deployed, it is recommended so that the data migration
from SDWIS/STATE 8.0 to SDWIS/STATE Web Release 1.0 schema can be
verified. If you choose to not use the SDWIS/STATE Web Release 1.0.3 web
application to confirm correct and complete data migration, you should
choose some other method of data confirmation.

**User Support**

After consulting your SDWIS/STATE Administrator and this guide, you may
direct questions or requests for further SDWIS/STATE assistance to SDWIS
User Support at (703) 292-6298 or e-mail **sdwis@saic.com**.

# ChecklistS

The following tables (Exhibits 1-4) list the steps that should be
followed in sequential order to migrate your SDWIS/STATE release 8.0
data into SDWIS/STATE Release 2.0. Checkpoints for data verification are
suggested.

If you are using Oracle, ensure that you have installed at least Oracle
9i or higher.

The following tasks should occur in your SDWIS/STATE Release 8.0
Database using the Pre-Schema Migration Tool available in the package
requested from SDWIS User Support.

+---+----+----------------------------+---------------+---------------+
| [ |    |                            |               |               |
| ] |    |                            |               |               |
| { |    |                            |               |               |
| # |    |                            |               |               |
| _ |    |                            |               |               |
| _ |    |                            |               |               |
| R |    |                            |               |               |
| e |    |                            |               |               |
| f |    |                            |               |               |
| H |    |                            |               |               |
| e |    |                            |               |               |
| a |    |                            |               |               |
| d |    |                            |               |               |
| i |    |                            |               |               |
| n |    |                            |               |               |
| g |    |                            |               |               |
| _ |    |                            |               |               |
| _ |    |                            |               |               |
| _ |    |                            |               |               |
| T |    |                            |               |               |
| o |    |                            |               |               |
| c |    |                            |               |               |
| 1 |    |                            |               |               |
| 8 |    |                            |               |               |
| 3 |    |                            |               |               |
| 9 |    |                            |               |               |
| 1 |    |                            |               |               |
| 6 |    |                            |               |               |
| 1 |    |                            |               |               |
| 2 |    |                            |               |               |
| 5 |    |                            |               |               |
| . |    |                            |               |               |
| a |    |                            |               |               |
| n |    |                            |               |               |
| c |    |                            |               |               |
| h |    |                            |               |               |
| o |    |                            |               |               |
| r |    |                            |               |               |
| } |    |                            |               |               |
| E |    |                            |               |               |
| x |    |                            |               |               |
| h |    |                            |               |               |
| i |    |                            |               |               |
| b |    |                            |               |               |
| i |    |                            |               |               |
| t |    |                            |               |               |
|   |    |                            |               |               |
| 1 |    |                            |               |               |
| . |    |                            |               |               |
| S |    |                            |               |               |
| D |    |                            |               |               |
| W |    |                            |               |               |
| I |    |                            |               |               |
| S |    |                            |               |               |
| / |    |                            |               |               |
| S |    |                            |               |               |
| T |    |                            |               |               |
| A |    |                            |               |               |
| T |    |                            |               |               |
| E |    |                            |               |               |
| W |    |                            |               |               |
| e |    |                            |               |               |
| b |    |                            |               |               |
| 1 |    |                            |               |               |
| P |    |                            |               |               |
| r |    |                            |               |               |
| e |    |                            |               |               |
| - |    |                            |               |               |
| S |    |                            |               |               |
| c |    |                            |               |               |
| h |    |                            |               |               |
| e |    |                            |               |               |
| m |    |                            |               |               |
| a |    |                            |               |               |
| M |    |                            |               |               |
| i |    |                            |               |               |
| g |    |                            |               |               |
| r |    |                            |               |               |
| a |    |                            |               |               |
| t |    |                            |               |               |
| i |    |                            |               |               |
| o |    |                            |               |               |
| n |    |                            |               |               |
+===+====+============================+===============+===============+
| ! | ** | **Task**                   | **Oracle      | **MS SQL      |
| [ | St |                            | Script Name** | Server Script |
| ] | ep |                            |               | Name**        |
| ( | ** |                            |               |               |
| m |    |                            |               |               |
| e |    |                            |               |               |
| d |    |                            |               |               |
| i |    |                            |               |               |
| a |    |                            |               |               |
| / |    |                            |               |               |
| i |    |                            |               |               |
| m |    |                            |               |               |
| a |    |                            |               |               |
| g |    |                            |               |               |
| e |    |                            |               |               |
| 3 |    |                            |               |               |
| . |    |                            |               |               |
| w |    |                            |               |               |
| m |    |                            |               |               |
| f |    |                            |               |               |
| ) |    |                            |               |               |
| { |    |                            |               |               |
| w |    |                            |               |               |
| i |    |                            |               |               |
| d |    |                            |               |               |
| t |    |                            |               |               |
| h |    |                            |               |               |
| = |    |                            |               |               |
| " |    |                            |               |               |
| 0 |    |                            |               |               |
| . |    |                            |               |               |
| 1 |    |                            |               |               |
| 7 |    |                            |               |               |
| 7 |    |                            |               |               |
| 7 |    |                            |               |               |
| 7 |    |                            |               |               |
| 7 |    |                            |               |               |
| 7 |    |                            |               |               |
| 7 |    |                            |               |               |
| 7 |    |                            |               |               |
| 7 |    |                            |               |               |
| 7 |    |                            |               |               |
| 7 |    |                            |               |               |
| 7 |    |                            |               |               |
| 7 |    |                            |               |               |
| 7 |    |                            |               |               |
| 7 |    |                            |               |               |
| 8 |    |                            |               |               |
| i |    |                            |               |               |
| n |    |                            |               |               |
| " |    |                            |               |               |
| h |    |                            |               |               |
| e |    |                            |               |               |
| i |    |                            |               |               |
| g |    |                            |               |               |
| h |    |                            |               |               |
| t |    |                            |               |               |
| = |    |                            |               |               |
| " |    |                            |               |               |
| 0 |    |                            |               |               |
| . |    |                            |               |               |
| 2 |    |                            |               |               |
| 0 |    |                            |               |               |
| 7 |    |                            |               |               |
| 6 |    |                            |               |               |
| 3 |    |                            |               |               |
| 8 |    |                            |               |               |
| 8 |    |                            |               |               |
| 8 |    |                            |               |               |
| 8 |    |                            |               |               |
| 8 |    |                            |               |               |
| 8 |    |                            |               |               |
| 8 |    |                            |               |               |
| 8 |    |                            |               |               |
| 8 |    |                            |               |               |
| 8 |    |                            |               |               |
| 9 |    |                            |               |               |
| i |    |                            |               |               |
| n |    |                            |               |               |
| " |    |                            |               |               |
| } |    |                            |               |               |
+---+----+----------------------------+---------------+---------------+
|   | 1  | Extract the contents of    | > SSW         | SchemaMigrati |
|   | .1 | the Pre Schema Migration   | r1_Sch_Mig_Pr | onPrepSQL.zip |
|   |    | Tool                       | ep_Oracle.zip |               |
+---+----+----------------------------+---------------+---------------+
|   | 1  | Follow the instructions in | > Pr          | > Pr          |
|   | .2 | the SSWr1 Schema Mig Prep  | eSM_Check.SQL | eSM_Check.SQL |
|   |    | Tool(WIP)v5.doc to         | >             |               |
|   |    | evaluate your SDWIS/STATE  | > SSWr1-Sch   | SSWr1-Sch     |
|   |    | Release 8.0 database       | -Mig-Prep.mdb | -Mig-Prep.mdb |
+---+----+----------------------------+---------------+---------------+
|   | 1  | Contact <SDWIS@SAIC.COM>   |               |               |
|   | .3 | with any results the from  |               |               |
|   |    | the Pre-Schema Migration   |               |               |
|   |    | scripts that require       |               |               |
|   |    | consultation for           |               |               |
|   |    | resolution.                |               |               |
+---+----+----------------------------+---------------+---------------+

Proceed to the Release 8.0 to SDWIS/STATE Web 1 Schema Migration.

+---+-----+----------------------------+---------------+---------------+
| [ |     |                            |               |               |
| ] |     |                            |               |               |
| { |     |                            |               |               |
| # |     |                            |               |               |
| _ |     |                            |               |               |
| _ |     |                            |               |               |
| R |     |                            |               |               |
| e |     |                            |               |               |
| f |     |                            |               |               |
| H |     |                            |               |               |
| e |     |                            |               |               |
| a |     |                            |               |               |
| d |     |                            |               |               |
| i |     |                            |               |               |
| n |     |                            |               |               |
| g |     |                            |               |               |
| _ |     |                            |               |               |
| _ |     |                            |               |               |
| _ |     |                            |               |               |
| T |     |                            |               |               |
| o |     |                            |               |               |
| c |     |                            |               |               |
| 1 |     |                            |               |               |
| 8 |     |                            |               |               |
| 3 |     |                            |               |               |
| 9 |     |                            |               |               |
| 1 |     |                            |               |               |
| 6 |     |                            |               |               |
| 1 |     |                            |               |               |
| 2 |     |                            |               |               |
| 6 |     |                            |               |               |
| . |     |                            |               |               |
| a |     |                            |               |               |
| n |     |                            |               |               |
| c |     |                            |               |               |
| h |     |                            |               |               |
| o |     |                            |               |               |
| r |     |                            |               |               |
| } |     |                            |               |               |
| E |     |                            |               |               |
| x |     |                            |               |               |
| h |     |                            |               |               |
| i |     |                            |               |               |
| b |     |                            |               |               |
| i |     |                            |               |               |
| t |     |                            |               |               |
| 2 |     |                            |               |               |
| . |     |                            |               |               |
| S |     |                            |               |               |
| D |     |                            |               |               |
| W |     |                            |               |               |
| I |     |                            |               |               |
| S |     |                            |               |               |
| / |     |                            |               |               |
| S |     |                            |               |               |
| T |     |                            |               |               |
| A |     |                            |               |               |
| T |     |                            |               |               |
| E |     |                            |               |               |
| W |     |                            |               |               |
| e |     |                            |               |               |
| b |     |                            |               |               |
| 1 |     |                            |               |               |
| S |     |                            |               |               |
| c |     |                            |               |               |
| h |     |                            |               |               |
| e |     |                            |               |               |
| m |     |                            |               |               |
| a |     |                            |               |               |
| M |     |                            |               |               |
| i |     |                            |               |               |
| g |     |                            |               |               |
| r |     |                            |               |               |
| a |     |                            |               |               |
| t |     |                            |               |               |
| i |     |                            |               |               |
| o |     |                            |               |               |
| n |     |                            |               |               |
+===+=====+============================+===============+===============+
| ! | **  | **Task**                   | **Oracle      | **MS SQL      |
| [ | Ste |                            | Script Name** | Server Script |
| ] | p** |                            |               | Name**        |
| ( |     |                            |               |               |
| m |     |                            |               |               |
| e |     |                            |               |               |
| d |     |                            |               |               |
| i |     |                            |               |               |
| a |     |                            |               |               |
| / |     |                            |               |               |
| i |     |                            |               |               |
| m |     |                            |               |               |
| a |     |                            |               |               |
| g |     |                            |               |               |
| e |     |                            |               |               |
| 3 |     |                            |               |               |
| . |     |                            |               |               |
| w |     |                            |               |               |
| m |     |                            |               |               |
| f |     |                            |               |               |
| ) |     |                            |               |               |
| { |     |                            |               |               |
| w |     |                            |               |               |
| i |     |                            |               |               |
| d |     |                            |               |               |
| t |     |                            |               |               |
| h |     |                            |               |               |
| = |     |                            |               |               |
| " |     |                            |               |               |
| 0 |     |                            |               |               |
| . |     |                            |               |               |
| 1 |     |                            |               |               |
| 7 |     |                            |               |               |
| 7 |     |                            |               |               |
| 7 |     |                            |               |               |
| 7 |     |                            |               |               |
| 7 |     |                            |               |               |
| 7 |     |                            |               |               |
| 7 |     |                            |               |               |
| 7 |     |                            |               |               |
| 7 |     |                            |               |               |
| 7 |     |                            |               |               |
| 7 |     |                            |               |               |
| 7 |     |                            |               |               |
| 7 |     |                            |               |               |
| 7 |     |                            |               |               |
| 7 |     |                            |               |               |
| 8 |     |                            |               |               |
| i |     |                            |               |               |
| n |     |                            |               |               |
| " |     |                            |               |               |
| h |     |                            |               |               |
| e |     |                            |               |               |
| i |     |                            |               |               |
| g |     |                            |               |               |
| h |     |                            |               |               |
| t |     |                            |               |               |
| = |     |                            |               |               |
| " |     |                            |               |               |
| 0 |     |                            |               |               |
| . |     |                            |               |               |
| 2 |     |                            |               |               |
| 0 |     |                            |               |               |
| 7 |     |                            |               |               |
| 6 |     |                            |               |               |
| 3 |     |                            |               |               |
| 8 |     |                            |               |               |
| 8 |     |                            |               |               |
| 8 |     |                            |               |               |
| 8 |     |                            |               |               |
| 8 |     |                            |               |               |
| 8 |     |                            |               |               |
| 8 |     |                            |               |               |
| 8 |     |                            |               |               |
| 8 |     |                            |               |               |
| 8 |     |                            |               |               |
| 9 |     |                            |               |               |
| i |     |                            |               |               |
| n |     |                            |               |               |
| " |     |                            |               |               |
| } |     |                            |               |               |
+---+-----+----------------------------+---------------+---------------+
|   | 2.1 | Download from              | > [Oracle     | > [SQL Server |
|   |     | <http://www.epa.gov/safewa | > Release     | > Release     |
|   |     | ter/sdwis_st/current.html> | > Notes       | > Notes       |
|   |     |                            | ](http://www. | ](http://www. |
|   |     | -   SDWIS/STATE Web        | epa.gov/safew | epa.gov/safew |
|   |     |     Release 1.0            | ater/sdwis_st | ater/sdwis_st |
|   |     |     Installation Guide     | /web_release/ | /web_release/ |
|   |     |                            | sswr1_release | sqlserver_rel |
|   |     | -   SDWIS/STATE Web        | _notes.zip) - | _notes.zip) - |
|   |     |     Release 1.0 Release    | > 11/23/05    | > 1/24/06     |
|   |     |     Notes                  | > (297 K ZIP  | > (0.3 M ZIP  |
|   |     |                            | > FILE)       | > FILE)       |
|   |     |                            | >             |               |
|   |     |                            | > [Oracle     | [SQL Server   |
|   |     |                            | >             | Installation  |
|   |     |                            |  Installation | Guide](ht     |
|   |     |                            | >             | tp://www.epa. |
|   |     |                            |  Guide](http: | gov/safewater |
|   |     |                            | //www.epa.gov | /sdwis_st/web |
|   |     |                            | /safewater/sd | _release/sqls |
|   |     |                            | wis_st/web_re | erver_install |
|   |     |                            | lease/sswr1_o | _guide.zip) - |
|   |     |                            | racle_install | 1/24/06 (7.2  |
|   |     |                            | _guide.zip) - | M ZIP FILE)   |
|   |     |                            | > 11/23/05    |               |
|   |     |                            | > (7.5 M ZIP  |               |
|   |     |                            | > FILE)       |               |
+---+-----+----------------------------+---------------+---------------+
|   | 2.2 | Download from              | > SSWr1_      | > SSWr1_      |
|   |     | <http://www.epa.gov/safewa | Schema_Migrat | Schema_Migrat |
|   |     | ter/sdwis_st/current.html> | ion_1_0_1.zip | ion_1_0_1.zip |
|   |     |                            | >             | >             |
|   |     | The SDWIS/STATE Web        | > Ss          | > Ss          |
|   |     | Release 1.0.1 DbUtilities  | wr1_schema_mi | wr1_schema_mi |
|   |     | Update Schema Migration    | gration_revis | gration_revis |
|   |     | Script and Instructions.   | ion_1_0_1_ins | ion_1_0_1_ins |
|   |     |                            | tructions.doc | tructions.doc |
|   |     | [DB Utilities 1.0.1        |               |               |
|   |     | Update](http://            |               |               |
|   |     | www.epa.gov/safewater/sdwi |               |               |
|   |     | s_st/web_release/sswr1_sch |               |               |
|   |     | ema_migration_1_0_1.zip) - |               |               |
|   |     | 7/17/2006 (15.0M ZIP file) |               |               |
|   |     |                            |               |               |
|   |     | > [DB Utilities 1.0.1      |               |               |
|   |     | > Update                   |               |               |
|   |     | > Instructions](htt        |               |               |
|   |     | p://www.epa.gov/safewater/ |               |               |
|   |     | sdwis_st/web_release/sswr1 |               |               |
|   |     | _schema_migration_revision |               |               |
|   |     | _1_0_1_instructions.doc) - |               |               |
|   |     | > 7/17/2006 (38.0 K WORD   |               |               |
|   |     | > File)                    |               |               |
+---+-----+----------------------------+---------------+---------------+
|   | 2.3 | Read the                   |               |               |
|   |     | ss                         |               |               |
|   |     | wr1_schema_migration_revis |               |               |
|   |     | ion_1_0_1_instructions.doc |               |               |
+---+-----+----------------------------+---------------+---------------+
|   | 2.4 | Unzip contents of          | SSW           | SSWR10        |
|   |     | sswr1_                     | R10_DBUtiliti | _DBUtilities_ |
|   |     | schema_migration_1_0_1.zip | es_Oracle.zip | SQLServer.zip |
|   |     | and choose script for your |               |               |
|   |     | DBMS                       |               |               |
+---+-----+----------------------------+---------------+---------------+
|   | 2.5 | Unzip contents of selected | SSW           | SSWR10        |
|   |     | file using folders option  | R10_DBUtiliti | _DBUtilities_ |
|   |     | to create your             | es_Oracle.zip | SQLServer.zip |
|   |     | SSWR10\_\_DbUtilities      |               |               |
|   |     | folder.                    |               |               |
+---+-----+----------------------------+---------------+---------------+
|   | 2.6 | Create a Logs folder under |               |               |
|   |     | SSWR10_DbUtilities folder, |               |               |
|   |     | if none exists.            |               |               |
+---+-----+----------------------------+---------------+---------------+
|   | 2.7 | Follow the instructions in |               |               |
|   |     | the Installation Guide     |               |               |
|   |     | Section 3.3. You may skip  |               |               |
|   |     | the pre-schema migration   |               |               |
|   |     | section 3.3.1 that you     |               |               |
|   |     | already performed using    |               |               |
|   |     | Checklist 1 above.         |               |               |
+---+-----+----------------------------+---------------+---------------+
|   | 2.8 | **CHECKPOINT You have now  |               |               |
|   |     | completed the initial      |               |               |
|   |     | schema migration to the    |               |               |
|   |     | SDWIS/STATE Web 1.0        |               |               |
|   |     | database. It is            |               |               |
|   |     | recommended you evaluate   |               |               |
|   |     | your data to this point    |               |               |
|   |     | before proceeding.**       |               |               |
+---+-----+----------------------------+---------------+---------------+

Exhibit 3 is the application of the SSWR1 Schema Migration 1.0.2 Update
script which resolves two specific SIRs related to SSWR1 Schema
Migration. Run this script against your SSWR1 database.

+---+----+----------------------------+-------------+-----------------+
| [ |    |                            |             |                 |
| ] |    |                            |             |                 |
| { |    |                            |             |                 |
| # |    |                            |             |                 |
| _ |    |                            |             |                 |
| _ |    |                            |             |                 |
| R |    |                            |             |                 |
| e |    |                            |             |                 |
| f |    |                            |             |                 |
| H |    |                            |             |                 |
| e |    |                            |             |                 |
| a |    |                            |             |                 |
| d |    |                            |             |                 |
| i |    |                            |             |                 |
| n |    |                            |             |                 |
| g |    |                            |             |                 |
| _ |    |                            |             |                 |
| _ |    |                            |             |                 |
| _ |    |                            |             |                 |
| T |    |                            |             |                 |
| o |    |                            |             |                 |
| c |    |                            |             |                 |
| 1 |    |                            |             |                 |
| 8 |    |                            |             |                 |
| 3 |    |                            |             |                 |
| 9 |    |                            |             |                 |
| 1 |    |                            |             |                 |
| 6 |    |                            |             |                 |
| 1 |    |                            |             |                 |
| 2 |    |                            |             |                 |
| 7 |    |                            |             |                 |
| . |    |                            |             |                 |
| a |    |                            |             |                 |
| n |    |                            |             |                 |
| c |    |                            |             |                 |
| h |    |                            |             |                 |
| o |    |                            |             |                 |
| r |    |                            |             |                 |
| } |    |                            |             |                 |
| E |    |                            |             |                 |
| x |    |                            |             |                 |
| h |    |                            |             |                 |
| i |    |                            |             |                 |
| b |    |                            |             |                 |
| i |    |                            |             |                 |
| t |    |                            |             |                 |
| 3 |    |                            |             |                 |
| . |    |                            |             |                 |
| S |    |                            |             |                 |
| D |    |                            |             |                 |
| W |    |                            |             |                 |
| I |    |                            |             |                 |
| S |    |                            |             |                 |
| / |    |                            |             |                 |
| S |    |                            |             |                 |
| T |    |                            |             |                 |
| A |    |                            |             |                 |
| T |    |                            |             |                 |
| E |    |                            |             |                 |
| W |    |                            |             |                 |
| e |    |                            |             |                 |
| b |    |                            |             |                 |
| 1 |    |                            |             |                 |
| S |    |                            |             |                 |
| c |    |                            |             |                 |
| h |    |                            |             |                 |
| e |    |                            |             |                 |
| m |    |                            |             |                 |
| a |    |                            |             |                 |
| M |    |                            |             |                 |
| i |    |                            |             |                 |
| g |    |                            |             |                 |
| r |    |                            |             |                 |
| a |    |                            |             |                 |
| t |    |                            |             |                 |
| i |    |                            |             |                 |
| o |    |                            |             |                 |
| n |    |                            |             |                 |
| 1 |    |                            |             |                 |
| . |    |                            |             |                 |
| 0 |    |                            |             |                 |
| . |    |                            |             |                 |
| 2 |    |                            |             |                 |
| U |    |                            |             |                 |
| p |    |                            |             |                 |
| d |    |                            |             |                 |
| a |    |                            |             |                 |
| t |    |                            |             |                 |
| e |    |                            |             |                 |
+===+====+============================+=============+=================+
| ! | ** | **Task**                   | **Oracle    | **MS SQL Server |
| [ | St |                            | Script      | Script Name**   |
| ] | ep |                            | Name**      |                 |
| ( | ** |                            |             |                 |
| m |    |                            |             |                 |
| e |    |                            |             |                 |
| d |    |                            |             |                 |
| i |    |                            |             |                 |
| a |    |                            |             |                 |
| / |    |                            |             |                 |
| i |    |                            |             |                 |
| m |    |                            |             |                 |
| a |    |                            |             |                 |
| g |    |                            |             |                 |
| e |    |                            |             |                 |
| 3 |    |                            |             |                 |
| . |    |                            |             |                 |
| w |    |                            |             |                 |
| m |    |                            |             |                 |
| f |    |                            |             |                 |
| ) |    |                            |             |                 |
| { |    |                            |             |                 |
| w |    |                            |             |                 |
| i |    |                            |             |                 |
| d |    |                            |             |                 |
| t |    |                            |             |                 |
| h |    |                            |             |                 |
| = |    |                            |             |                 |
| " |    |                            |             |                 |
| 0 |    |                            |             |                 |
| . |    |                            |             |                 |
| 1 |    |                            |             |                 |
| 7 |    |                            |             |                 |
| 7 |    |                            |             |                 |
| 7 |    |                            |             |                 |
| 7 |    |                            |             |                 |
| 7 |    |                            |             |                 |
| 7 |    |                            |             |                 |
| 7 |    |                            |             |                 |
| 7 |    |                            |             |                 |
| 7 |    |                            |             |                 |
| 7 |    |                            |             |                 |
| 7 |    |                            |             |                 |
| 7 |    |                            |             |                 |
| 7 |    |                            |             |                 |
| 7 |    |                            |             |                 |
| 7 |    |                            |             |                 |
| 8 |    |                            |             |                 |
| i |    |                            |             |                 |
| n |    |                            |             |                 |
| " |    |                            |             |                 |
| h |    |                            |             |                 |
| e |    |                            |             |                 |
| i |    |                            |             |                 |
| g |    |                            |             |                 |
| h |    |                            |             |                 |
| t |    |                            |             |                 |
| = |    |                            |             |                 |
| " |    |                            |             |                 |
| 0 |    |                            |             |                 |
| . |    |                            |             |                 |
| 2 |    |                            |             |                 |
| 0 |    |                            |             |                 |
| 7 |    |                            |             |                 |
| 6 |    |                            |             |                 |
| 3 |    |                            |             |                 |
| 8 |    |                            |             |                 |
| 8 |    |                            |             |                 |
| 8 |    |                            |             |                 |
| 8 |    |                            |             |                 |
| 8 |    |                            |             |                 |
| 8 |    |                            |             |                 |
| 8 |    |                            |             |                 |
| 8 |    |                            |             |                 |
| 8 |    |                            |             |                 |
| 8 |    |                            |             |                 |
| 9 |    |                            |             |                 |
| i |    |                            |             |                 |
| n |    |                            |             |                 |
| " |    |                            |             |                 |
| } |    |                            |             |                 |
+---+----+----------------------------+-------------+-----------------+
|   | 3  | Download from              | > Sswr1_    | > Sswr1_db_util |
|   | .1 | <http://www.epa.gov/safewa | db_utilitie | ities_1.0.2.zip |
|   |    | ter/sdwis_st/current.html> | s_1.0.2.zip | >               |
|   |    |                            | >           | > Sswr1_db_ut   |
|   |    | The SDWIS/STATE Web        | > Sswr1_db  | ilities_1.0.2_i |
|   |    | Release 1.0.2 DbUtilities  | _utilities_ | nstructions.doc |
|   |    | Update Schema Migration    | 1.0.2_instr |                 |
|   |    | Script and Instructions.   | uctions.doc |                 |
|   |    |                            |             |                 |
|   |    | > [DB Utilities 1.0.2      |             |                 |
|   |    | > Update](htt              |             |                 |
|   |    | p://www.epa.gov/safewater/ |             |                 |
|   |    | sdwis_st/web_release/sswr1 |             |                 |
|   |    | _db_utilities_1.0.2.zip) - |             |                 |
|   |    | > \*\* NEW 05/01/2007      |             |                 |
|   |    | > (15.0 M ZIP file)        |             |                 |
|   |    | >                          |             |                 |
|   |    | > [DB Utilities 1.0.2      |             |                 |
|   |    | > Update                   |             |                 |
|   |    | > Inst                     |             |                 |
|   |    | ructions](http://www.epa.g |             |                 |
|   |    | ov/safewater/sdwis_st/web_ |             |                 |
|   |    | release/sswr1_db_utilities |             |                 |
|   |    | _1.0.2_instructions.doc) - |             |                 |
|   |    | > \*\* NEW 05/02/2007      |             |                 |
|   |    | > (36.0 K WORD File)       |             |                 |
+---+----+----------------------------+-------------+-----------------+
|   | 3  | Read the                   |             |                 |
|   | .2 | sswr1_db_utilit            |             |                 |
|   |    | ies_1.0.2_instructions.doc |             |                 |
+---+----+----------------------------+-------------+-----------------+
|   | 3  | Unzip contents of          | PopulateWSF | Populate        |
|   | .3 | ss                         | INwithWELL. | WSFINwithWELL.L |
|   |    | wr1_db_utilities_1.0.2.zip | LogData.SQL | ogDataMSSQL.SQL |
|   |    | to                         |             |                 |
|   |    | SSWR                       | Reset_LOC.  |                 |
|   |    | 10_DbUtilities\\DbaScripts | Coordinate_ |                 |
|   |    | and follow the             | dta_src.SQL |                 |
|   |    | instructions to run the    |             |                 |
|   |    | script(2) for your DBMS    |             |                 |
+---+----+----------------------------+-------------+-----------------+
|   | 3  | **CHECKPOINT You have now  |             |                 |
|   | .4 | completed schema migration |             |                 |
|   |    | to the SDWIS/STATE Web 1.0 |             |                 |
|   |    | database. It is            |             |                 |
|   |    | recommended you evaluate   |             |                 |
|   |    | your data to this point    |             |                 |
|   |    | before proceeding.**       |             |                 |
+---+----+----------------------------+-------------+-----------------+

Exhibit 4 lists individual scripts that address user-reported SIRs for
SDWIS/STATE 1.0. They are included in this package in a zipped file
named SS2.0 Checklist Scripts - dbms.zip which you can obtain from SDWIS
user support. Each script is located under a folder with a folder name
that references the step number.

+---+----+----------------------------+-------------+-----------------+
| [ |    |                            |             |                 |
| ] |    |                            |             |                 |
| { |    |                            |             |                 |
| # |    |                            |             |                 |
| _ |    |                            |             |                 |
| _ |    |                            |             |                 |
| R |    |                            |             |                 |
| e |    |                            |             |                 |
| f |    |                            |             |                 |
| H |    |                            |             |                 |
| e |    |                            |             |                 |
| a |    |                            |             |                 |
| d |    |                            |             |                 |
| i |    |                            |             |                 |
| n |    |                            |             |                 |
| g |    |                            |             |                 |
| _ |    |                            |             |                 |
| _ |    |                            |             |                 |
| _ |    |                            |             |                 |
| T |    |                            |             |                 |
| o |    |                            |             |                 |
| c |    |                            |             |                 |
| 1 |    |                            |             |                 |
| 8 |    |                            |             |                 |
| 3 |    |                            |             |                 |
| 9 |    |                            |             |                 |
| 1 |    |                            |             |                 |
| 6 |    |                            |             |                 |
| 1 |    |                            |             |                 |
| 2 |    |                            |             |                 |
| 8 |    |                            |             |                 |
| . |    |                            |             |                 |
| a |    |                            |             |                 |
| n |    |                            |             |                 |
| c |    |                            |             |                 |
| h |    |                            |             |                 |
| o |    |                            |             |                 |
| r |    |                            |             |                 |
| } |    |                            |             |                 |
| E |    |                            |             |                 |
| x |    |                            |             |                 |
| h |    |                            |             |                 |
| i |    |                            |             |                 |
| b |    |                            |             |                 |
| i |    |                            |             |                 |
| t |    |                            |             |                 |
| 4 |    |                            |             |                 |
| . |    |                            |             |                 |
| S |    |                            |             |                 |
| D |    |                            |             |                 |
| W |    |                            |             |                 |
| I |    |                            |             |                 |
| S |    |                            |             |                 |
| / |    |                            |             |                 |
| S |    |                            |             |                 |
| T |    |                            |             |                 |
| A |    |                            |             |                 |
| T |    |                            |             |                 |
| E |    |                            |             |                 |
| W |    |                            |             |                 |
| e |    |                            |             |                 |
| b |    |                            |             |                 |
| 1 |    |                            |             |                 |
| S |    |                            |             |                 |
| I |    |                            |             |                 |
| R |    |                            |             |                 |
| S |    |                            |             |                 |
| c |    |                            |             |                 |
| r |    |                            |             |                 |
| i |    |                            |             |                 |
| p |    |                            |             |                 |
| t |    |                            |             |                 |
| s |    |                            |             |                 |
+===+====+============================+=============+=================+
| ! | ** | **Task**                   | **Oracle    | **MS SQL Server |
| [ | St |                            | Script      | Script Name**   |
| ] | ep |                            | Name**      |                 |
| ( | ** |                            |             |                 |
| m |    |                            |             |                 |
| e |    |                            |             |                 |
| d |    |                            |             |                 |
| i |    |                            |             |                 |
| a |    |                            |             |                 |
| / |    |                            |             |                 |
| i |    |                            |             |                 |
| m |    |                            |             |                 |
| a |    |                            |             |                 |
| g |    |                            |             |                 |
| e |    |                            |             |                 |
| 3 |    |                            |             |                 |
| . |    |                            |             |                 |
| w |    |                            |             |                 |
| m |    |                            |             |                 |
| f |    |                            |             |                 |
| ) |    |                            |             |                 |
| { |    |                            |             |                 |
| w |    |                            |             |                 |
| i |    |                            |             |                 |
| d |    |                            |             |                 |
| t |    |                            |             |                 |
| h |    |                            |             |                 |
| = |    |                            |             |                 |
| " |    |                            |             |                 |
| 0 |    |                            |             |                 |
| . |    |                            |             |                 |
| 1 |    |                            |             |                 |
| 7 |    |                            |             |                 |
| 7 |    |                            |             |                 |
| 7 |    |                            |             |                 |
| 7 |    |                            |             |                 |
| 7 |    |                            |             |                 |
| 7 |    |                            |             |                 |
| 7 |    |                            |             |                 |
| 7 |    |                            |             |                 |
| 7 |    |                            |             |                 |
| 7 |    |                            |             |                 |
| 7 |    |                            |             |                 |
| 7 |    |                            |             |                 |
| 7 |    |                            |             |                 |
| 7 |    |                            |             |                 |
| 7 |    |                            |             |                 |
| 8 |    |                            |             |                 |
| i |    |                            |             |                 |
| n |    |                            |             |                 |
| " |    |                            |             |                 |
| h |    |                            |             |                 |
| e |    |                            |             |                 |
| i |    |                            |             |                 |
| g |    |                            |             |                 |
| h |    |                            |             |                 |
| t |    |                            |             |                 |
| = |    |                            |             |                 |
| " |    |                            |             |                 |
| 0 |    |                            |             |                 |
| . |    |                            |             |                 |
| 2 |    |                            |             |                 |
| 0 |    |                            |             |                 |
| 7 |    |                            |             |                 |
| 6 |    |                            |             |                 |
| 3 |    |                            |             |                 |
| 8 |    |                            |             |                 |
| 8 |    |                            |             |                 |
| 8 |    |                            |             |                 |
| 8 |    |                            |             |                 |
| 8 |    |                            |             |                 |
| 8 |    |                            |             |                 |
| 8 |    |                            |             |                 |
| 8 |    |                            |             |                 |
| 8 |    |                            |             |                 |
| 8 |    |                            |             |                 |
| 9 |    |                            |             |                 |
| i |    |                            |             |                 |
| n |    |                            |             |                 |
| " |    |                            |             |                 |
| } |    |                            |             |                 |
+---+----+----------------------------+-------------+-----------------+
|   | 4  | Unzip contents of SS2.0    |             |                 |
|   | .1 | Checklist Scripts -        |             |                 |
|   |    | dbms.zip to your           |             |                 |
|   |    | SSW                        |             |                 |
|   |    | R10_DbUtilities/DbaScripts |             |                 |
|   |    | folder.                    |             |                 |
+---+----+----------------------------+-------------+-----------------+
|   | 4  | SIR 13849 -- MS SQL Server | n/a         | Event 13849     |
|   | .2 | Only -- County FIPS codes  |             | County          |
|   |    | were not being prefixed    |             | Codes.SQL       |
|   |    | with correct               |             |                 |
|   |    | two-characters.            |             |                 |
+---+----+----------------------------+-------------+-----------------+
|   | 4  | **CHECKPOINT Evaluate your |             |                 |
|   | .3 | data to this point before  |             |                 |
|   |    | proceeding**               |             |                 |
+---+----+----------------------------+-------------+-----------------+
|   | 4  | SIR 14058 --               | 1405        | 14058_sswr      |
|   | .4 |                            | 8_sswr1.sql | 1_SQLServer.sql |
|   |    | The script selectively     |             |                 |
|   |    | deletes records in         |             |                 |
|   |    | TINTUFR, TINTUMSR, and     |             |                 |
|   |    | TINTUIND in SSWr1 schema.  |             |                 |
|   |    |                            |             |                 |
|   |    | As part of the SSWr1       |             |                 |
|   |    | schema migration, for each |             |                 |
|   |    | record in SDWIS/STATE 8.0  |             |                 |
|   |    | TINUNPRO table,            |             |                 |
|   |    |                            |             |                 |
|   |    | -seven records were        |             |                 |
|   |    | populated in the SSWr1     |             |                 |
|   |    | TINTUFR table              |             |                 |
|   |    |                            |             |                 |
|   |    | -seven records were        |             |                 |
|   |    | populated in the SSWr1     |             |                 |
|   |    | TINTUMSR table             |             |                 |
|   |    |                            |             |                 |
|   |    | -three records were        |             |                 |
|   |    | populated in the SSWr1     |             |                 |
|   |    | TINTUIND table             |             |                 |
|   |    |                            |             |                 |
|   |    | This script deletes        |             |                 |
|   |    | records in the SSWr1       |             |                 |
|   |    | TINTUFR, TINTUMSR, and     |             |                 |
|   |    | TINTUIND where value of    |             |                 |
|   |    | quantity column            |             |                 |
|   |    | (T                         |             |                 |
|   |    | INTUFR.FLOW_RATE_QUANTITY, |             |                 |
|   |    | TINTUMSR.MEASURE_QUANTITY, |             |                 |
|   |    | TI                         |             |                 |
|   |    | NTUIND.INDICATOR_VALUE_CD) |             |                 |
|   |    | is zero/null/space.        |             |                 |
+---+----+----------------------------+-------------+-----------------+
|   | 4  | **CHECKPOINT Evaluate your |             |                 |
|   | .5 | data to this point before  |             |                 |
|   |    | proceeding**               |             |                 |
+---+----+----------------------------+-------------+-----------------+
|   | 4  | SIR 13624/15535            | MRD         | MRDL_DATES.SQL  |
|   | .6 |                            | L_DATES.SQL |                 |
|   |    | ACTION : This fixes an     |             |                 |
|   |    | issue with MRDL RAA        |             |                 |
|   |    | calculations. Run this     |             |                 |
|   |    | script one time.           |             |                 |
+---+----+----------------------------+-------------+-----------------+
|   | 4  | **CHECKPOINT Evaluate your |             |                 |
|   | .7 | data to this point before  |             |                 |
|   |    | proceeding**               |             |                 |
+---+----+----------------------------+-------------+-----------------+
|   | 4  | SIR 15785: SDWIS/STATE Web | Even        | Event_15785.    |
|   | .8 | 1 schema migration did not | t_15785.SQL |                 |
|   |    | migrate a casing record    |             | .SQL            |
|   |    | into SDWIS/STATE Web 1 if  |             |                 |
|   |    | the SDWIS/STATE 8.0 well   |             |                 |
|   |    | did not have all three     |             |                 |
|   |    | pieces of casing           |             |                 |
|   |    | information (Diameter,     |             |                 |
|   |    | Depth, and Type).          |             |                 |
+---+----+----------------------------+-------------+-----------------+
|   | 4  | **CHECKPOINT Evaluate your |             |                 |
|   | .9 | data to this point before  |             |                 |
|   |    | proceeding**               |             |                 |
+---+----+----------------------------+-------------+-----------------+

You are now ready to proceed with SDWIS/STATE 2.0 installation. Download
the installation package and documentation from the EPA website
(<http://www.epa.gov/safewater/sdwis_st/current.html> ) and follow all
instructions.