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 to SQL server 2000

4 posts in General Discussion Last posting was on 2003-02-06 02:54:26.0Z
Tom_Vennik Posted on 2003-01-29 04:53:35.0Z
From: Tom_Vennik
Date: Tue, 28 Jan 2003 23:53:35 -0500
Newsgroups: ianywhere.public.general
Subject: Migration to SQL server 2000
Message-ID: <F1C3197A16A04276001AE0E085256CBD.001AE0F885256CBD@webforums>
Lines: 9
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 ianywhere.public.general:229
Article PK: 2050

Hi All

I am trying to do a migration from Sybase SQL Anywhere to SQL Server 2000.
The tables are migrated but I was wondering whether there were any tools
available to migrate the stored procedures and functions. Does someone know
if there is a tool like this?
Cheers

Tom


Emmanuel P Sanchez Posted on 2003-02-06 02:54:26.0Z
Message-ID: <3E41CE62.8020109@netscape.net>
Date: Wed, 05 Feb 2003 20:54:26 -0600
From: Emmanuel P Sanchez <barneowl@netscape.net>
Reply-To: barneowl@netscape.net
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.0.2) Gecko/20021120 Netscape/7.01
X-Accept-Language: en-us, en
MIME-Version: 1.0
Subject: Re: Migration to SQL server 2000
References: <F1C3197A16A04276001AE0E085256CBD.001AE0F885256CBD@webforums>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
Newsgroups: ianywhere.public.general
Lines: 13
NNTP-Posting-Host: c68.116.151.106.ftwrth.tx.charter.com 68.116.151.106
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub ianywhere.public.general:174
Article PK: 1992

Tom,

You can try using SQL Server's DTS functionality. Or you can use
PowerDesigner to reverse engineer the database.

Just my 2 cents.
Manny S.

Tom_Vennik wrote:
> Hi All
>
> I am trying to do a migration from Sybase SQL Anywhere to SQL Server 2000.
> The tables are migrated but I was wondering whether there were any tools
> available to migrate the stored procedures and functions. Does someone know
> if there is a tool like this?
> Cheers
>
> Tom


Rick Blythe Posted on 2003-01-29 15:13:29.0Z
From: "Rick Blythe" <rickb@ianywhere.com>
References: <F1C3197A16A04276001AE0E085256CBD.001AE0F885256CBD@webforums>
Subject: Re: Migration to SQL server 2000
Date: Wed, 29 Jan 2003 10:13:29 -0500
Lines: 20
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2720.3000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
Message-ID: <EgZTcu6xCHA.254@forums.sybase.com>
Newsgroups: ianywhere.public.general
NNTP-Posting-Host: 172.31.141.16
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub ianywhere.public.general:224
Article PK: 2044

I'm just curious, why do you feel you need to make this migration?

--
______________________
Whitepapers, TechDocs, bug fixes are all available through the iAnywhere
Developer Community at http://www.ianywhere.com/developer
______________________
<Tom_Vennik> wrote in message
news:F1C3197A16A04276001AE0E085256CBD.001AE0F885256CBD@webforums...
Hi All

I am trying to do a migration from Sybase SQL Anywhere to SQL Server 2000.
The tables are migrated but I was wondering whether there were any tools
available to migrate the stored procedures and functions. Does someone know
if there is a tool like this?
Cheers

Tom


Bart <bartvankuijk_spam_go Posted on 2003-01-29 11:03:13.0Z
Message-ID: <3E37B4F1.BBFCA3C2@away_yahoo.com>
Date: Wed, 29 Jan 2003 11:03:13 +0000
From: Bart <bartvankuijk_spam_go@away_yahoo.com>
X-Mailer: Mozilla 4.72 [en] (Windows NT 5.0; I)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: Migration to SQL server 2000
References: <F1C3197A16A04276001AE0E085256CBD.001AE0F885256CBD@webforums>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: ianywhere.public.general
Lines: 15
NNTP-Posting-Host: 158.76.235.187
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub ianywhere.public.general:227
Article PK: 2046

Try Sybase PowerDesigner. It is meant for database modelling and supports many
RDBMS.
It will migrate the complete database schema, including procedures and
triggers.

http://www.sybase.com/products/enterprisemodeling/powerdesigner

Bart

Tom_Vennik wrote:

> Hi All
>
> I am trying to do a migration from Sybase SQL Anywhere to SQL Server 2000.
> The tables are migrated but I was wondering whether there were any tools
> available to migrate the stored procedures and functions. Does someone know
> if there is a tool like this?
> Cheers
>
> Tom