Yes we can do all the table validations using one connection.

Since to reduce the comparison time, i am runnig this script on different servers for different tables. Now i cannot have a database connection persistent across servers.

At the maximum, i can have one open connection per server. But again controlling the opening and closing of connections on different servers would be difficult unless you have a control mechanism.

This is the reason why we are trying to implement connection pooling