#!/bin/sh

# SQL-BackTrack for Sybase - Copyright (c) 1995
#%DT%SQL-BackTrack  

# Script: One Time SQL backtrack calling
# Purpose: for special occurences...constantly adding lines..
# creation history
# date          author  purpose
# 04/22/97      T.Boss  creation

DTBASE=/export/datatools; export DTBASE
DT_SBACKTRACK_HOME=/export/datatools/0; export DT_SBACKTRACK_HOME
SYBASE=/export/sybase11; export SYBASE
DTTEMPDIR=/export/datatools/tmp; export DTTEMPDIR

#########

# incremental dump of all three big databases CDB, hss, issc
#$DTBASE/0/bin/dtsbackup -level 9 $DTBASE/special/prod11 -tasks 3

# test of the -options -contents dump...isn't useful
#$DTBASE/0/bin/dtsbackup $DTBASE/full_phys/prod11/model -tasks 3 \
#-options '-contents'

# incremental dump of issc
#$DTBASE/0/bin/dtsbackup -level 9 $DTBASE/special/prod11/issc -tasks 3

# Testing to see how -dryrun option looks at various dumpfile types
#$DTBASE/0/bin/dtsload -from /news/prod11/database/model* -dryrun
#$DTBASE/0/bin/dtsload -from \
#  /news/prod11/transaction/hss-0.02-05-1997.07:01-4938 -dryrun

# object level backup of work tables in hss for Mckeeby
# could have looped it via dtsdump commmand...duh
#hssmn1996dups hssmn1996nodup hssmn1997dups hssmnlvhmods hss_itest
#$DTBASE/0/bin/dtsbackup $DTBASE/full_logical/prod11/hss -options  \
#  '-object hss_itest'

# test of object level load for Mckeeby's sanity
#$DTBASE/0/bin/dtsload -from /news/prod12/logical/hss.hssmnlvhmods.dmp

# load crimson dumps into prod11 with the copy over command...used to 
# port crimson databases to System 11
#$DTBASE/0/bin/dtsrecover $dtbase/full_logical/crimson/cimp \
#-copyover -server prod11              

load_cdr ()
{
# load cdr transaction files
for name in \
cdr-0.27-05-1997.07:01-11465 \
cdr-0.27-05-1997.08:01-12839 \
cdr-0.27-05-1997.09:01-14269 \
cdr-0.27-05-1997.10:01-15753 \
cdr-0.27-05-1997.12:01-18702 \
cdr-0.27-05-1997.13:01-20153
do
   echo $name
   $DTBASE/0/bin/dtsload -from /news/prod12/transaction/$name
done
}

$DTBASE/0/bin/dtsload -physical -server prod11 -database prrc_old \
-from /news/prod12/hold/prrc.sqlbacktrack.6597

######################################################################3