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.

Backup to smaller ASE

4 posts in General Discussion Last posting was on 2010-04-29 13:49:05.0Z
RGS Posted on 2010-04-29 01:21:46.0Z
Sender: 79ac.4bd8dd5f.846930886@sybase.com
From: RGS
Newsgroups: sybase.public.ase.general
Subject: Backup to smaller ASE
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4bd8df2a.79e8.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 28 Apr 2010 18:21:46 -0700
X-Trace: forums-1-dub 1272504106 10.22.241.41 (28 Apr 2010 18:21:46 -0700)
X-Original-Trace: 28 Apr 2010 18:21:46 -0700, 10.22.241.41
Lines: 15
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29155
Article PK: 78392

I need to copy a database from ASE1 to ASE2 but the space in
ASE2 is smaller

I think in:

1) Do a DUMP from ASE1 to ASE3
2) In ASE3 I will truncate huge tables of mi database
3) Use a tool for make a DUMP with smaller space (because I
don't have the huge tables)
4) Execute a LOAD in ASE3 with the file that I generated
later

Is there a tool for do this? How can I resolve my problem?

Thanks!!


Rajsekhar Reddy Posted on 2010-04-29 03:23:15.0Z
Sender: 5254.4bd7ad0e.1804289383@sybase.com
From: Rajsekhar Reddy
Newsgroups: sybase.public.ase.general
Subject: Re: Backup to smaller ASE
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4bd8fba3.7cad.1681692777@sybase.com>
References: <4bd8df2a.79e8.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 28 Apr 2010 20:23:15 -0700
X-Trace: forums-1-dub 1272511395 10.22.241.41 (28 Apr 2010 20:23:15 -0700)
X-Original-Trace: 28 Apr 2010 20:23:15 -0700, 10.22.241.41
Lines: 19
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29156
Article PK: 78393

I don't think we have such tools. You can BCP tables out
from Source server and BCP tables(what you need) in Target
server.

> I need to copy a database from ASE1 to ASE2 but the space
> in ASE2 is smaller
>
> I think in:
>
> 1) Do a DUMP from ASE1 to ASE3
> 2) In ASE3 I will truncate huge tables of mi database
> 3) Use a tool for make a DUMP with smaller space (because
> I don't have the huge tables)
> 4) Execute a LOAD in ASE3 with the file that I generated
> later
>
> Is there a tool for do this? How can I resolve my problem?
>
> Thanks!!


Carl Kayser Posted on 2010-04-29 13:41:16.0Z
From: "Carl Kayser" <kayser_c@bls.gov>
Newsgroups: sybase.public.ase.general
References: <4bd8df2a.79e8.1681692777@sybase.com>
Subject: Re: Backup to smaller ASE
Lines: 31
Organization: BLS
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5843
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4bd98c7c@forums-1-dub>
Date: 29 Apr 2010 06:41:16 -0700
X-Trace: forums-1-dub 1272548476 10.22.241.152 (29 Apr 2010 06:41:16 -0700)
X-Original-Trace: 29 Apr 2010 06:41:16 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29157
Article PK: 78394


<RGS> wrote in message news:4bd8df2a.79e8.1681692777@sybase.com...
>I need to copy a database from ASE1 to ASE2 but the space in
> ASE2 is smaller
>
> I think in:
>
> 1) Do a DUMP from ASE1 to ASE3
> 2) In ASE3 I will truncate huge tables of mi database
> 3) Use a tool for make a DUMP with smaller space (because I
> don't have the huge tables)
> 4) Execute a LOAD in ASE3 with the file that I generated
> later
>
> Is there a tool for do this? How can I resolve my problem?
>
> Thanks!!

Tools-wise there is BMC Recovery Manager (formerly SQL-BackTrack):
http://documents.bmc.com/products/documents/96/28/89628/89628.pdf

It might be overkill since it can do a lot of other stuff as well (e.g.,
copy all objects but no data) and is not particularly cheap. We use it
regularly for backup/recovery as well as doing logical copying of databases.
The flaw with logical copying is that procs that communicate via temporary
tables might not be compiled. (Basically the product uses bcp and source
code stored in syscomments. This issue might be resolved with ASE 15.5
deferred object resolution and a new version of the product.)


Carl Kayser Posted on 2010-04-29 13:49:05.0Z
From: "Carl Kayser" <kayser_c@bls.gov>
Newsgroups: sybase.public.ase.general
References: <4bd8df2a.79e8.1681692777@sybase.com>
Subject: Re: Backup to smaller ASE
Lines: 29
Organization: BLS
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5843
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4bd98e51$1@forums-1-dub>
Date: 29 Apr 2010 06:49:05 -0700
X-Trace: forums-1-dub 1272548945 10.22.241.152 (29 Apr 2010 06:49:05 -0700)
X-Original-Trace: 29 Apr 2010 06:49:05 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29158
Article PK: 78395


<RGS> wrote in message news:4bd8df2a.79e8.1681692777@sybase.com...
>I need to copy a database from ASE1 to ASE2 but the space in
> ASE2 is smaller
>
> I think in:
>
> 1) Do a DUMP from ASE1 to ASE3
> 2) In ASE3 I will truncate huge tables of mi database
> 3) Use a tool for make a DUMP with smaller space (because I
> don't have the huge tables)
> 4) Execute a LOAD in ASE3 with the file that I generated
> later
>
> Is there a tool for do this? How can I resolve my problem?
>
> Thanks!!

You didn't specify which ASE version you use. It's usually a good idea to
always provide this when you have a question.

If you have Archive Database Access then you can dump to a disk where ASE3
resides, make the dump an archive database, and insert into ASE3 from the
archive database. This only addresses data; you have to define your procs,
triggers, etc from scratch. Also the tables won't have any checks, rules,
referential constraints, etc unless you define them. ADA started with
12.5.4 and is in the newer 15.x releases. No extra licensing is needed.