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.

MOVE MS SQL SERVER DB TO SYBASE

2 posts in Windows NT Last posting was on 2000-07-28 06:58:24.0Z
Jefferson Gallaway Posted on 2000-07-27 15:13:42.0Z
Reply-To: "Jefferson Gallaway" <gallaway@iname.com>
From: "Jefferson Gallaway" <gallaway@iname.com>
Subject: MOVE MS SQL SERVER DB TO SYBASE
Date: Thu, 27 Jul 2000 10:13:42 -0500
Lines: 7
Organization: NU EDGE TECHNOLOGIES
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4133.2400
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400
Message-ID: <4F2OX699$GA.90@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: 208.48.197.5
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:1815
Article PK: 1089286

How do I move a 50meg Microsoft SQL Server 7.0 db to SYBASE Adaptive
Enterprise database without using BCP. Also, do I need to recreate the
triggers, indexes and so forth?

THANKS!


"Mark A. Parsons" <pegasys Posted on 2000-07-28 06:58:24.0Z
Message-ID: <39812F0F.9D414C9A@_internet.co.nz>
Date: Fri, 28 Jul 2000 18:58:24 +1200
From: "Mark A. Parsons" <pegasys@_internet.co.nz>
Organization: Pegasys (2000) Limited
X-Mailer: Mozilla 4.72 [en] (Win98; U)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: MOVE MS SQL SERVER DB TO SYBASE
References: <4F2OX699$GA.90@forums.sybase.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 23
NNTP-Posting-Host: p260.ipa1-n8-16.iconz.net.nz 210.48.25.4
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:1813
Article PK: 1089284


Jefferson Gallaway wrote:

> How do I move a 50meg Microsoft SQL Server 7.0 db to SYBASE Adaptive
> Enterprise database without using BCP. Also, do I need to recreate the
> triggers, indexes and so forth?

Unless you can find a 3rd party package that'll let you drag-n-drop a
MSSQLServer db onto a Sybase ASE db ... you'll have to create the ASE
database from scratch, (possibly) re-code your MS stored procs and
triggers to work in ASE, pull the raw data from MS and load into ASE (bcp?
3rd party package, etc.), and (re)build indices in ASE.

Even if you do find a 3rd party package that claims to be as easy as
drag-n-drop ... I'd thoroughly test and verify that it does what it claims
to do ... in a test environment ... before even thinking about production
... duh, Mark!?

--
Mark A. Parsons

Iron Horse, Inc. iron_horse@compuserve.com
Pegasys (200), Ltd pegasys@internet.co.nz