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.

need BCP assistance...

3 posts in Windows NT Last posting was on 2000-12-18 14:03:20.0Z
root <""root\" Posted on 2000-12-13 17:24:27.0Z
Date: Wed, 13 Dec 2000 12:24:27 -0500
From: root <""root\"@(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: need BCP assistance...
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
Message-ID: <eJ0YCzSZAHA.276@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
Lines: 11
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:1415
Article PK: 1088885

I set up Sybase Enterprise on a NT system, but I have a bcp from the
unix world. Everytime I try to load the database into the NT system it
constantly messages me that it could not connect to SYB_BACKUP. Another
question, my system doesn't have to be configured exactly like the unix
sybase database to make the transfer does it? Any help with this would
be greatly appreciated.


Anonymous Posted on 2000-12-15 10:06:56.0Z
From: Anonymous@sybase.com
Date: Fri, 15 Dec 2000 05:06:56 -0500
Newsgroups: sybase.public.sqlserver.nt
Subject: Re: need BCP assistance...
Message-ID: <A3F518AC621DAB0600379132852569B6.006D1847852569B4@webforums>
References: <eJ0YCzSZAHA.276@forums.sybase.com>
Lines: 5
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:1387
Article PK: 1088852

Install the Backup server too.

Run it along with the Sybase Server and then bcp in the data.

See if this works.


George Saylor Posted on 2000-12-18 14:03:20.0Z
From: "George Saylor" <GMSAYLORIII@email.msn.com>
References: <eJ0YCzSZAHA.276@forums.sybase.com> <A3F518AC621DAB0600379132852569B6.006D1847852569B4@webforums>
Subject: Re: need BCP assistance...
Date: Mon, 18 Dec 2000 09:03:20 -0500
Lines: 34
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
Message-ID: <sSTUq1PaAHA.207@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: 1Cust198.tnt1.baltimore.md.da.uu.net 63.24.126.198
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:1386
Article PK: 1088851

The backupserver is not part of bulk copy, that is for dumps, if you are
trying to load a database dump from unix save yourself the trouble it won't
load on NT.

You will have to use DDL and then bcp, Sybase Central is included on the
client CD so you can use it to reverse engineer the database. You could
also use CIS and proxy tables or replication but these are mildly more
complex.

bcp is in one of 2 places depending on your version

if version is 11.x

%SYBASE%\bin

else if version is 12.x

%SYBASE%\%SYBASE_OCS%\bin



HTH,
George

<Anonymous@sybase.com> wrote in message
news:A3F518AC621DAB0600379132852569B6.006D1847852569B4@webforums...
> Install the Backup server too.
>
> Run it along with the Sybase Server and then bcp in the data.
>
> See if this works.