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.

Loading a 2k backup on 4k

3 posts in General Discussion Last posting was on 2010-01-13 12:40:29.0Z
Kon T. Amusse Posted on 2010-01-13 10:20:25.0Z
From: "Kon T. Amusse" <kon.t@amusse.invalid>
Newsgroups: sybase.public.ase.general
Subject: Loading a 2k backup on 4k
Date: Wed, 13 Jan 2010 11:20:25 +0100
Organization: A noiseless patient Spider
Lines: 2
Message-ID: <hik6p8$enp$1@news.eternal-september.org>
Mime-Version: 1.0
Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=original
Content-Transfer-Encoding: 7bit
Injection-Date: Wed, 13 Jan 2010 10:20:24 +0000 (UTC)
Injection-Info: feeder.eternal-september.org; posting-host="nuHTEM70RHJfEkyxMSPYWA"; logging-data="15097"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1/GbWdukXT+h7YGZBjhEXxDe5ju+wlSRgI="
X-MimeOLE: Produced By Microsoft MimeOLE V6.0.6002.18005
X-Newsreader: Microsoft Windows Mail 6.0.6002.18005
Cancel-Lock: sha1:Xhrqae4rJ4JcmDxTvjnih8PNxgA=
X-Priority: 3
X-MSMail-Priority: Normal
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!newsfeed.news2me.com!newsfeed2.telusplanet.net!newsfeed.telus.net!feeder.erje.net!feeder.eternal-september.org!eternal-september.org!.POSTED!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28873
Article PK: 78115

I have a server with pagesize 2k. I want to copy it on a 4k server.
Is it possible to dump database from 2k, and load database on 4k?


mpeppler@peppler.org [Team Sybase] Posted on 2010-01-13 12:19:40.0Z
From: "mpeppler@peppler.org [Team Sybase]" <michael.peppler@gmail.com>
Newsgroups: sybase.public.ase.general
Subject: Re: Loading a 2k backup on 4k
Date: Wed, 13 Jan 2010 04:19:40 -0800 (PST)
Organization: http://groups.google.com
Lines: 10
Message-ID: <e65506da-89ef-40f1-80b4-45cf7c65c42a@u7g2000yqm.googlegroups.com>
References: <hik6p8$enp$1@news.eternal-september.org>
NNTP-Posting-Host: 170.148.198.156
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
X-Trace: posting.google.com 1263385180 2035 127.0.0.1 (13 Jan 2010 12:19:40 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Wed, 13 Jan 2010 12:19:40 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: u7g2000yqm.googlegroups.com; posting-host=170.148.198.156; posting-account=9rHMzAoAAADtzToS8d2WKVGlkISAvPdk
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-GB; rv:1.9.1.7) Gecko/20091221 Firefox/3.5.7,gzip(gfe),gzip(gfe)
Path: forums-1-dub!forums-master!newssvr.sybase.com!news-sj-1.sprintlink.net!news-peer1.sprintlink.net!newsfeed.yul.equant.net!novia!news-out.readnews.com!transit4.readnews.com!postnews.google.com!u7g2000yqm.googlegroups.com!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28875
Article PK: 78117


On Jan 13, 11:20 am, "Kon T. Amusse" <ko...@amusse.invalid> wrote:
> I have a server with pagesize 2k. I want to copy it on a 4k server.
> Is it possible to dump database from 2k, and load database on 4k?

No - you have to rebuild the server, load the DDL for all tables/procs/
etc, and then use bcp to extract the data and reload on the 4k server.

Or use "sybmigrate", which should be able to automate all of that.

Michael


Luc Van der Veurst Posted on 2010-01-13 12:40:29.0Z
From: "Luc Van der Veurst" <dba_azvub@hotmail.com>
Newsgroups: sybase.public.ase.general
References: <hik6p8$enp$1@news.eternal-september.org>
Subject: Re: Loading a 2k backup on 4k
Lines: 12
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
X-RFC2646: Format=Flowed; Response
X-Forwarded: by - (DeleGate/5.8.7)
X-Forwarded: by - (DeleGate/5.8.7)
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4b4dbf3d$1@forums-1-dub>
Date: 13 Jan 2010 04:40:29 -0800
X-Trace: forums-1-dub 1263386429 10.22.241.152 (13 Jan 2010 04:40:29 -0800)
X-Original-Trace: 13 Jan 2010 04:40:29 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28877
Article PK: 78118


"Kon T. Amusse" <kon.t@amusse.invalid> wrote in message
news:hik6p8$enp$1@news.eternal-september.org...
>I have a server with pagesize 2k. I want to copy it on a 4k server.
> Is it possible to dump database from 2k, and load database on 4k?

No, that's not possible.

Luc.