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.

Partially restoring tables...

3 posts in Windows NT Last posting was on 2000-12-20 01:31:50.0Z
Nslam <""nslam\" Posted on 2000-12-13 17:32:02.0Z
Date: Wed, 13 Dec 2000 12:32:02 -0500
From: Nslam <""nslam\"@(none)>
User-Agent: Mozilla/5.0 (X11; U; Linux 2.2.16 i686; en-US; m18) Gecko/20001107 Netscape6/6.0
X-Accept-Language: en
MIME-Version: 1.0
Subject: Partially restoring tables...
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
Message-ID: <wZxWR3SZAHA.71@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
Lines: 5
NNTP-Posting-Host: ip130n1.int.cen2k.com 12.27.150.130
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:1413
Article PK: 1088882

Hello,

I want to know if there is a way to partially restore 2 tables from a
bcp, not the whole database. If not, is there a site I can go to that
will help me load a bcp?


David Owen Posted on 2000-12-20 01:31:50.0Z
Sender: dowen@n-utsire.midsomer.org
Subject: Re: Partially restoring tables...
References: <wZxWR3SZAHA.71@forums.sybase.com>
From: David Owen <dowen@midsomer.org>
Organization: Midsomer Consultants Inc.
Date: 19 Dec 2000 18:31:50 -0700
Message-ID: <m3ae9rlvy1.fsf@n-utsire.midsomer.org>
Lines: 24
User-Agent: Gnus/5.0802 (Gnus v5.8.2) Emacs/20.7
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: 24.70.23.85
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:1381
Article PK: 1088853

>>>>> "Nslam" == none <Nslam> writes:

Nslam> Hello, I want to know if there is a way to partially restore 2
Nslam> tables from a bcp, not the whole database. If not, is there a
Nslam> site I can go to that will help me load a bcp?

A bcp or a dump? Bcp is done on a table by table basis and so should not
be a problem. If it is a database dump that you are referring to, then you
will need to restore it to a separate database and then copy the tables for
the separate database.

There is a tool from BMC that will take "logical" dumps of a database and
from that you can restore individual objects. I don't believe that it is
smart enough to do it directly from a Sybase dump.

I am sure that this would be an excellent project for someone at Sybase to
undertake!!

dowen

PS BTW, Sybase can do point in time recovery using its logs.
--
David Owen Midsomer Consultants Inc. dowen@midsomer.org
Maintainer of the Sybase FAQ: http://www.isug.com/Sybase_FAQ


Anonymous Posted on 2000-12-15 04:47:25.0Z
From: Anonymous@sybase.com
Date: Thu, 14 Dec 2000 23:47:25 -0500
Newsgroups: sybase.public.sqlserver.nt
Subject: Re: Partially restoring tables...
Message-ID: <978D15E7EEE16FA4001A506E852569B6.006D1843852569B4@webforums>
References: <wZxWR3SZAHA.71@forums.sybase.com>
Lines: 13
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 sybase.public.sqlserver.nt:1396
Article PK: 1088862

Welcome to Sybase.

Oracle supports partial recovery using partitioned
tablespaces OR point in time recovery from the redo logs
OR the sqloader from a flat file (with appropriate filters
for the desired records).

As for Sybase, as usual your out of luck.
May be you could load the flat records into a temporary
table than write a PB program to pipeline the proper
records into the table.

Or may it would be faster to conver to Oracle : )