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

[email protected]

Thanks

Heidi Gray

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

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.)

Converting ARev Applications to OpenInsight

b)get an ODBC driver for Sybase

c)use the datawarehousing utility in OI

Using the DataWarehousing Feature in OI

Hope that helps you out.

Tracy

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!

Oh by the way, open insight is not required to do this.

One question on the response from Robert Lynch. What is the "BCP function"

Thanks

Heidi

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 [email protected]. Also, cc: it

to [email protected].

Good luck!

View this thread on the forum...