Hello eveybody,

This is the first time in Sybase world. I'm very new in SQL Anywhere. I'm
just download SQL Anywhere 11.0.1 and already installed EBF to build 2299.
I use Sybase Central > Tools > SQL Anywhere11 > Migrate Database function to
migrate table and data from MS Access 2002. These are problems I found :

- Primary key from MS Access is not generated as Primary Key constraint but
it is generated as Index named PrimaryKey instead.

- Any multi-columns index from MS Access is generated as wrong column
ordering.

- If I mark "Migrate the foreign keys" option, Migration will fail during
CREATE INDEX step with this message --- java.sql.SQLException:
[Sybase][ODBC Driver][SQL Anywhere]Server 'AccessServer' : [Microsoft][ODBC
Driver Manager] Driver does not support this function.


Please guide me how to solve these problems.

Thank you in advance,
Suntisuk Lorkrilert

If this is critical to your efforts you should probably
contact technical support so they can work through
these issues with you. [gather an ODBC trace and
be prepared to provide a copy of the Access database]

There is also a downloadable migrate utility (as well as
low level sa_migrate procedures) that may help you work
this out in more detail than just relying upon a simple
wizard.

This might be due to a display difference or the way the indexes
are being returned. An ODBC trace and the driver + database
may be required to investigate this further.

I believe I that is how that is reported by some ODBC drivers.
Again the trace and driver+database may be required.

It sounds like your ODBC driver for MS Access does
not support SQLForeignKeysW( ).

Your options at this point include:

-Trying different ODBC drivers from Microsoft (or others).
-Skipping the migration of the foreign keys during the migration
and manually add them later.
- Or see if the migration utility works any better [the tip below
shows where to download this utility from] and/or decomposing
the steps into the various sa_migrate* procedures.

The SQL Anywhere, MS Access Migration Utility can be
downloaded from:
http://www.ianywhere.com/developer/code_samples/sqlany_migration_utility.html"Suntisuk" <suntisuka (AT) yahoo (DOT) com> wrote in messagenews:4abb36ec (AT) forums-1-dub (DOT) ..> Hello eveybody,>> This is the first time in Sybase world. I'm very new in SQL Anywhere. I'mjust download SQL Anywhere 11.0.1 and already installed EBF to build 2299. Iuse Sybase Central > Tools > SQL Anywhere11 > Migrate Database function tomigrate table and data from MS Access 2002. These are problems I found :>> - Primary key from MS Access is not generated as Primary Key constraintbut it is generated as Index named PrimaryKey instead.>> - Any multi-columns index from MS Access is generated as wrong columnordering.>> - If I mark "Migrate the foreign keys" option, Migration will fail duringCREATE INDEX step with this message --- java.sql.SQLException:[Sybase][ODBC Driver][SQL Anywhere]Server 'AccessServer' : [Microsoft][ODBCDriver Manager] Driver does not support this function.>>> Please guide me how to solve these problems.>> Thank you in advance,> Suntisuk Lorkrilert>>