Beefy Boxes and Bandwidth Generously Provided by pair Networks
XP is just a number
 
PerlMonks  

Re: Automated detection of different tables with same name

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


in reply to Automated detection of different tables with same name

Win,

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

Martin

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 (Bishop) 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 "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.
      '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. "

      Martin

      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)

    A reply falls below the community's threshold of quality. You may see it by logging in.

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://549453]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others taking refuge in the Monastery: (7)
As of 2024-04-18 02:59 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found