Re: Need Help Exporting a Progress Table
- From: "Steve Foley" <steve.foley@xxxxxxxxxxxxxx>
- Date: Mon, 05 Mar 2007 13:38:14 GMT
"Whoolio" <shashibritto@xxxxxxxxx> wrote in message
news:1172691636.321615.20530@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
To anyone who can help me as I am near the end.
Situation: I have created a web app using visual studio 2005. This
apllication connects to a progress database using a Data Direct SQL92
V9.1E driver. I can actually retrive data on a webpage using a SQL
reader in ASP. The problem is that it slows down every user using
Apogee ( The ERP system using progress) and occasioanly crashes the
database. All I am using is a simple select query ( no joins).
In order to stop using this database and just use SQL Server 2005 I
would like to export three tables from this Progress database and
import them into SQL server 2005. Is there a way to do this? Atleast
help me export the data to a coma delemited file I will figure out a
way to put it into SQL server. Progress resides on a UNIX server is
there a way to automate this process so that it runs every night?
Problems.! I would be very gratefull if someone could provide me a
script or a way to do this (I have no budget to do this so freeware is
preffered)
Thank You
A simple progress program would do this for you.
for each tablename:
export delimiter "," tablename.
end.
however, doing this with no progress knowledge is unlikely.
Why don't you set up a task to run overnight on the Windows side to pull the
data using ODBC and populate the SQL database with that?
.
- Next by Date: Re: Progress Developer Needed!!!
- Next by thread: Re: Need Help Exporting a Progress Table
- Index(es):
Relevant Pages
|
