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.

Backups of Sybase

10 posts in General Discussion Last posting was on 2009-08-11 20:03:11.0Z
RGS Posted on 2009-08-07 15:24:13.0Z
Sender: 42ab.4a7c459b.1804289383@sybase.com
From: RGS
Newsgroups: sybase.public.ase.general
Subject: Backups of Sybase
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4a7c471d.43d1.1681692777@sybase.com>
NNTP-Posting-Host: forums-3-dub.sybase.com
X-Original-NNTP-Posting-Host: forums-3-dub.sybase.com
Date: 7 Aug 2009 08:24:13 -0700
X-Trace: forums-3-dub.sybase.com 1249658653 10.22.241.188 (7 Aug 2009 08:24:13 -0700)
X-Original-Trace: 7 Aug 2009 08:24:13 -0700, forums-3-dub.sybase.com
Lines: 19
Path: forums-1-dub!forums-master!forums-3-dub.sybase.com!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28109
Article PK: 77351

I have three types of servers in my comany:

1) Production
2) Test
3) Development

1 is very big but 2 and 3 are small

I need a tool to copy:

- All objects (tables, indexes, triggers, etc)
- Some data (a integral portion of data)

From production to test or development ASE servers

Do you know a tool for this task? I can not use BACKUP's
utility because the servers don't have the same capacity

Thanks a lot !!!


"Mark A. Parsons" <iron_horse Posted on 2009-08-07 15:35:25.0Z
From: "Mark A. Parsons" <iron_horse@no_spamola.compuserve.com>
User-Agent: Thunderbird 1.5.0.10 (Windows/20070221)
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: Backups of Sybase
References: <4a7c471d.43d1.1681692777@sybase.com>
In-Reply-To: <4a7c471d.43d1.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Antivirus: avast! (VPS 090805-0, 08/05/2009), Outbound message
X-Antivirus-Status: Clean
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4a7c49bd$5@forums-3-dub.sybase.com>
Date: 7 Aug 2009 08:35:25 -0700
X-Trace: forums-3-dub.sybase.com 1249659325 10.22.241.152 (7 Aug 2009 08:35:25 -0700)
X-Original-Trace: 7 Aug 2009 08:35:25 -0700, vip152.sybase.com
Lines: 35
Path: forums-1-dub!forums-master!forums-3-dub.sybase.com!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28110
Article PK: 77353

Object extraction could be performed using ASE's ddlgen utility (ie, OS-level program).

Data extraction could be performed using views (to limit data) and bcp (OS-level program) to pull data from views and
dump into the test/development databases.

If the data extraction portion is too time consuming and/or complex, and you're using ASE 12.5.4+, consider loading the
production database as an 'archive database' into the test and development dataservers. This method basically allows
you to mount the database dump file(s) with a minimal amount of disk space requirements on the test/development
dataservers. Once the archive database has been loaded/mounted you can then access the database dump file(s) in
read-only mode (eg, extract the desired read-only data into your local database).

------------

Are there other tools? Probably, but I just use the above tools for what I need to do.

RGS wrote:
> I have three types of servers in my comany:
>
> 1) Production
> 2) Test
> 3) Development
>
> 1 is very big but 2 and 3 are small
>
> I need a tool to copy:
>
> - All objects (tables, indexes, triggers, etc)
> - Some data (a integral portion of data)
>
> From production to test or development ASE servers
>
> Do you know a tool for this task? I can not use BACKUP's
> utility because the servers don't have the same capacity
>
> Thanks a lot !!!


ThanksButNo Posted on 2009-08-08 02:54:27.0Z
From: ThanksButNo <no.no.thanks@gmail.com>
Newsgroups: sybase.public.ase.general
Subject: Re: Backups of Sybase
Date: Fri, 7 Aug 2009 19:54:27 -0700 (PDT)
Organization: http://groups.google.com
Lines: 33
Message-ID: <b2ee40d7-12df-464c-b07e-d84a62c8e0ca@g6g2000vbr.googlegroups.com>
References: <4a7c471d.43d1.1681692777@sybase.com>
NNTP-Posting-Host: 71.165.35.183
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
X-Trace: posting.google.com 1249700067 7750 127.0.0.1 (8 Aug 2009 02:54:27 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Sat, 8 Aug 2009 02:54:27 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: g6g2000vbr.googlegroups.com; posting-host=71.165.35.183; posting-account=wjKAPwoAAABtEbTff5o9OO7GYdigbDts
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.1.2) Gecko/20090729 Firefox/3.5.2,gzip(gfe),gzip(gfe)
Path: forums-1-dub!forums-master!newssvr.sybase.com!news-sj-1.sprintlink.net!news-peer1.sprintlink.net!nntp1.phx1.gblx.net!nntp.gblx.net!nntp.gblx.net!border2.nntp.dca.giganews.com!nntp.giganews.com!postnews.google.com!g6g2000vbr.googlegroups.com!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28111
Article PK: 77355


On Aug 7, 8:24 am, RGS wrote:
> I have three types of servers in my comany:
>
> 1) Production
> 2) Test
> 3) Development
>
> 1 is very big but 2 and 3 are small
>
> I need a tool to copy:
>
> - All objects (tables, indexes, triggers, etc)
> - Some data (a integral portion of data)
>
> From production to test or development ASE servers
>
> Do you know a tool for this task?  I can not use BACKUP's
> utility because the servers don't have the same capacity
>
> Thanks a lot !!!

If you have the space available, you'll save yourself
a lot of heartburn if you make the test and development
databases the same size as production.

Then you can do a simple dump and load.

However, this won't help you much if you need a *selective*
dump and load. Depending on your needs, you might be able
to just delete or scramble sensitive production data after
performing the load.

/:-/


Carl Kayser Posted on 2009-08-08 12:40:21.0Z
From: "Carl Kayser" <kayser_c@bls.gov>
Newsgroups: sybase.public.ase.general
References: <4a7c471d.43d1.1681692777@sybase.com>
Subject: Re: Backups of Sybase
Lines: 38
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3350
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4a7d7235$2@forums-3-dub.sybase.com>
Date: 8 Aug 2009 05:40:21 -0700
X-Trace: forums-3-dub.sybase.com 1249735221 10.22.241.152 (8 Aug 2009 05:40:21 -0700)
X-Original-Trace: 8 Aug 2009 05:40:21 -0700, vip152.sybase.com
X-Authenticated-User: ase1251
Path: forums-1-dub!forums-master!forums-3-dub.sybase.com!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28112
Article PK: 77356


<RGS> wrote in message news:4a7c471d.43d1.1681692777@sybase.com...
>I have three types of servers in my comany:
>
> 1) Production
> 2) Test
> 3) Development
>
> 1 is very big but 2 and 3 are small
>
> I need a tool to copy:
>
> - All objects (tables, indexes, triggers, etc)
> - Some data (a integral portion of data)
>
> From production to test or development ASE servers
>
> Do you know a tool for this task? I can not use BACKUP's
> utility because the servers don't have the same capacity
>
> Thanks a lot !!!

We use SQL-BackTrack logical dump/lopads for this. It can do "all objects"
however SPs that use common # tables won't be created. Basically it bcps
out all of the tables and reverse engineers all of the other objects. Temp
tables are an achilles heel with this regard. On the other hand a net
effect is that the tables end up being compressed owing to the bcps. It can
also do the second I believe although I've never tried that. Also just data
without compiled objects. It can also do physical backups - basically a
front end interface to standard ASE backups that simplifies their
management.

BMC
(http://www.bmc.com/products/offering/bmc-database-recovery-management.html)
owns the product and their site is confusing to me. What's the difference
between "Recovery Manager for Databases" and "Datbaase Recovery Management"?


mos351 Posted on 2009-08-08 16:44:05.0Z
From: mos351 <mos3512009@gmail.com>
Newsgroups: sybase.public.ase.general
Subject: Re: Backups of Sybase
Date: Sat, 8 Aug 2009 09:44:05 -0700 (PDT)
Organization: http://groups.google.com
Lines: 55
Message-ID: <cafc0d82-e55c-4abf-8b57-13ba04adcf25@o13g2000vbl.googlegroups.com>
References: <4a7c471d.43d1.1681692777@sybase.com> <4a7d7235$2@forums-3-dub.sybase.com>
NNTP-Posting-Host: 63.167.114.204
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
X-Trace: posting.google.com 1249749846 16164 127.0.0.1 (8 Aug 2009 16:44:06 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Sat, 8 Aug 2009 16:44:06 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: o13g2000vbl.googlegroups.com; posting-host=63.167.114.204; posting-account=N2EToAoAAADJEu-AjH0VCur8a3BjK2Ev
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.2; WOW64; SV1; .NET CLR 2.0.50727; .NET CLR 1.1.4322; InfoPath.1; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729),gzip(gfe),gzip(gfe)
Path: forums-1-dub!forums-master!newssvr.sybase.com!news-sj-1.sprintlink.net!news-peer1.sprintlink.net!nntp1.phx1.gblx.net!nntp.gblx.net!nntp.gblx.net!border2.nntp.dca.giganews.com!nntp.giganews.com!postnews.google.com!o13g2000vbl.googlegroups.com!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28115
Article PK: 77362


On Aug 8, 8:40 am, "Carl Kayser" <kayse...@bls.gov> wrote:
> <RGS> wrote in messagenews:4a7c471d.43d1.1681692777@sybase.com...
> >I have three types of servers in my comany:
>
> > 1) Production
> > 2) Test
> > 3) Development
>
> > 1 is very big but 2 and 3 are small
>
> > I need a tool to copy:
>
> > - All objects (tables, indexes, triggers, etc)
> > - Some data (a integral portion of data)
>
> > From production to test or development ASE servers
>
> > Do you know a tool for this task?  I can not use BACKUP's
> > utility because the servers don't have the same capacity
>
> > Thanks a lot !!!
>
> We use SQL-BackTrack logical dump/lopads for this.  It can do "all objects"
> however SPs that use common # tables won't be created.  Basically it bcps
> out all of the tables and reverse engineers all of the other objects.  Temp
> tables are an achilles heel with this regard.  On the other hand a net
> effect is that the tables end up being compressed owing to the bcps.  It can
> also do the second I believe although I've never tried that.  Also just data
> without compiled objects.  It can also do physical backups - basically a
> front end interface to standard ASE backups that simplifies their
> management.
>
> BMC
> (http://www.bmc.com/products/offering/bmc-database-recovery-management...)
> owns the product and their site is confusing to me.  What's the difference
> between "Recovery Manager for Databases" and "Datbaase Recovery Management"?- Hide quoted text -
>
> - Show quoted text -

The eternal problem...Can you get space for a stage environment? D&L,
truncate data, use selective replication to move data? We were able
to create a shell ASE with schema only, built a utility to move
scrubbed data (prior to implementing replication). Data seemed the
easy part, moving objects with all dependencies was more then
challenging. Curious, what tool do you currently use to deploy
objects from dev to test to production?


Carl Kayser Posted on 2009-08-10 10:13:32.0Z
From: "Carl Kayser" <kayser_c@bls.gov>
Newsgroups: sybase.public.ase.general
References: <4a7c471d.43d1.1681692777@sybase.com> <4a7d7235$2@forums-3-dub.sybase.com> <cafc0d82-e55c-4abf-8b57-13ba04adcf25@o13g2000vbl.googlegroups.com>
Subject: Re: Backups of Sybase
Lines: 60
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2900.3350
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4a7ff2cc$5@forums-3-dub.sybase.com>
Date: 10 Aug 2009 03:13:32 -0700
X-Trace: forums-3-dub.sybase.com 1249899212 10.22.241.152 (10 Aug 2009 03:13:32 -0700)
X-Original-Trace: 10 Aug 2009 03:13:32 -0700, vip152.sybase.com
X-Authenticated-User: ase1251
Path: forums-1-dub!forums-master!forums-3-dub.sybase.com!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28119
Article PK: 77360

"mos351" <mos3512009@gmail.com> wrote in message
news:cafc0d82-e55c-4abf-8b57-13ba04adcf25@o13g2000vbl.googlegroups.com...

On Aug 8, 8:40 am, "Carl Kayser" <kayse...@bls.gov> wrote:
> <RGS> wrote in messagenews:4a7c471d.43d1.1681692777@sybase.com...
> >I have three types of servers in my comany:
>
> > 1) Production
> > 2) Test
> > 3) Development
>
> > 1 is very big but 2 and 3 are small
>
> > I need a tool to copy:
>
> > - All objects (tables, indexes, triggers, etc)
> > - Some data (a integral portion of data)
>
> > From production to test or development ASE servers
>
> > Do you know a tool for this task? I can not use BACKUP's
> > utility because the servers don't have the same capacity
>
> > Thanks a lot !!!
>
> We use SQL-BackTrack logical dump/lopads for this. It can do "all objects"
> however SPs that use common # tables won't be created. Basically it bcps
> out all of the tables and reverse engineers all of the other objects. Temp
> tables are an achilles heel with this regard. On the other hand a net
> effect is that the tables end up being compressed owing to the bcps. It
> can
> also do the second I believe although I've never tried that. Also just
> data
> without compiled objects. It can also do physical backups - basically a
> front end interface to standard ASE backups that simplifies their
> management.
>
> BMC
> (http://www.bmc.com/products/offering/bmc-database-recovery-management...)
> owns the product and their site is confusing to me. What's the difference
> between "Recovery Manager for Databases" and "Datbaase Recovery
> Management"?- Hide quoted text -
>
> - Show quoted text -

The eternal problem...Can you get space for a stage environment? D&L,
truncate data, use selective replication to move data? We were able
to create a shell ASE with schema only, built a utility to move
scrubbed data (prior to implementing replication). Data seemed the
easy part, moving objects with all dependencies was more then
challenging. Curious, what tool do you currently use to deploy
objects from dev to test to production?


We currently use SQL-BackTrack 5.7 with ASE 12.5.3 for prod to test to dev.
However, you asked the opposite. We use source code (i.e., SQL scripts) via
Version Manager and Team Track. Now we will have to convert Team Track to
Mashups. Can't say that I am impressed with the CM software.


Sherlock, Kevin [TeamSybase] Posted on 2009-08-10 15:08:33.0Z
From: "Sherlock, Kevin [TeamSybase]" <kevin.sherlock@teamsybase.com>
Newsgroups: sybase.public.ase.general
References: <4a7c471d.43d1.1681692777@sybase.com>
Subject: Re: Backups of Sybase
Lines: 27
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4a8037f1$1@forums-3-dub.sybase.com>
Date: 10 Aug 2009 08:08:33 -0700
X-Trace: forums-3-dub.sybase.com 1249916913 10.22.241.152 (10 Aug 2009 08:08:33 -0700)
X-Original-Trace: 10 Aug 2009 08:08:33 -0700, vip152.sybase.com
X-Authenticated-User: teamsybase
Path: forums-1-dub!forums-master!forums-3-dub.sybase.com!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28120
Article PK: 77363

Have you looked into using the functionality of Archive databases? You can
mount the production backup as a "virtual" database, and then in theory,
selectively move data from the archive database into your test/dev
databases.

<RGS> wrote in message news:4a7c471d.43d1.1681692777@sybase.com...
>I have three types of servers in my comany:
>
> 1) Production
> 2) Test
> 3) Development
>
> 1 is very big but 2 and 3 are small
>
> I need a tool to copy:
>
> - All objects (tables, indexes, triggers, etc)
> - Some data (a integral portion of data)
>
> From production to test or development ASE servers
>
> Do you know a tool for this task? I can not use BACKUP's
> utility because the servers don't have the same capacity
>
> Thanks a lot !!!


Dan Posted on 2009-08-11 19:18:48.0Z
From: "Dan" <danNOSPAM@pancamo.com>
Newsgroups: sybase.public.ase.general
References: <4a7c471d.43d1.1681692777@sybase.com> <4a8037f1$1@forums-3-dub.sybase.com>
Subject: Re: Backups of Sybase
Lines: 45
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2527
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2527
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4a81c418$2@forums-3-dub.sybase.com>
Date: 11 Aug 2009 12:18:48 -0700
X-Trace: forums-3-dub.sybase.com 1250018328 10.22.241.152 (11 Aug 2009 12:18:48 -0700)
X-Original-Trace: 11 Aug 2009 12:18:48 -0700, vip152.sybase.com
Path: forums-1-dub!forums-master!forums-3-dub.sybase.com!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28134
Article PK: 77380

Our DBA team currently does a nightly DUMP/LOAD of a database so we have 2
copies every day. The copy is a read 24 hours old copy of yesterdays
close... 64GB...

Is there a better way than using DUMP/LOAD which is extreemely IO entensive
every night and it basically blows out storage cache...

Does a clone or some type of archive database feature exist in ASE15?


the SA

"Sherlock, Kevin [TeamSybase]" <kevin.sherlock@teamsybase.com> wrote in
message news:4a8037f1$1@forums-3-dub.sybase.com...
> Have you looked into using the functionality of Archive databases? You
> can mount the production backup as a "virtual" database, and then in
> theory, selectively move data from the archive database into your test/dev
> databases.
>
> <RGS> wrote in message news:4a7c471d.43d1.1681692777@sybase.com...
>>I have three types of servers in my comany:
>>
>> 1) Production
>> 2) Test
>> 3) Development
>>
>> 1 is very big but 2 and 3 are small
>>
>> I need a tool to copy:
>>
>> - All objects (tables, indexes, triggers, etc)
>> - Some data (a integral portion of data)
>>
>> From production to test or development ASE servers
>>
>> Do you know a tool for this task? I can not use BACKUP's
>> utility because the servers don't have the same capacity
>>
>> Thanks a lot !!!
>
>


"Mark A. Parsons" <iron_horse Posted on 2009-08-11 19:49:50.0Z
From: "Mark A. Parsons" <iron_horse@no_spamola.compuserve.com>
User-Agent: Thunderbird 1.5.0.10 (Windows/20070221)
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: Backups of Sybase
References: <4a7c471d.43d1.1681692777@sybase.com> <4a8037f1$1@forums-3-dub.sybase.com> <4a81c418$2@forums-3-dub.sybase.com>
In-Reply-To: <4a81c418$2@forums-3-dub.sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Antivirus: avast! (VPS 090808-0, 08/08/2009), Outbound message
X-Antivirus-Status: Clean
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4a81cb5e$2@forums-3-dub.sybase.com>
Date: 11 Aug 2009 12:49:50 -0700
X-Trace: forums-3-dub.sybase.com 1250020190 10.22.241.152 (11 Aug 2009 12:49:50 -0700)
X-Original-Trace: 11 Aug 2009 12:49:50 -0700, vip152.sybase.com
Lines: 76
Path: forums-1-dub!forums-master!forums-3-dub.sybase.com!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28136
Article PK: 77379

Some storage options provide the ability to split off a mirror image of a set of devices. (Obviously ?) This typically
means that the storage admin has created the devices with an active mirror (either in sync or async mode).

For an ASE dataserver this would look like:

0 - assuming the active mirror is in place and (nearly) in sync
1 - suspend database activity (eg, shutdown dataserver, quiesce database)
2 - once storage system shows mirror devices are in sync ...
3 - split mirror away from primary device
4 - bring up primary database (eg, start dataserver, unquiesce database)
5 - mirrored devices can now be used for other activities

Most folks will script the above process. Assuming little/no time to sync the mirror (step #2), this entire split
process is quicker than the dump/load process (depending on number of devices and the method you use to suspend database
activity).

Obviously (?) before doing another split ... at some point you'll need to add the mirrors back into the primary system
so that said mirrors can be synced with the primary devices.

--------------------

Another (more expensive) option would include using Sybase's Replication Server product to keep the secondary database
in sync by replicating transactions as they occur.

--------------------

'course, it's still a good idea to make regular backups of your primary database ... though with the mirror/split option
you could perform the dump from the secondary copy.

Dan wrote:
> Our DBA team currently does a nightly DUMP/LOAD of a database so we have 2
> copies every day. The copy is a read 24 hours old copy of yesterdays
> close... 64GB...
>
> Is there a better way than using DUMP/LOAD which is extreemely IO entensive
> every night and it basically blows out storage cache...
>
> Does a clone or some type of archive database feature exist in ASE15?
>
>
> the SA
>
>
>
> "Sherlock, Kevin [TeamSybase]" <kevin.sherlock@teamsybase.com> wrote in
> message news:4a8037f1$1@forums-3-dub.sybase.com...
>> Have you looked into using the functionality of Archive databases? You
>> can mount the production backup as a "virtual" database, and then in
>> theory, selectively move data from the archive database into your test/dev
>> databases.
>>
>> <RGS> wrote in message news:4a7c471d.43d1.1681692777@sybase.com...
>>> I have three types of servers in my comany:
>>>
>>> 1) Production
>>> 2) Test
>>> 3) Development
>>>
>>> 1 is very big but 2 and 3 are small
>>>
>>> I need a tool to copy:
>>>
>>> - All objects (tables, indexes, triggers, etc)
>>> - Some data (a integral portion of data)
>>>
>>> From production to test or development ASE servers
>>>
>>> Do you know a tool for this task? I can not use BACKUP's
>>> utility because the servers don't have the same capacity
>>>
>>> Thanks a lot !!!
>>
>
>


Sherlock, Kevin [TeamSybase] Posted on 2009-08-11 20:03:11.0Z
From: "Sherlock, Kevin [TeamSybase]" <kevin.sherlock@teamsybase.com>
Newsgroups: sybase.public.ase.general
References: <4a7c471d.43d1.1681692777@sybase.com> <4a8037f1$1@forums-3-dub.sybase.com> <4a81c418$2@forums-3-dub.sybase.com>
Subject: Re: Backups of Sybase
Lines: 55
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4a81ce7f$2@forums-3-dub.sybase.com>
Date: 11 Aug 2009 13:03:11 -0700
X-Trace: forums-3-dub.sybase.com 1250020991 10.22.241.152 (11 Aug 2009 13:03:11 -0700)
X-Original-Trace: 11 Aug 2009 13:03:11 -0700, vip152.sybase.com
X-Authenticated-User: teamsybase
Path: forums-1-dub!forums-master!forums-3-dub.sybase.com!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28138
Article PK: 77382

I was specifically referring to the "Archive Database Access" introduced in
15.0.2

http://infocenter.sybase.com/help/topic/com.sybase.infocenter.dc00641.1502/html/nfg1502/CHDHAJEF.htm

"Dan" <danNOSPAM@pancamo.com> wrote in message
news:4a81c418$2@forums-3-dub.sybase.com...
> Our DBA team currently does a nightly DUMP/LOAD of a database so we have 2
> copies every day. The copy is a read 24 hours old copy of yesterdays
> close... 64GB...
>
> Is there a better way than using DUMP/LOAD which is extreemely IO
> entensive every night and it basically blows out storage cache...
>
> Does a clone or some type of archive database feature exist in ASE15?
>
>
> the SA
>
>
>
> "Sherlock, Kevin [TeamSybase]" <kevin.sherlock@teamsybase.com> wrote in
> message news:4a8037f1$1@forums-3-dub.sybase.com...
>> Have you looked into using the functionality of Archive databases? You
>> can mount the production backup as a "virtual" database, and then in
>> theory, selectively move data from the archive database into your
>> test/dev databases.
>>
>> <RGS> wrote in message news:4a7c471d.43d1.1681692777@sybase.com...
>>>I have three types of servers in my comany:
>>>
>>> 1) Production
>>> 2) Test
>>> 3) Development
>>>
>>> 1 is very big but 2 and 3 are small
>>>
>>> I need a tool to copy:
>>>
>>> - All objects (tables, indexes, triggers, etc)
>>> - Some data (a integral portion of data)
>>>
>>> From production to test or development ASE servers
>>>
>>> Do you know a tool for this task? I can not use BACKUP's
>>> utility because the servers don't have the same capacity
>>>
>>> Thanks a lot !!!
>>
>>
>
>