I added this line at the end of the script (after getopts), maybe the approach is wrong..

if [ $# -eq "3" ]; then
"Option 1 specified -s -d -u"
elif [ $# -eq "2" ]; then
"Option 2 specified -d and -f"
fi

However $# always evaluates to 6 if provide the option
scriptname -d databasename -u username -s schemaname. How did it arrive at 6 ?