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.

Migrating from Solaris to Windows 2000

3 posts in Windows NT Last posting was on 2001-01-04 07:58:31.0Z
FT Posted on 2001-01-02 20:25:23.0Z
From: FT
Date: Tue, 2 Jan 2001 15:25:23 -0500
Newsgroups: sybase.public.sqlserver.nt
Subject: Migrating from Solaris to Windows 2000
Message-ID: <A10901E4F986D1A70070302D852569C8.0070304C852569C8@webforums>
Lines: 3
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:1360
Article PK: 1088827

Does anyone know if it is possible to migrate a whole Sybase SQL 11.0.1
Database running on Solaris UNIX 2.5.1 to a Windows 2000 Server possibly
running the latest Syabse SQL?


Liuping Posted on 2001-01-04 07:58:31.0Z
Reply-To: "Liuping" <lp_@163.net>
From: "Liuping" <lp_@163.net>
References: <A10901E4F986D1A70070302D852569C8.0070304C852569C8@webforums>
Subject: Re: Migrating from Solaris to Windows 2000
Date: Thu, 4 Jan 2001 15:58:31 +0800
Lines: 14
Organization: TechSoft
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2615.200
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2615.200
Message-ID: <tJi4bZidAHA.294@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: 202.104.15.150
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:1356
Article PK: 1088821

First,get DDL from old database using PowerDesignor
Second,Get all Data from old database using BCP
Third,ctreate database objects in new database using ISQL(run DDL)
Fourth,Put data into new database using BCP

Mail:homegao@sina.com

<FT> wrote in message
news:A10901E4F986D1A70070302D852569C8.0070304C852569C8@webforums...
> Does anyone know if it is possible to migrate a whole Sybase SQL 11.0.1
> Database running on Solaris UNIX 2.5.1 to a Windows 2000 Server possibly
> running the latest Syabse SQL?


Bret Halford Posted on 2001-01-02 23:03:22.0Z
Message-ID: <3A525E3A.CBF776CC@sybase.com>
Date: Tue, 02 Jan 2001 16:03:22 -0700
From: Bret Halford <bret@sybase.com>
Organization: Sybase, Inc.
X-Mailer: Mozilla 4.5 [en]C-CCK-MCD (WinNT; I)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: Migrating from Solaris to Windows 2000
References: <A10901E4F986D1A70070302D852569C8.0070304C852569C8@webforums>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 12
NNTP-Posting-Host: bret-pc.sybase.com 157.133.80.211
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:1359
Article PK: 1088824

Yes, quite possible. You can't do it by dump and load, but you can extract
the DDL
for the databases, BCP out the data, and load all into the new server, then
test
for behavior changes (there have been a few since 11.0.1)

-bret

FT wrote:

> Does anyone know if it is possible to migrate a whole Sybase SQL 11.0.1
> Database running on Solaris UNIX 2.5.1 to a Windows 2000 Server possibly
> running the latest Syabse SQL?