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 from ASA to Sybase Server.

2 posts in ,  General Discussion Windows NT Last posting was on 2000-02-16 03:50:50.0Z
Yossi Zaig Posted on 2000-02-15 19:55:07.0Z
From: "Yossi Zaig" <asakimrd@netvision.net.il>
Subject: Migration from ASA to Sybase Server.
Date: Tue, 15 Feb 2000 21:55:07 +0200
Lines: 10
Organization: Asakim
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2014.211
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2014.211
Message-ID: <ymsIb8#d$GA.149@forums.sybase.com>
Newsgroups: sybase.public.sqlanywhere.general,sybase.public.sqlserver.nt
NNTP-Posting-Host: RAS4-p38.rlz.netvision.net.il 62.0.169.162
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlanywhere.general:2817 sybase.public.sqlserver.nt:495
Article PK: 880727

Hi.

Is it possible that ASA 6.03 DB will work under Sybase server without doing
anything, if yes what should I do, should I create my database as Transact
SQL or I just need to write my procedures as Transact SQL ?

Best Regards.
Yossi Zaig.


Jim Egan Posted on 2000-02-16 03:50:50.0Z
From: eganjp@compuserve.com (Jim Egan)
Subject: Re: Migration from ASA to Sybase Server.
Date: Tue, 15 Feb 2000 21:50:50 -0600
Message-ID: <MPG.1313da988c2029f598a602@forums.sybase.com>
References: <ymsIb8#d$GA.149@forums.sybase.com>
Reply-To: eganjp@compuserve.com
X-Newsreader: MicroPlanet Gravity v2.11
Newsgroups: sybase.public.sqlanywhere.general,sybase.public.sqlserver.nt
Lines: 14
NNTP-Posting-Host: user-33qs1oj.dialup.mindspring.com 199.174.7.19
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlanywhere.general:2816 sybase.public.sqlserver.nt:494
Article PK: 880725

No, the files are not compatible. You will have to extract the database
structures using DBUNLOAD.EXE or through the utility in Sybase Central.

You will have to write your procedures as T-SQL. Just creating the
database for T-SQL compatibility isn't enough. See the ASA online help
under "compatibility: Adaptive Server Enterprise" or CHAPTER 30.
Transact-SQL Compatibility in the manual.
--
Jim Egan [TeamSybase]
Houston, TX

Sybase Developers Network
http://sdn.sybase.com/sdn/mec/mec_home.stm