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.

Which Sybase Central tool to use to create an empty db from an existing db?

3 posts in General Discussion Last posting was on 2008-01-12 15:13:27.0Z
Alastair Walker Posted on 2008-01-12 12:17:34.0Z
Sender: 5b86.4788af25.1804289383@sybase.com
From: Alastair Walker
Newsgroups: ianywhere.public.general
Subject: Which Sybase Central tool to use to create an empty db from an existing db?
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4788afde.5b8c.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 12 Jan 2008 04:17:34 -0800
X-Trace: forums-1-dub 1200140254 10.22.241.41 (12 Jan 2008 04:17:34 -0800)
X-Original-Trace: 12 Jan 2008 04:17:34 -0800, 10.22.241.41
Lines: 8
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6670
Article PK: 4919

I need to create a clean (new, empty) database from an
existing db with many tables and existing data. I want to
create a db with all the tables from the existing db, but
devoid of any row data. I have studied the Sybase Central
facilities, but it is not clear to me which tool I should be
using to perform this task.

Any advice?


Arthur Hefti Posted on 2008-01-12 13:59:43.0Z
From: Arthur Hefti <arthur@catsoft.ch>
Reply-To: arthur@catsoft.ch
Organization: CATsoft Developement GmbH
User-Agent: Thunderbird 2.0.0.9 (Windows/20071031)
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: Which Sybase Central tool to use to create an empty db from an existing db?
References: <4788afde.5b8c.1681692777@sybase.com>
In-Reply-To: <4788afde.5b8c.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: cust.static.213-180-184-33.cybernet.ch
X-Original-NNTP-Posting-Host: cust.static.213-180-184-33.cybernet.ch
Message-ID: <4788c7cf$1@forums-1-dub>
Date: 12 Jan 2008 05:59:43 -0800
X-Trace: forums-1-dub 1200146383 213.180.184.33 (12 Jan 2008 05:59:43 -0800)
X-Original-Trace: 12 Jan 2008 05:59:43 -0800, cust.static.213-180-184-33.cybernet.ch
Lines: 14
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6671
Article PK: 4920

Use dbunload -n -an

Regards
Arthur

Alastair Walker wrote:
> I need to create a clean (new, empty) database from an
> existing db with many tables and existing data. I want to
> create a db with all the tables from the existing db, but
> devoid of any row data. I have studied the Sybase Central
> facilities, but it is not clear to me which tool I should be
> using to perform this task.
>
> Any advice?


Alastair Walker Posted on 2008-01-12 15:13:27.0Z
Sender: 5b86.4788af25.1804289383@sybase.com
From: Alastair Walker
Newsgroups: ianywhere.public.general
Subject: Re: Which Sybase Central tool to use to create an empty db from an existing db? - many thanks!
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4788d917.5d73.1681692777@sybase.com>
References: <4788c7cf$1@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 12 Jan 2008 07:13:27 -0800
X-Trace: forums-1-dub 1200150807 10.22.241.41 (12 Jan 2008 07:13:27 -0800)
X-Original-Trace: 12 Jan 2008 07:13:27 -0800, 10.22.241.41
Lines: 20
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6672
Article PK: 4921

Thank you very much!

Alastair

> Use dbunload -n -an
>
> Regards
> Arthur
>
> Alastair Walker wrote:
> > I need to create a clean (new, empty) database from an
> > existing db with many tables and existing data. I want
> > to create a db with all the tables from the existing db,
> > but devoid of any row data. I have studied the Sybase
> > Central facilities, but it is not clear to me which tool
> > I should be using to perform this task.
> >
> > Any advice?