Sybase Adaptive Server Anywhere 6.0 - migration

Sean K

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Sybase Adaptive Server Anywhere 6.0 - migration

Does anyone know of a tool/technique to upsize a Paradox (5 & 7) database to
ASA 6.0 ? We have problems with the indexes not always being copied
correctly or at all. We are using an ODBC connection to the ASA database.

We have Paradox 7 Client/Server suite - the Data Pump applet doesn't copy
the indices either. Can we upgrade the Data Pump to a newer version to fix
this ?

I am fairly new to ASA/SQL databases so I might well be missing something
obvious.

Any comments/suggestions appreciated.

Thanks

Sean Kearon

Charles Bainbridg

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:Sybase Adaptive Server Anywhere 6.0 - migration

Hmm, I've been re-adding the indexes (primary) myself in Sybase Central
after a similar exercise only today.

I think I had the same problem doing Interbase->ASA6

In article <QKwC2.19648$_3.1566@stones>, Sean K
<s...@ksoft.force9.co.uk> writes

Quote

>Does anyone know of a tool/technique to upsize a Paradox (5 & 7) database to
>ASA 6.0 ? We have problems with the indexes not always being copied
>correctly or at all. We are using an ODBC connection to the ASA database.

>We have Paradox 7 Client/Server suite - the Data Pump applet doesn't copy
>the indices either. Can we upgrade the Data Pump to a newer version to fix
>this ?

>I am fairly new to ASA/SQL databases so I might well be missing something
>obvious.

>Any comments/suggestions appreciated.

>Thanks

>Sean Kearon

----------------------------
Charles Bainbridge

Sean

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:Sybase Adaptive Server Anywhere 6.0 - migration

Thanks Charles - at least I'm not alone on this !!!

Quote

Charles Bainbridge wrote in message ...
>Hmm, I've been re-adding the indexes (primary) myself in Sybase Central
>after a similar exercise only today.

>I think I had the same problem doing Interbase->ASA6

Sean

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:Sybase Adaptive Server Anywhere 6.0 - migration

Well, ordered D4 c/s and the Data Pump works fine....copies the indexes too.
The only trouble I noticed is indexes in Paradox over three columns with one
column descending and the others acscending translate to an ASA index with
all columns descending.

Quote

Sean K wrote in message ...
>Thanks Charles - at least I'm not alone on this !!!

>Charles Bainbridge wrote in message ...
>>Hmm, I've been re-adding the indexes (primary) myself in Sybase Central
>>after a similar exercise only today.

>>I think I had the same problem doing Interbase->ASA6

Other Threads

1. D4 / Sybase SQL Anywhere / Adaptive Server Anywhere 6.0

2. Problems with Sybase Adaptive Server Anywhere 6.0

3. Sybase Adaptive Server Anywhere 6.0 and D4 - Help and Advice Please

4. Connecting to Sybase Adaptive Server Anywhere 6.0

5. DB Disconnect error s - Delphi 4.0/Sybase Adaptive Server Anywhere 6.0

6. Adaptive Server Anywhere 6.0 Indexes

7. Cannot acces Adaptive Server Anywhere 6.0

8. Adaptive Server Anywhere 6.0 - Transaction isolation

9. Sybase Adaptive Server Anywhere

10. Sybase Adaptive Server Anywhere ODBC driver BLOBsize setting problem