SQL Developer

Not sure if this is a known issue (couldn't see one) or simply poor JDBC behaviour ... I'm connected to a Sql Server 2000something instance and I see the Users, and I see the Tables and Columns for the user of interest. BUT for Keys for each table, I only see the Primary Key. No other keys (especially Foreign Keys). There is nothing under Constraints. And also, for the Primary Keys I do see, the list of columns is "messed up" (some columns appear twice, in a different order, etc).

- Yes I'm using the jtds jdbc driver off of sourceforge.net
- Yes I used the "add 3rd party driver" wizard to add the entry
- Yes I am connecting using the "sa" account, and it has a password (which I supplied to the Connection definition)
- Yes the Connection then asks me for a database, I see users in that database, I see element types for each user
--- so most of it is working.

I'd really like to get this working, to migrate data from the Sql Server database into an Oracle database (and yes I pulled down the Migration Tool plugin). But I need to understand the Foreign Keys in order to set up the target database and perform the migration.

Any ideas as to why it doesn't pull info on Keys correctly ??