Sree_sri , if you take a look at my first post this is exactly what I did but got an error.
well anyways I was able to find a solution for the problem.
It was because global_names was set to true in my sid7 database and was false in the sid8 database hence this conflict.
I set it to false and it works fine now.
Thanks a lot for your patience and helping me out.