Home > Archive > ASE Database forum > October 2005 > Moving schema from MSSQL to ASE.









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Moving schema from MSSQL to ASE.
Frank Rizzo

2005-10-27, 8:22 am

Is there a reliable tool that will move schema from a MSSQL to ASE? I
don't care about data. DB Artisan Schema Migration feature chokes on
it, so I seem to be out of options.

Thanks
Sherlock, Kevin

2005-10-27, 8:22 am

Look into PowerDesigner.

"Frank Rizzo" <none@none.net> wrote in message news:435fdba2$1@foru
ms-2-dub...
> Is there a reliable tool that will move schema from a MSSQL to ASE? I
> don't care about data. DB Artisan Schema Migration feature chokes on
> it, so I seem to be out of options.
>
> Thanks



Jeffrey R. Garbus

2005-10-27, 5:29 pm

Try altering the MS side to change all your SYSIDs to varbinary(30). That
got 99% of everything for me.

(Nice to know somebody out there is doing this! I'm on my third MS to Sybase
migration in as many years)

"Frank Rizzo" <none@none.net> wrote in message
news:435fdba2$1@foru
ms-2-dub...
> Is there a reliable tool that will move schema from a MSSQL to ASE? I
> don't care about data. DB Artisan Schema Migration feature chokes on
> it, so I seem to be out of options.
>
> Thanks



Frank Rizzo

2005-10-27, 5:29 pm

Jeffrey R. Garbus wrote:
> Try altering the MS side to change all your SYSIDs to varbinary(30). That
> got 99% of everything for me.


I don't have any SYSIDs. Artisan just locks up at some point.

>
> (Nice to know somebody out there is doing this! I'm on my third MS to Sybase
> migration in as many years)
>
> "Frank Rizzo" <none@none.net> wrote in message
> news:435fdba2$1@foru
ms-2-dub...
>
>
>
>

Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com