HowToInstallNewVersions: copy.sql

/*========================================================================
 *
 * This script file contains code used to copy all the data from a renamed
 * backup schema to the just created new structure.
 * For the NM DEPARTMENT OF HEALTH IBIS SYSTEM.  
 *
 * Date Modified   By Whom    Description
 * -------------   --------   -------------------------------------------
 *  5/28/2009      GLB        Initial.
 *========================================================================*/
use IBISPH

insert CATEGORIZED_INDEX              select * from ibisph_backup.dbo.CATEGORIZED_INDEX
insert CHART                          select * from ibisph_backup.dbo.CHART

insert DATASET_CATEGORY               select * from ibisph_backup.dbo.DATASET_CATEGORY
insert DATASET_CATEGORY_VALUE         select * from ibisph_backup.dbo.DATASET_CATEGORY_VALUE
insert DATASET_SERIES                 select * from ibisph_backup.dbo.DATASET_SERIES
insert DATASET_SERIES_VALUE           select * from ibisph_backup.dbo.DATASET_SERIES_VALUE
insert DATA_SOURCE                    select * from ibisph_backup.dbo.DATA_SOURCE
insert DATA_SOURCE_TO_INDICATOR       select * from ibisph_backup.dbo.DATA_SOURCE_TO_INDICATOR
insert DATA_SOURCE_TO_INDICATOR_VIEW  select * from ibisph_backup.dbo.DATA_SOURCE_TO_INDICATOR_VIEW
insert HEALTHY_PEOPLE_OBJECTIVE       select * from ibisph_backup.dbo.HEALTHY_PEOPLE_OBJECTIVE
insert HEALTHY_PEOPLE_OBJ_FOCUS_AREA  select * from ibisph_backup.dbo.HEALTHY_PEOPLE_OBJ_FOCUS_AREA
insert INDICATOR                      select * from ibisph_backup.dbo.INDICATOR
insert INDICATOR_EDITOR               select * from ibisph_backup.dbo.INDICATOR_EDITOR
-- insert INDICATOR_VIEW                 select * from ibisph_backup.dbo.INDICATOR_VIEW
insert INDICATOR_VIEW
  (
   NAME, INDICATOR_NAME, CHART_NAME, TITLE, SUB_TITLE, Y_TITLE,VALUE_TYPE_NAME,
   DATA_NOTE, DESCRIPTION, DATASET_SERIES_NAME, DATASET_CATEGORY_NAME,
   SORT_ORDER, NOTE, ACTIVE_FLAG, MODIFIED_DATE
  )
select 
  (
   NAME, INDICATOR_NAME, CHART_NAME, TITLE, SUB_TITLE, Y_TITLE,VALUE_TYPE_NAME,
   DATA_NOTE, DESCRIPTION, DATASET_SERIES_NAME, DATASET_CATEGORY_NAME,
   SORT_ORDER, NOTE, ACTIVE_FLAG, MODIFIED_DATE
  )
from ibisph_backup.dbo.INDICATOR_VIEW

insert INDICATOR_VIEW_VALUE           select * from ibisph_backup.dbo.INDICATOR_VIEW_VALUE
insert INDICATOR_VIEW_VALUE_QUERY     select * from ibisph_backup.dbo.INDICATOR_VIEW_VALUE_QUERY
insert INDICATOR_RELATION             select * from ibisph_backup.dbo.INDICATOR_RELATION
insert INDICATOR_TO_IND_RELATION      select * from ibisph_backup.dbo.INDICATOR_TO_IND_RELATION

insert NAVIGATION_MENU_ITEM           select * from ibisph_backup.dbo.NAVIGATION_MENU_ITEM
insert ORG_UNIT                       select * from ibisph_backup.dbo.ORG_UNIT
insert PRIVILEGE                      select * from ibisph_backup.dbo.PRIVILEGE

insert RELATION                       select * from ibisph_backup.dbo.RELATION
insert REQUEST                        select * from ibisph_backup.dbo.REQUEST

insert STATUS                         select * from ibisph_backup.dbo.STATUS
insert SURVEY_RESPONSE                select * from ibisph_backup.dbo.SURVEY_RESPONSE

insert TITLE                          select * from ibisph_backup.dbo.TITLE
insert VALUE_TYPE                     select * from ibisph_backup.dbo.VALUE_TYPE
/*------------------------------ END OF FILE ------------------------------*/