Beefy Boxes and Bandwidth Generously Provided by pair Networks
Think about Loose Coupling

Re: Automated detection of different tables with same name

by marto (Archbishop)
on May 15, 2006 at 12:15 UTC ( #549453=note: print w/replies, xml ) Need Help??

in reply to Automated detection of different tables with same name


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.
  • Comment on Re: Automated detection of different tables with same name

Replies are listed 'Best First'.
Re^2: Automated detection of different tables with same name
by Fletch (Chancellor) on May 15, 2006 at 12:57 UTC

    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.

    Now what I want to know is . . . where's my pony?

      Now what I want to know is . . . where's my pony?
      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 "" 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.
      'Now what I want to know is . . . where's my pony?'

      That puts me in mind of a Family Guy sketch:

      "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. "


      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 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)

      But I have not changed the core request. Word for word it is the same.

        Blah, blah, blah, blah. It's always about you and your SQL problems. Stop the stonewalling and dissembling. Where's my pony?

        Where's my pony?

        The PerlMonkian people will not be distracted from the essential issues in this election, and I will not cease speaking Truth to Pony until we get our answers.

        Or my pony.

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://549453]
and all is quiet...

How do I use this? | Other CB clients
Other Users?
Others imbibing at the Monastery: (4)
As of 2018-04-27 03:48 GMT
Find Nodes?
    Voting Booth?