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.

Creating SQL Script --

3 posts in General Discussion Last posting was on 2003-03-03 21:48:41.0Z
Suri Posted on 2003-03-03 18:15:29.0Z
From: Suri
Date: Mon, 3 Mar 2003 13:15:29 -0500
Newsgroups: ianywhere.public.general
Subject: Creating SQL Script --
Message-ID: <E875F5550B2ABB3000644B5E85256CDE.00644B6D85256CDE@webforums>
Lines: 9
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub ianywhere.public.general:784
Article PK: 2734

Is there any utility in Sybase IAnywhere to create DBScripts automatically
from the database ?

SQL -- DDL Statements from existing ASA database..

Thanks,
Suri

Setup -- Sybase ASA 8.0 on Linux..


Nick Elson Posted on 2003-03-03 18:34:15.0Z
From: "Nick Elson" <no_spam_nicelson@sybase.com>
References: <E875F5550B2ABB3000644B5E85256CDE.00644B6D85256CDE@webforums>
Subject: Re: Creating SQL Script --
Date: Mon, 3 Mar 2003 13:34:15 -0500
Lines: 27
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2720.3000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
Message-ID: <fU7kMZb4CHA.271@forums.sybase.com>
Newsgroups: ianywhere.public.general
NNTP-Posting-Host: 172.31.142.76
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub ianywhere.public.general:785
Article PK: 3271

Dbunload has the direct utility solution for that.

Try using

dbunload -t <your table name goes here> -c "...."


Otherwise you will want to use something like PowerDynamo's
reverse engineering to get to that.

By the way, when you say 'DBScripts' were you looking for
a script that is compatable with a 3rd party product?

<Suri> wrote in message
news:E875F5550B2ABB3000644B5E85256CDE.00644B6D85256CDE@webforums...
> Is there any utility in Sybase IAnywhere to create DBScripts automatically
> from the database ?
>
> SQL -- DDL Statements from existing ASA database..
>
> Thanks,
> Suri
>
> Setup -- Sybase ASA 8.0 on Linux..


Suri Posted on 2003-03-03 21:48:41.0Z
From: Suri
Date: Mon, 3 Mar 2003 16:48:41 -0500
Newsgroups: ianywhere.public.general
Subject: Re: Creating SQL Script --
Message-ID: <890FA719FD5557E50077D04E85256CDE.006B796B85256CDE@webforums>
References: <E875F5550B2ABB3000644B5E85256CDE.00644B6D85256CDE@webforums> <fU7kMZb4CHA.271@forums.sybase.com>
Lines: 3
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub ianywhere.public.general:786
Article PK: 2735

Thanks. It worked..

I was trying to build an empty database with the same schema!