SQL Anywhere database - Re: Pleasantly surprised , Where can I find Info?

Author

Re: Pleasantly surprised , Where can I find Info?

Greg Fenton

2005-12-16, 11:23 am

Jayaram Krishnaswamy wrote:
>
> 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.

Table names with spaces are completely valid:

create table "foo bar" ( id int, val varchar(20) );
insert into "foo bar" (id, val) values (1, 'hi');
select * from "foo bar";

Why did you use DTS?
Have you tried the Database Migration Wizard in Sybase Central (or the
sa_migrate() stored proc)?

> By the way there are two copies of tables with different icons, what do they
> represent?
> Where can I find info?

Right-click the table, choose Properties and in the General tab of the
dialog look a the "Type" value.

greg.fenton

Jayaram Krishnaswamy

2005-12-17, 9:23 am

In DTS, I tried to transfer the table 'Order details', the transfer failed,
next tiem I will write down who raised the error. I guessed and changed the
name of the destination table in ASA9 to 'OrderDetails', the copy tabel
worked without any problem.

Why did I use DTS? Curious to check out the capabilities of DTS and compare
with that of the tool in Sybase Central. This tool was the Data Migration
wizard. It is neat and I liked it. I have not tried the stored procedure to
migrate.

The mystery of the two copies. One of them is the proxy. I will dig a little
moe to undertand and I will not bother you untill I come to a stop.

Jayaram krishnaSwamy
"Greg Fenton" <greg. fenton_NOSPAM_@ianyw
here.com> wrote in message
news:43a2f75e$1@foru
ms-1-dub...
> Jayaram Krishnaswamy wrote:
turned[color=darkred
]
>
> Table names with spaces are completely valid:
>
> create table "foo bar" ( id int, val varchar(20) );
> insert into "foo bar" (id, val) values (1, 'hi');
> select * from "foo bar";
>
> Why did you use DTS?
> Have you tried the Database Migration Wizard in Sybase Central (or the
> sa_migrate() stored proc)?
>
they[color=darkred]
>
> Right-click the table, choose Properties and in the General tab of the
> dialog look a the "Type" value.
>
> greg.fenton

Sponsored Links