Attached is a 20-year old example script.
#!/bin/sh
echo "This script migrates ASE RSSD to ASA eRSSD";
# This function expects two parameters:
# table_name
# a select statement with order by using primary key
migrate()
{
echo "Truncating target table $1...";
echo "Truncating target table $1..." >> $0.out;
(echo "truncate table $1" ; echo go ) | $SYBASE/$SYBASE_OCS/bin/isql -U dbo -P dbo -S $eRSSDServer
echo "Copying table $1 from ${ASEServer}.$ASEdb to $eRSSDServer...";
echo "Copying table $1 from ${ASEServer}.$ASEdb to $eRSSDServer..." >> $0.out;
$SYBASE/$SYBASE_REP/bin/rs_subcmp -S $ASEServer -s $eRSSDServer -c "$2" -t dbo.$1 -U $ASEuser -u dbo -p dbo -D $ASEdb -n 0 -r $ASEpwdParam
if [ "$?" = 1 ]
then
echo "Command failed for $1";
echo "Command failed for $1" >> $0.out;
echo -n "$SYBASE/$SYBASE_REP/bin/rs_subcmp -S $ASEServer -s $eRSSDServer -c \"";
echo -n "$2";
echo "\" -t dbo.$1 -U $ASEuser -u dbo -p dbo -D $ASEdb -n 0 -r $ASEpwdParam";
echo -n "$SYBASE/$SYBASE_REP/bin/rs_subcmp -S $ASEServer -s $eRSSDServer -c \"" >> $0.out;
echo -n "$2" >> $0.out;
echo "\" -t dbo.$1 -U $ASEuser -u dbo -p dbo -D $ASEdb -n 0 -r $ASEpwdParam" >> $0.out;
exit 1;
fi
}
get_input()
{
echo " ";
echo -n "Please enter the ASE RSSD server name: ";
read ASEServer;
echo -n "Please enter the ASE RSSD db name: ";
read ASEdb;
echo -n "Please enter the ASE user name: "
read ASEuser;
echo -n "Please enter the ASE user password: "
read ASEpwd;
echo -n "Please enter the ASA eRSSD server name: ";
read eRSSDServer;
echo " "
echo "ASE RSSD server name: $ASEServer";
echo "ASE RSSD db name: $ASEdb";
echo "ASE user name: $ASEuser";
echo "ASE user password: $ASEpwd";
echo "ASA eRSSD server name: $eRSSDServer";
echo -n "Is the information correct? [y/n/q]";
read correct;
}
get_input;
while [ "$correct" != "y" ]
do
if [ "$correct" = "q" ]
then
exit 0;
fi
get_input;
done
echo "ASE RSSD server name: $ASEServer" >> $0.out;
echo "ASE RSSD db name: $ASEdb" >> $0.out;
echo "ASE user name: $ASEuser" >> $0.out;
echo "ASE user password: $ASEpwd" >> $0.out;
echo "ASA eRSSD server name: $eRSSDServer" >> $0.out;
if [ $ASEpwd ]
then
ASEpwdParam="-P $ASEpwd";
else
ASEpwdParam="";
fi
# Now migrate each table
migrate rs_classes "select * from rs_classes order by classname, classtype";
migrate rs_columns "select * from rs_columns order by objid, colname";
migrate rs_config "select * from rs_config order by optionname, objid";
migrate rs_debugconfig "select * from rs_debugconfig order by optionname, objid";
migrate rs_datatype "select * from rs_datatype order by dtname";
migrate rs_databases "select * from rs_databases order by ltype, dsname, dbname";
migrate rs_diskaffinity "select * from rs_diskaffinity order by dbid_or_siteid";
migrate rs_diskpartitions "select * from rs_diskpartitions order by logical_name"
migrate rs_erroractions "select * from rs_erroractions order by ds_errorid, errorclassid";
migrate rs_functions "select * from rs_functions order by funcname, objid";
migrate rs_ids "select * from rs_ids order by objtype";
migrate rs_idnames "select * from rs_idnames order by name1, name2, ltype";
migrate rs_locater "select * from rs_locater order by sender, type";
migrate rs_maintusers "select * from rs_maintusers order by destid";
migrate rs_objects "select * from rs_objects order by objname";
migrate rs_oqid "select * from rs_oqid order by origin_site_id, q_number, q_type";
migrate rs_queues "select * from rs_queues order by number, type";
migrate rs_exceptshdr "select * from rs_exceptshdr order by sys_trans_id";
migrate rs_exceptscmd "select * from rs_exceptscmd order by cmd_id";
migrate rs_exceptslast "select * from rs_exceptslast order by error_db, origin";
migrate rs_repdbs "select * from rs_repdbs order by dbid";
migrate rs_routes "select * from rs_routes order by dest_rsid, source_rsid";
migrate rs_rules "select * from rs_rules order by subid, colnum";
migrate rs_segments "select * from rs_segments order by partition_id, partition_offset";
migrate rs_sites "select * from rs_sites order by id";
migrate rs_funcstrings "select * from rs_funcstrings order by classid, funcid, name";
migrate rs_subscriptions "select * from rs_subscriptions order by subid";
migrate rs_systext "select * from rs_systext order by parentid, texttype, sequence";
migrate rs_translation "select * from rs_translation order by classid, source_dtid";
migrate rs_users "select * from rs_users order by username";
migrate rs_repobjs "select * from rs_repobjs order by objid, dbid";
migrate rs_queuemsg "select * from rs_queuemsg order by q_number, q_type, q_seg, q_blk, q_row";
migrate rs_queuemsgtxt "select * from rs_queuemsgtxt order by q_number, q_type, q_seg, q_blk, q_row, q_seq";
migrate rs_recovery "select * from rs_recovery order by id";
migrate rs_version "select * from rs_version order by siteid";
migrate rs_routeversions "select * from rs_routeversions order by dest_rsid, source_rsid";
migrate rs_articles "select * from rs_articles order by articlename, pubid";
migrate rs_publications "select * from rs_publications order by pubname, pdbid";
migrate rs_whereclauses "select * from rs_whereclauses order by wclauseid";
migrate rs_statcounters "select * from rs_statcounters order by counter_id";
migrate rs_statdetail "select * from rs_statdetail order by run_id, instance_id, instance_val, counter_id";
migrate rs_statrun "select * from rs_statrun order by run_id";
migrate rs_dbreps "select * from rs_dbreps order by dbid, dbrepname";
migrate rs_dbsubsets "select * from rs_dbsubsets order by dbrepid, type, owner, name";
migrate rs_lastcommit "select * from rs_lastcommit order by origin";
migrate rs_threads "select * from rs_threads order by id";
This is provided without any warranties. As this is an older example, you will probably have to alter it to ensure all objects are migrated correctly.
Bluesky
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.