The problem here is not the complexity of the Database, but the compatibily with the Data Dictionary to retrieve all the data. Please have a try, and if the source model denerated is okay with you needs, that will be fine.2. I'm trying to setup the connectivity. Is the jtds driver (3rd party) the only driver needed ? Is the Sybase Adaptive Client needed ?
yes, jtds is sufficient. You do not need the full Sybase Adaptive Client.3 and 4. I have downloaded and put in the jtds driver 1.2.5 and attempted to setup the connection to the Sybase DB.
Obviously, the user must be able to connect to the Sybase Database. However, to migrate, it is recommended to use a Sybase user like "sa". This user must be able to discover all of the object that reside in the Database.5. I have not gone that far yet, but can the migration be done only for just 1 schema (being a Psoft DB) rather than for the whole DB?
Yes it can. you have the choice of the granularity of the objects you want to Migrate.Cheers,