#!/bin/sh
#
#import.sh
#
export SYBASE=/sybase
export DSQUERY=prof
export PASSWD="password"
export SOURSE=briz
export TARGET=prof
export DBNAME=db2
export OWNNAME=dbo
#export EXPORT_OUT="/dev/stdout"
#export IMPORT_OUT="/dev/stdout"
export EXPORT_OUT="export"
export IMPORT_OUT="import"

# Source function library.
export_tb() {
#echo $1 >>${EXPORT_OUT}
#bcp $DBNAME.$OWNNAME.$1 out ./data/$1.$SOURSE -S$SOURSE -Usa -P$PASSWD -Jcp1251 -n >>${EXPORT_OUT}
date >./${DBNAME}_log/$1.${EXPORT_OUT}
bcp $1 out ./${DBNAME}_dat/$1.$SOURSE -S$SOURSE -Usa -P$PASSWD -Jcp1251 -n >>./${DBNAME}_log/$1.${EXPORT_OUT}
}
import_tb() {
#echo $1 >>${IMPORT_OUT}
#bcp $DBNAME.$OWNNAME.$1 in ./data/$1.$SOURSE -S$TARGET -Usa -P$PASSWD -Jcp1251 -n >>${IMPORT_OUT}
date >./${DBNAME}_log/$1.${IMPORT_OUT}
bcp $1 in ./${DBNAME}_dat/$1.$SOURSE -S$TARGET -Usa -P$PASSWD -Jcp1251 -n >>./${DBNAME}_log/$1.${IMPORT_OUT}
}

#echo "Starting export from " $SOURSE >$EXPORT_OUT
#date >>$EXPORT_OUT

for i in $(cat ./${DBNAME}.tbl); do
#echo "bcp $1 in ./data/$1.$SOURSE -S$TARGET -Usa -P$PASSWD -Jcp1251 -n >>./$1.${IMPORT_OUT} &"
import_tb $i
done

#!/bin/sh
#
#export.sh:
export SYBASE=/sybase
export DSQUERY=gnome
export PASSWD="newpassword"
export SOURSE=briz
export TARGET=prof
export DBNAME=db2
export OWNNAME=dbo
#export EXPORT_OUT="/dev/stdout"
#export IMPORT_OUT="/dev/stdout"
export EXPORT_OUT="export"
export IMPORT_OUT="import"

# Source function library.
export_tb() {
#echo $1 >>${EXPORT_OUT}
#bcp $DBNAME.$OWNNAME.$1 out ./data/$1.$SOURSE -S$SOURSE -Usa -P$PASSWD -Jcp1251 -n >>${EXPORT_OUT}
date >./${DBNAME}_log/$1.${EXPORT_OUT}
bcp $1 out ./${DBNAME}_dat/$1.$SOURSE -S$SOURSE -Usa -P$PASSWD -Jcp1251 -n >>./${DBNAME}_log/$1.${EXPORT_OUT} &
}
import_tb() {
#echo $1 >>${IMPORT_OUT}
#bcp $DBNAME.$OWNNAME.$1 in ./data/$1.$SOURSE -S$TARGET -Usa -P$PASSWD -Jcp1251 -n >>${IMPORT_OUT}
date >./${DBNAME}_log/$1.${IMPORT_OUT}
bcp $1 in ./${DBNAME}_dat/$1.$SOURSE -S$TARGET -Usa -P$PASSWD -Jcp1251 -n >>./${DBNAME}_log/$1.${IMPORT_OUT} &
}

#echo "Starting export from " $SOURSE >$EXPORT_OUT
#date >>$EXPORT_OUT

for i in $(cat ./${DBNAME}.tbl); do
#echo "bcp $1 in ./data/$1.$SOURSE -S$TARGET -Usa -P$PASSWD -Jcp1251 -n >>./$1.${IMPORT_OUT} &"
export_tb $i
done

prof.tbl:

db2.dbo.zt_article
db2.dbo.zt_article_using
db2.dbo.zt_articles_group
db2.dbo.zt_articles_sod
db2.dbo.zt_bank
db2.dbo.zt_buf_job_title
db2.dbo.zt_buf_leave_type
db2.dbo.zt_buf_nsi_kateg
db2.dbo.zt_buf_nsi_per
db2.dbo.zt_buf_nsi_usl_rab
db2.dbo.zt_buf_nsi_zabol
db2.dbo.zt_buf_slist_type
db2.dbo.zt_charge_rule
db2.dbo.zt_computers
db2.dbo.zt_config
db2.dbo.zt_doc_forma
db2.dbo.zt_doc_kind
db2.dbo.zt_enterprise
db2.dbo.zt_gni

1.Создать новую БД
2.Создать скрипт структуры БД-источника программой DB Artisan
3.Закачать структуру в новую БД
4.Выкачать данные со старой БД скриптом export.sh
5.Закачать данные в новую БД скриптом import.sh
6.Помучиться со ссылочной целостностью и заливкой некоторых процедур (кот используют tempdb)