Re^2: perl and switching between different version servers

[phineas629]

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

[marto]

Please consider answering the questions I asked regards the code.

[phineas629]

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

[ig]

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?