[[https://www.revelation.com/|Sign up on the Revelation Software website to have access to the most current content, and to be able to ask questions and get answers from the Revelation community]]
==== AREV data conversion to Sybase SQL Server (AREV Specific) ====
=== At 05 NOV 1997 12:26:50PM Heidi Gray wrote: ===
{{tag>"AREV Specific"}}
I am currently using a software product built using AREV. I have never used the product or AREV before, what I would like to do is convert the data to Sybase SQL server. Does any one have any ideas on how I can do this? I have talked to some people and found out I can export the data to an ASCII file and then write a program in OpenInsight to do the conversion, is this the only way?
Please e-mail with any thoughts or ideas
heidi.gray@spcmail.stpaul.com
Thanks
Heidi Gray
----
=== At 05 NOV 1997 12:43PM JPryor wrote: ===
Heidi,
If the application you are converting FROM includes the development version of AREV (some AREV apps are Runtime only), the mechanical aspects of getting the data out of AREV should not be a major problem. If you do not have the development tools, you may have to aquire them or hire someone who does.
AREV support variable length and multi-valued data elements. Thus many AREV databases do not line up "record-to-row". The multi-valued fields in a table will usually need to be written to a related table. Careful program editing of the data in AREV may simplify loading the Sybase table depending upon the constraints you have set in the Sybase database.
Not being a Sybase guru, if Sybase supports a dBase table load and if non of the dBase table limits are exceeded ((more than 255 fields, more than 255 chars in a field), a simpler way to move the data would be to create dBase structures for the Sybase system, then "BOND" in AREV to those tables and write the data into the dBase tables. This way you could handle type conversion errors on the export process.
I realize this has not been very specific but I wanted to mention some issues and options. Unless you have OPENINSIGHT, I am not sure what advantage that would provide unless through ODBC capability with which I have not yet played.
Good Luck
----
=== At 06 NOV 1997 09:45AM Tracy Graves wrote: ===
Heidi-
Using OpenInsight to convert to Sybase only requires that
the data can be "seen" by OpenInsight (which is relatively easy to do)
and that you have an ODBC driver for Sybase tables. You would also
need to have a knowledge of the structure of Sybase databases so
you can tell the DataWarehousing Wizard in OpenInsight what
datatypes to use for your current fields.
What you would need to do is:
a) convert you AREV tables so that OI can see them (change the dots to underscores
in table names, etc.)
[url=http://www.revelation.com/WebSite/knowledge.nsf/88e0581886ff6a0d8525651c004caecf/a9a56524aacfb93585256311006096a2?OpenDocument]Converting ARev Applications to OpenInsight[/url]
b)get an ODBC driver for Sybase
c)use the datawarehousing utility in OI
[url=http://www.revelation.com/WebSite/knowledge.nsf/88e0581886ff6a0d8525651c004caecf/60f038c80f1f9e778525653a007652ba?OpenDocument]Using the DataWarehousing Feature in OI[/url]
Hope that helps you out.
Tracy
----
=== At 07 NOV 1997 01:37PM Robert Lynch wrote: ===
Find somebody willing to part with their SQL SERVER bond.
This was a product that was at one time sold and supported by RTI.
Alas, they have stopped supporting or selling it. This product allowed
AREV to "talk" directly with SQL SERVER. Note I said SQL server. Earlier verisons
of Microsoft SQL SERVER were almost identical to the SYBASE product. This was a result
of their earlier collabaration. I believe the 4.x versions of sql server where direct products of
that project. However at one place I worked the SQL BOND/MSSQLC
worked well with later versions of MS SQL server.
Otherwise you are probably going to be exporting lots of flat ASCII files
and use the import or BCP function.
Have fun!
----
=== At 07 NOV 1997 01:39PM Robert Lynch wrote: ===
Oh by the way, open insight is not required to do this.
----
=== At 10 NOV 1997 12:06PM Heidi Gray wrote: ===
One question on the response from Robert Lynch. What is the "BCP function"
Thanks
Heidi
----
=== At 10 NOV 1997 12:55PM Robert Lynch wrote: ===
BCP -
In Microsoft SQL SERVER it is "Bulk Copy Utility Program".
This program can transfer Large amounts of data in and out
of SQL SERVER.
I.e. From AREV generate flat comma or tilde delimeted
ASCII Files. After file is generated use the BCP
utility to copy that data into SQL SERVER.
Since SYBASE and MS SQL Server are closely related
I suspect SYBASE has the same or very similar
program.
If you have any more questions feel free to Email
me at bob_lynch@adpbenefits.com. Also, cc: it
to lynchrw@erols.com.
Good luck!
[[https://www.revelation.com/revweb/oecgi4p.php/O4W_HANDOFF?DESTN=O4W_RUN_FORM&INQID=NONWORKS_READ&SUMMARY=1&KEY=717FFB367037D1A685256546005FD76D|View this thread on the forum...]]