Re: Need Help Exporting a Progress Table
- From: "scottauge@xxxxxxxxx" <scottauge@xxxxxxxxx>
- Date: 22 Mar 2007 06:44:59 -0700
On Feb 28, 2:40 pm, "Whoolio" <shashibri...@xxxxxxxxx> wrote:
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
Something is wrong with your ODBC connection or how ever you are
connecting to Progress. Unless your select returns like, a million
rows or something, I don't understand any other reason for it to be
slowing down the other users.
There is code in
http://amduus.com/OpenSrc/SrcLib/pro2pgsql/
which can allow you to export progress data as INSERT statements. You
will need to touch it up some though and a compiler licenses.
Best bet - figure out what is going on with the ODBC connection.
.
- Prev by Date: Re: Migrating v7
- Next by Date: PROBKUP error codes?
- Previous by thread: Re: Need Help Exporting a Progress Table
- Next by thread: Re: Progress Developer Needed!!!
- Index(es):
Relevant Pages
|
