Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Sybase Central with large schema, need DDL extract tool - Perl

3 posts in General Discussion Last posting was on 2011-09-20 00:33:54.0Z
IQRules Posted on 2011-09-18 22:07:21.0Z
From: IQRules <iqrules@noname.com>
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.7; rv:6.0.2) Gecko/20110902 Thunderbird/6.0.2
MIME-Version: 1.0
Newsgroups: sybase.public.iq
Subject: Sybase Central with large schema, need DDL extract tool - Perl
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4e766b99$1@forums-1-dub>
Date: 18 Sep 2011 15:07:21 -0700
X-Trace: forums-1-dub 1316383641 10.22.241.152 (18 Sep 2011 15:07:21 -0700)
X-Original-Trace: 18 Sep 2011 15:07:21 -0700, vip152.sybase.com
Lines: 6
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.iq:4408
Article PK: 246548

We have about over 500 table objects in the IQ 15.2 server and SCJ
starts up is extremely slow; not easy to do DDL reverse engineer (extract).

Any public domain Perl script (cmdline) to create table DDL, index, view?

Thanks


Leonid Gvirtz Posted on 2011-09-19 07:27:54.0Z
From: Leonid Gvirtz <lgvirtz@yahoo.com>
User-Agent: Mozilla/5.0 (Windows NT 5.1; rv:6.0.2) Gecko/20110902 Thunderbird/6.0.2
MIME-Version: 1.0
Newsgroups: sybase.public.iq
Subject: Re: Sybase Central with large schema, need DDL extract tool - Perl
References: <4e766b99$1@forums-1-dub>
In-Reply-To: <4e766b99$1@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4e76eefa$1@forums-1-dub>
Date: 19 Sep 2011 00:27:54 -0700
X-Trace: forums-1-dub 1316417274 10.22.241.152 (19 Sep 2011 00:27:54 -0700)
X-Original-Trace: 19 Sep 2011 00:27:54 -0700, vip152.sybase.com
Lines: 18
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.iq:4409
Article PK: 246549

Hi

I would suggest you to try my set of stored procedures that can be obtained from
http://www.gvirtz-consulting.com/downloads.html. It should be much faster than Sybase Central DDL generation. Let me
know if you have any problems with it.

Hope it helps
Leonid Gvirtz
<http://www.gvirtz-consulting.com/downloads.html>http://www.gvirtz-consulting.com

On 9/19/2011 1:07 AM, IQRules wrote:
> We have about over 500 table objects in the IQ 15.2 server and SCJ starts up is extremely slow; not easy to do DDL
> reverse engineer (extract).
>
> Any public domain Perl script (cmdline) to create table DDL, index, view?
>
> Thanks


IQRules Posted on 2011-09-20 00:33:54.0Z
From: IQRules <iqrules@noname.com>
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.7; rv:6.0.2) Gecko/20110902 Thunderbird/6.0.2
MIME-Version: 1.0
Newsgroups: sybase.public.iq
Subject: Re: Sybase Central with large schema, need DDL extract tool - Perl
References: <4e766b99$1@forums-1-dub> <4e76eefa$1@forums-1-dub>
In-Reply-To: <4e76eefa$1@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4e77df72@forums-1-dub>
Date: 19 Sep 2011 17:33:54 -0700
X-Trace: forums-1-dub 1316478834 10.22.241.152 (19 Sep 2011 17:33:54 -0700)
X-Original-Trace: 19 Sep 2011 17:33:54 -0700, vip152.sybase.com
Lines: 25
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.iq:4410
Article PK: 246550

Great! Thanks.

On 9/19/11 3:27 AM, Leonid Gvirtz wrote:
> Hi
>
> I would suggest you to try my set of stored procedures that can be
> obtained from http://www.gvirtz-consulting.com/downloads.html. It should
> be much faster than Sybase Central DDL generation. Let me know if you
> have any problems with it.
>
> Hope it helps
> Leonid Gvirtz
> <http://www.gvirtz-consulting.com/downloads.html>http://www.gvirtz-consulting.com
>
>
> On 9/19/2011 1:07 AM, IQRules wrote:
>> We have about over 500 table objects in the IQ 15.2 server and SCJ
>> starts up is extremely slow; not easy to do DDL reverse engineer
>> (extract).
>>
>> Any public domain Perl script (cmdline) to create table DDL, index, view?
>>
>> Thanks
>