| Breck Carter [TeamSybase] 2005-12-16, 1:23 pm |
| It is quite possible that the tables were created with a different
owner than the user id you connected with to view them.
On 16 Dec 2005 08:36:21 -0800, "Jayaram Krishnaswamy"
< jkrishnaswamy@comcas
t.net> wrote:
>This should gladden the hearts of ASA group. I tried migrating a set of
>tables from MS Access to SQL Anywhere. I had some surprises.
>
>At first I used, DTS to do the transfer, one of the tables failed. It turned
>out that for ASA split table names with a white space is not aceptable.
>"Order Details" should really be "OrderDetails". After this all tables were
>successfuly transferred. I went back to sybase Central to see if they have
>arrived safely. I could not find the tables. What happenned?
>It was surprising. Is it the fault of DTS, or that of ASA, I do not know.
>
>Next I tried the reverse, started the tool in Sql Anywhere 9.0 and voila, I
>got all the tables migrated. However, the log said there was an error. I
>must say I have to believe the tables.
>Why did I get this message? I just migrated the data, probably it came with
>some unacceptabel schema information. Of course I used the generic database
>connected by ODBC's system DSN.
>
>By the way there are two copies of tables with different icons, what do they
>represent?
>Where can I find info?
>
>Jayaram Krishnaswamy
>
--
SQL Anywhere Studio 9 Developer's Guide
Buy the book: http://www.amazon.com/exec/obidos/A...7/risingroad-20
bcarter@risingroad.com
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com
|