Beefy Boxes and Bandwidth Generously Provided by pair Networks
laziness, impatience, and hubris
 
PerlMonks  

Re^2: perl and switching between different version servers

by phineas629 (Novice)
on Dec 05, 2012 at 21:18 UTC ( #1007398=note: print w/ replies, xml ) Need Help??


in reply to Re: perl and switching between different version servers
in thread perl and switching between different version servers

Hi Marto,

Does it have anything to do with the connection using WIN32::ODBC;? Should I consider connecting to through the DBI module instead? The programmer is no longer around and I'm just stuck with this code.

thanks


Comment on Re^2: perl and switching between different version servers
Re^3: perl and switching between different version servers
by marto (Chancellor) on Dec 05, 2012 at 21:32 UTC

    Please consider answering the questions I asked regards the code.

      "So are you currently running SQL server 2005? Does this code actually work as you expect it to? Have you considered asking the programmer who wrote this for an explanation of this? I don't see any SQL which I think would require one version of SQL Server over the other. Could there be problems with the ODBC drivers/DSNs on your system?"

      The original DB resides on a 2005 server. I have to copy the DB from 2005 and insert it to a 2008r2 server. Then I export the DB from 2008r2 to the 2000 server so I can run the perl script. After the perl script runs then I bring the DB back to its orginal 2005 server.

      The perl script works but the process takes a while when I'm working with so many databases. I assume there has got to be an easier solution.

      The programmer is no longer around.

      I have a feeling it is related to the ODBC drivers/DSNs on my system. But I don't know much about how ODBC works beyond me being able to use it to connect to DBs.

      Once again thanks!

        Did you solve your problem?

        I have to copy the DB from 2005 and insert it to a 2008r2 server. Then I export the DB from 2008r2 to the 2000 server so I can run the perl script. After the perl script runs then I bring the DB back to its orginal 2005 server.

        That sounds like a lot of work. I can understand why you might want to avoid it. Are these copies exact copies, or are you transoforming the data somehow?

        I presume you have tried running your script directly against the SQL Server 2005 database instance. If you do, what happens? Does the script produce an error message? If so, what is it?

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others taking refuge in the Monastery: (5)
As of 2014-08-01 03:48 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    My favorite superfluous repetitious redundant duplicative phrase is:









    Results (256 votes), past polls