#!/bin/bash
# This script will test if you have given a leap year or not.
echo "Enter DB Servername :"
read servername
echo "Enter Server Instance (optional) :" 
read instancename 
echo "Enter Port Number : "
read portnumber
echo "Enter Database Name :"
read dbname
echo "Enter User Name :" 
read username
echo "Enter Password :" 
read  password

echo ******PROCESSING QUERY******
echo $instancename

server="$servername\\$instancename"

if [ $instancename = ""]; then
sever=$servername
fi

d=`dirname $0`

echo $server

sqlcmd -U $username -P $password -S $server,$portnumber -d $dbname -i $d/"cleartables.sql" -o $d/"cleartables.log"

echo Check logs into $d/"cleartables.log"
