SQL Auto Update

[glebreck]

Hello,
I have a fairly good knowledge of SQL, but let me explain my problem.
We are building a ASP web application from a database on a AS400. As you can guess, access times are very slow comparied to the same databases set up on a SQL server. I am trying to find options for better access times.
Converting to SQL will not be an option as the whole business is built on th AS400. But I was wondering if it was possible to have the same database on a SQL server and if there was a way to update tables on the SQL server when they are changed or added to on the As400?
Eventually we will go all SQL but for now this application has to have a solution.
Any ideas would be greatly appreciated.
Thanks!

 

[LloydDobler]

hello, we are running into the same issues here. What we're doing is setting up a DTS package that will copy info from the 400 at off peak hours.

Al

Be quiet Brain, or I'll stab you with a Q-tip! (Homer Simpson)