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.

Migration of SQL Server Database to Sybase ASE

3 posts in General Discussion Last posting was on 2012-09-26 13:04:42.0Z
Digambar Posted on 2012-08-31 18:17:41.0Z
Sender: 3b0e.5040fe4c.1804289383@sybase.com
From: Digambar
Newsgroups: sybase.public.ase.general
Subject: Migration of SQL Server Database to Sybase ASE
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <5040ffc5.3b7a.1681692777@sybase.com>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 31 Aug 2012 11:17:41 -0700
X-Trace: forums-1-dub 1346437061 172.20.134.41 (31 Aug 2012 11:17:41 -0700)
X-Original-Trace: 31 Aug 2012 11:17:41 -0700, 172.20.134.41
Lines: 7
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:31366
Article PK: 74255

How Can I migrate schema and data from SQL SERVER 2008 to
Sybase ASE 15.7?

I have installed Sybase ASE 15.7 and I need to migrate my
database from SQL Server to Sybase ASE but there is no free
tool available for it. I have to test my web application
with Sybase Database.


Sherlock, Kevin [TeamSybase] Posted on 2012-08-31 18:52:17.0Z
From: "Sherlock, Kevin [TeamSybase]" <kevin.sherlock@teamsybase.com>
Newsgroups: sybase.public.ase.general
References: <5040ffc5.3b7a.1681692777@sybase.com>
Subject: Re: Migration of SQL Server Database to Sybase ASE
Lines: 32
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5931
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.6157
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <504107e1$1@forums-1-dub>
Date: 31 Aug 2012 11:52:17 -0700
X-Trace: forums-1-dub 1346439137 172.20.134.152 (31 Aug 2012 11:52:17 -0700)
X-Original-Trace: 31 Aug 2012 11:52:17 -0700, vip152.sybase.com
X-Authenticated-User: teamsybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:31367
Article PK: 74256

Well, this doesn't really surprise me. Migrating from one DBMS vendor to
another is not a sufficiently trivial "walk in the park" to expect free
utilities to exist for it (and if there were, I'd be suspicious of their
quality and/or reliability). At a minimum, I would expect that you could
extract the DDL from the SQL SErver side, make some basic adjustments, and
create your database objects on the ASE side. Then, to transfer the data,
you could write a DTS job, use BCP, even perhaps use a linked server to ASE
to move the data over. Sybase has a product called "PowerDesigner' that
makes the schema conversion very easy. Also a utility called
"PowerTransfer" to move data, although i've never used that. These are
commercial (but relatively inexpesive) tools though.

Typically though, such vendor->vendor conversions require a whole lot more
consideration.

here is a white paper from Sybase on MSSQL conversion to ASE. It may not
say all that it needs to, but it's a good starting point.

http://www.sybase.com/content/1047976/MSSQL-ASE-Guide-111006-wp.pdf

<Digambar> wrote in message news:5040ffc5.3b7a.1681692777@sybase.com...
> How Can I migrate schema and data from SQL SERVER 2008 to
> Sybase ASE 15.7?
>
> I have installed Sybase ASE 15.7 and I need to migrate my
> database from SQL Server to Sybase ASE but there is no free
> tool available for it. I have to test my web application
> with Sybase Database.


Chris Jones Posted on 2012-09-26 13:04:42.0Z
From: Chris Jones <chris@j2consulting.co.uk>
Organization: J2
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.8; rv:15.0) Gecko/20120907 Thunderbird/15.0.1
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: Migration of SQL Server Database to Sybase ASE
References: <5040ffc5.3b7a.1681692777@sybase.com>
In-Reply-To: <5040ffc5.3b7a.1681692777@sybase.com>
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: <5062fd6a$1@forums-1-dub>
Date: 26 Sep 2012 06:04:42 -0700
X-Trace: forums-1-dub 1348664682 172.20.134.152 (26 Sep 2012 06:04:42 -0700)
X-Original-Trace: 26 Sep 2012 06:04:42 -0700, vip152.sybase.com
Lines: 35
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:31396
Article PK: 74285


On 31/08/2012 19:17, Digambar wrote:
> How Can I migrate schema and data from SQL SERVER 2008 to
> Sybase ASE 15.7?
>
> I have installed Sybase ASE 15.7 and I need to migrate my
> database from SQL Server to Sybase ASE but there is no free
> tool available for it. I have to test my web application
> with Sybase Database.
>

I'm significant experience in going the other. It's certainly -
potentially non trivial. However if your SQL Server version is
sufficiently old (2005 and back) then it's likely to be more compatible
with Sybase T-SQL.

A starting point is to audit the SQL Server code - looking for code
issues identified in the Sybase migration code. You can write some SQL
to run on SQL Server to look for potential issues (i.e. sysntax
differences).

Another good starting point is yo just suck all the code out of SQL
Server and see what loads. This will give you a good idea of where your
problems may lie.


You may be interested in joining a linked in group that is bringing
migration expertise together.

Any more questions let me know.

www.linkedin.com/groups/SAP-Migration-Sybase-4634032