comparing a View with a table

[umer_...@hotmail.com]

I have a view in sybase called "fast_orders" and a identical table in
Oracle called "slow_orders" and I am trying to compare the data using
Tool > Compare Data and getting an error " Incorrect syntax near '['.
"


Please tell me if it is possible to compare view with a table if the
source is sybase and desination is oracle.

Thanks
Umer
Irvine, CA

[DB Solo Admin]

Hi,

Make sure you have unchecked the 'Use brackets with identifiers'
option for your Sybase connection before you connect. Let me know if
that doesn't help.

marko

On Mar 12, 2:12 pm, "umer_lah...@hotmail.com"

[umer habib]

Hi, I unchecked the that option "use brackets [] with identifiers". But this checkbox gets checked again automatically if click on some other folder and come to the same connection screen.
 
Thanks
Umer
 
> Date: Thu, 12 Mar 2009 14:26:19 -0700
> Subject: Re: comparing a View with a table
> From: mhan...@gmail.com
> To: DB-...@googlegroups.com

[DB Solo]

Did you click on 'Update' after checking the checkbox?

[umer habib]

Hi, My mistake, I was just not hitting the udpated button after unchecking the check box :). Thanks Marko.

 
Umer
 
> Date: Thu, 12 Mar 2009 14:26:19 -0700
> Subject: Re: comparing a View with a table
> From: mhan...@gmail.com
> To: DB-...@googlegroups.com
>
>