Home All Groups Group Topic Archive Search About
Author
14 Aug 2006 4:41 PM
Alex Castillo
Hello...

I'm trying to import a Sybase SQL Anywhere 5.5 database to MS SQL v2000.

When the Import process finishes, it reports some errors, but it does not
let me review them. I wonder if

is there any log file created by the import process I can use for review?
is there any tool to map properly datatypes between Sybase SQL Anywhere 5.5
and MS SQL 2000?

Thanks..!

Author
15 Aug 2006 12:25 AM
Hari Prasad
Hi,

Create a DTS package and execute the package using DTSRUN utility. In DTSRUN
you can redirect the output to a log file
using /L Log file.

As far as I know there is no tool available to map datatypes between SQL
Anywhere 5.5 and SQL 2000.

Thanks
Hari
SQL Server MVP

Show quote
"Alex Castillo" <klmAlexCast_Sl***@HotMail.Com> wrote in message
news:ORUGNC8vGHA.2436@TK2MSFTNGP06.phx.gbl...
> Hello...
>
> I'm trying to import a Sybase SQL Anywhere 5.5 database to MS SQL v2000.
>
> When the Import process finishes, it reports some errors, but it does not
> let me review them. I wonder if
>
> is there any log file created by the import process I can use for review?
> is there any tool to map properly datatypes between Sybase SQL Anywhere
> 5.5 and MS SQL 2000?
>
> Thanks..!
>
>
Author
16 Aug 2006 2:06 PM
Alex Castillo
Thanks Hari..!

Show quote
"Hari Prasad" <hari_prasa***@hotmail.com> wrote in message
news:u1vZIFAwGHA.3936@TK2MSFTNGP04.phx.gbl...
> Hi,
>
> Create a DTS package and execute the package using DTSRUN utility. In
> DTSRUN you can redirect the output to a log file
> using /L Log file.
>
> As far as I know there is no tool available to map datatypes between SQL
> Anywhere 5.5 and SQL 2000.
>
> Thanks
> Hari
> SQL Server MVP
>
> "Alex Castillo" <klmAlexCast_Sl***@HotMail.Com> wrote in message
> news:ORUGNC8vGHA.2436@TK2MSFTNGP06.phx.gbl...
>> Hello...
>>
>> I'm trying to import a Sybase SQL Anywhere 5.5 database to MS SQL v2000.
>>
>> When the Import process finishes, it reports some errors, but it does not
>> let me review them. I wonder if
>>
>> is there any log file created by the import process I can use for review?
>> is there any tool to map properly datatypes between Sybase SQL Anywhere
>> 5.5 and MS SQL 2000?
>>
>> Thanks..!
>>
>>
>
>

AddThis Social Bookmark Button