This seems quite similar to Comparing databases - what is the best way?, did none of the advice given help you? It seems to me, based on previous discussion, that you should spend some time familiarising yourself with the MS SQL Server product more. You should look at Compare SQL Server Databases with sp_CompareDB which illustrates a stored procedure to achieve this goal. You could then call this stored procedure via Perl, as you already know how to do that, having looked at your previous posts on this subject.
Hope this helps
Update.Win, to avoid any confusion please mark updates you have made to your questions after posting them.
Re: Automated detection of different tables with same name
But that's not the Win style. Off-topic SQL questions stealth updated to try and give the thinnest veneer of some slim splinter of being possibly somewhat maybe tangentially Perl-related, that's the Winning way.
"Peter (to Meg): Remember that pony you wanted when you were 6? Well I've been waitin for a time like this.(opens closet door and a skeleton of a pony is there)
Peter: Oh, oh god, that's right ponies, ponies like food. "
Before you post questions like this, you really should do at least a basic search of the CPAN. If you'd done that, you might have discovered Acme::Pony on your own. As it is, you effectively appear to be asking us to do your search for you, as if you are somehow too lazy to use punch "search.cpan.org" into your browser's address bar yourself, or something. The thing is, it effectively costs you time, because it takes you longer to post the question (to say nothing of waiting for the answer) than to just do the search and find the answer. Next time, try doing a basic search before posting this kind of question. It'll get you faster results and keep you from looking foolish. HTH.HAND.
Of course, you could be talking about Ponie - the attempt to superglue the parrot onto its perch (Maybe it's pining for the fjords)
Anyway, the concept of "I want my pony" was indirectly responsible for the name "Ponie" via London.pm with a few beers as catalyst.
The Ocado UK internet grocery service was marketed using a series of spoiled brats, and I also notice that Ocado stocks the "My little pony" series. Oh well :)
Oh Lord, won’t you burn me a Knoppix CD ?
My friends all rate Windows, I must disagree.
Your powers of persuasion will set them all free,
So oh Lord, won’t you burn me a Knoppix CD ? (Missquoting Janis Joplin)