February 27, 2015 at 7:39 am
Yes the Same amount of data between SQL Server and Access.
I was testing how long it takes to pull the data.
The real extraction that I need is batch oriented and did move to a new database on a new server and the result was about the same on the amount of time it took to extract the data from linked servers.
Anyways, the Exec command provided earlier did seem to work to what I need for now.
I am kinda surprised that no one else has ran into the same problem.
February 27, 2015 at 7:48 am
You're only seeing things from the client end of an ETL process. Perhaps there is some difference in the data retreival method used by MS Access versus SQL Server. My knowledge of AS400 is limited, but whomever is the system admin on that database, ask them if there is something equivalent to a SQL profiler trace or viewing the execution plan that might be helpful.
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
February 27, 2015 at 8:20 am
"The real extraction that I need is batch oriented and did move to a new database on a new server and the result was about the same on the amount of time it took to extract the data from linked servers."
What do you mean?
You don't need to set up a linked server to extract data from AS400.
My knowledge is a bit old but I used an ODBC driver to pull data from the AS400 to
a database in SQL server. Your description indicates a speed limitation pulling out
data from AS400 so as suggested look there.
Gosta M
Viewing 3 posts - 16 through 17 (of 17 total)
You must be logged in to reply to this topic. Login to reply