Migrate off of old 11.x system

We're in a bit of a conundrum. We have an old, ancient, ASE
11.x system running on Solaris 5.6. The application that
used to run on it ran natively and so outside connectivity
was minimal.

In that time, we are attempting to replace the system and
extract the tables and DDL. Unfortunately, the only Windows
client software we have are ancient 11.1.1 disks, which
don't even *install* on anything more recent than a decade
ago.

Is there anyway to get more recent client software, or
generic ODBC drivers that we can use to extract the data and
DDL from this moldy system?

Why can't you use the Solaris host to extract the data and DDL?

If you absolutely need PC connectivity to do this, you might want to look
into the Developer's edition of ASE, or the Express Edition for Linux:

http://www.sybase.com/ase_1500devel

http://response.sybase.com/forms/ASE_Linux_Download


wrote in message news:48af1953.3cca.1681692777-at-sybase.com...
> We're in a bit of a conundrum. We have an old, ancient, ASE
> 11.x system running on Solaris 5.6. The application that
> used to run on it ran natively and so outside connectivity
> was minimal.
>
> In that time, we are attempting to replace the system and
> extract the tables and DDL. Unfortunately, the only Windows
> client software we have are ancient 11.1.1 disks, which
> don't even *install* on anything more recent than a decade
> ago.
>
> Is there anyway to get more recent client software, or
> generic ODBC drivers that we can use to extract the data and
> DDL from this moldy system?

Thanks Kevin. Unfortunately, we don't have any real Sybase
administrators here, so we're not sure how we'd do it
manually given the limited command support in v11 of ASE.
If you know of any online sites that may provide more
information, I'd be happy to try to learn on the fly...

Our first attempt was to use the JDBC drivers for ASE, but
they require meta-data tables to extract DDL, which don't
exist as part of the original 11.1.1 version (they don't
appear it seems, until at least 12.5), it didn't work too
well. We can query, but little else.

We were hoping that ERStudio or some of the other modelling
tools might be able to help us extract the data
architecture, but we can't even get them connected without
some sort of client support.

We'll try the newer ASE developer revision+client to see if
it will still connect... (we're just unsure if it will even
allow it).

> Why can't you use the Solaris host to extract the data and
> DDL?
>
> If you absolutely need PC connectivity to do this, you
> might want to look into the Developer's edition of ASE,
> or the Express Edition for Linux:
>
> http://www.sybase.com/ase_1500devel
>
> http://response.sybase.com/forms/ASE_Linux_Download
>
>
> wrote in message
> > news:48af1953.3cca.1681692777-at-sybase.com... We're in a
> > bit of a conundrum. We have an old, ancient, ASE 11.x
> > system running on Solaris 5.6. The application that
> > used to run on it ran natively and so outside
> connectivity was minimal. >

Your subject line indicates you are "migrating" off the 11.x system. What
are you migrating to? A more current version of ASE, or some other DBMS?
You may be able to use PowerDesigner to extract DDL.

Mark Kusma

wrote in message news:48af3397.3f40.1681692777-at-sybase.com...
> Thanks Kevin. Unfortunately, we don't have any real Sybase
> administrators here, so we're not sure how we'd do it
> manually given the limited command support in v11 of ASE.
> If you know of any online sites that may provide more
> information, I'd be happy to try to learn on the fly...
>
> Our first attempt was to use the JDBC drivers for ASE, but
> they require meta-data tables to extract DDL, which don't
> exist as part of the original 11.1.1 version (they don't
> appear it seems, until at least 12.5), it didn't work too
> well. We can query, but little else.
>
> We were hoping that ERStudio or some of the other modelling
> tools might be able to help us extract the data
> architecture, but we can't even get them connected without
> some sort of client support.
>
> We'll try the newer ASE developer revision+client to see if
> it will still connect... (we're just unsure if it will even
> allow it).
>
>> Why can't you use the Solaris host to extract the data and
>> DDL?
>>
>> If you absolutely need PC connectivity to do this, you
>> might want to look into the Developer's edition of ASE,
>> or the Express Edition for Linux:
>>
>> http://www.sybase.com/ase_1500devel
>>
>> http://response.sybase.com/forms/ASE_Linux_Download
>>
>>
>> wrote in message
>> > news:48af1953.3cca.1681692777-at-sybase.com... We're in a
>> > bit of a conundrum. We have an old, ancient, ASE 11.x
>> > system running on Solaris 5.6. The application that
>> > used to run on it ran natively and so outside
>> connectivity was minimal. >

On Fri, 22 Aug 2008 12:53:55 -0700, wrote:

> We're in a bit of a conundrum. We have an old, ancient, ASE
> 11.x system running on Solaris 5.6. The application that
> used to run on it ran natively and so outside connectivity
> was minimal.
>
> In that time, we are attempting to replace the system and
> extract the tables and DDL. Unfortunately, the only Windows
> client software we have are ancient 11.1.1 disks, which
> don't even *install* on anything more recent than a decade
> ago.
>
> Is there anyway to get more recent client software, or
> generic ODBC drivers that we can use to extract the data and
> DDL from this moldy system?

Any recent OpenClient package will be able to connect to your 11.x server
with no problems. Then you need to find a tool that will extract the DDL.
One such tool is dbschema.pl - a perl script which requires that the
sybperl package be installed.

Michael