arev export (AREV Specific)
At 27 OCT 1997 11:33:03AM A. Howard wrote:
Is there a way to get data out of AREV and into another database, specifically MS-SQL. I would like this to be a hands off effort (like using a ODBC data source). I realize that AREV does not support this, but I was wondering if there is some other utility or program that might fit my need. I do not want to have to use the export routines, then import this data down stream.
Thanks
AH
At 27 OCT 1997 12:55PM Dsig (SigSolutions) wrote:
Howard,
The first method would be to use the 'text' export. This would allow you to use BCP to import .. which is very fast.
The second method would be to use the Sql Bond. Whether this would work with your specific version of arev .. well your best bet is to contact RTI directly.
dsig
David Tod Sigafoos ~ SigSolutions
[email protected] CIS: 70302,77 Voice: 503-639-8080
NOTICE FOR RTI FORUMS: The message above is an answer to a user request and should
be taken as personal opinion only.
Although care was taken to not hurt anyones feelings or impugn the quality of any product, support or idea IF there is an
exception taken please note in detail the offending portion of the note and email me. I will take all notes under advisement.
At 28 OCT 1997 02:04PM Karen Layton wrote:
I looked into this too… depending on your version of AREV, OpenInsight can read you Arev data and communicate with SQL Server 6.5 and not necessarily affect your Arev application. Of course you'd have to do some work on the OpenInsight side. I didn't get far with this before my project changed direction… but I'm sure there are others who may be able to give you more insight.
At 29 OCT 1997 02:49PM Sandra Wolstenholm wrote:
There is an Arev to MSAccess export program available. Contact Resource Match, Inc. at 1-800-593-5654 or e-mail [email protected] or [email protected] for a copy of 2ACCESS.
Sandra
Echo Management Group
At 31 OCT 1997 03:02AM Bizsoft wrote:
Bizsoft is currently about 80% complete on a new product that will basically spit LH files to a
access database at the DOS level, i.e. no ODBC required, no arev processes required, etc.
The product is geared for use by developers and users alike. Simple interface for ad-hoc user;
more powerful features such as batch processing for developers.
Developers will be able to add batch conversion command code to their OI, AREV, Visual Basic,
C++, Delphi, whatever.
If you'd like to get on the notice mailing list please leave an email to [email protected]
At 31 OCT 1997 11:26AM Victor wrote:
What happens if the file is being resized (or otherwise modified) during the copy process?
At 01 NOV 1997 07:49PM Bizsoft wrote:
Victor,
The product does not 'copy' the files. All files are
opened and then read directly at the frame level.
It is possible that records could get missed because of
resizing taking place at the same time. The solution of
course is to not use it while another user is in it.