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.

Copy devices files (ASE1503) between Win64 and Linux64

2 posts in General Discussion Last posting was on 2010-11-26 09:34:34.0Z
Tomasz Romanowski Posted on 2010-11-26 07:56:55.0Z
Reply-To: "Tomasz Romanowski" <tromanowski@sps-poland.pl>
From: "Tomasz Romanowski" <tromanowski@sps-poland.pl>
Newsgroups: sybase.public.ase.general
Subject: Copy devices files (ASE1503) between Win64 and Linux64
Lines: 16
Organization: Sybase Poland
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: <4cef6847@forums-1-dub>
Date: 25 Nov 2010 23:56:55 -0800
X-Trace: forums-1-dub 1290758215 10.22.241.152 (25 Nov 2010 23:56:55 -0800)
X-Original-Trace: 25 Nov 2010 23:56:55 -0800, vip152.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29730
Article PK: 78962

Hi,

We need to migrate ASE 15.0.3 ESD#4 from WIN64 to Linux64 (both Little
Endian). There were be no sort,no charset and bit changes.
In documentation is that if there is no Little/Big Endian changes then there
is no conversion during cross-platform database dump/load.
Can we just bcp all tables from master with changing only devices paths to
new ones and then simple copy devices files from Win64 to Linux64?
Is this supported?
Or do we have to have to make full cross-platform dump?

best regards
Tomasz Romanowski
SPS Poland


Rob V [ Sybase ] Posted on 2010-11-26 09:34:34.0Z
From: "Rob V [ Sybase ]" <robv@DO.NOT.SPAM.sypron.nl.REMOVE.THIS.DECOY>
Reply-To: robv@DO.NOT.SPAM.sypron.nl.REMOVE.THIS.DECOY
Organization: Sypron BV / TeamSybase / Sybase
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.2.12) Gecko/20101027 Thunderbird/3.1.6
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: Copy devices files (ASE1503) between Win64 and Linux64
References: <4cef6847@forums-1-dub>
In-Reply-To: <4cef6847@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4cef7f2a$1@forums-1-dub>
Date: 26 Nov 2010 01:34:34 -0800
X-Trace: forums-1-dub 1290764074 10.22.241.152 (26 Nov 2010 01:34:34 -0800)
X-Original-Trace: 26 Nov 2010 01:34:34 -0800, vip152.sybase.com
Lines: 39
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29731
Article PK: 78958


On 26-Nov-2010 08:56, Tomasz Romanowski wrote:
> Hi,
>
> We need to migrate ASE 15.0.3 ESD#4 from WIN64 to Linux64 (both Little
> Endian). There were be no sort,no charset and bit changes.
> In documentation is that if there is no Little/Big Endian changes then there
> is no conversion during cross-platform database dump/load.
> Can we just bcp all tables from master with changing only devices paths to
> new ones and then simple copy devices files from Win64 to Linux64?
> Is this supported?
> Or do we have to have to make full cross-platform dump?
>
> best regards
> Tomasz Romanowski
> SPS Poland
>
>

Copying the device files between platforms is not supported. Having said
that, it *may* work. The only way to find out is to try...

HTH,

Rob V.
-----------------------------------------------------------------
Rob Verschoor

Certified Sybase Professional DBA for ASE 15.0/12.5/12.0/11.5/11.0
and Replication Server 15.0.1/12.5 // TeamSybase

Author of Sybase books (order online at www.sypron.nl/shop):
"Tips, Tricks& Recipes for Sybase ASE" (ASE 15 edition)
"The Complete Sybase ASE Quick Reference Guide"
"The Complete Sybase Replication Server Quick Reference Guide"

rob@NO.SPAM.sypron.nl | www.sypron.nl | Twitter: @rob_verschoor
Sypron B.V., The Netherlands | Chamber of Commerce 27138666
-----------------------------------------------------------------