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.

ASA as BackEnd for Web Apps

2 posts in General Discussion Last posting was on 2005-10-05 21:03:58.0Z
Lee Dong Gun Posted on 2005-10-04 06:26:33.0Z
Sender: 703a.43421dd9.1804289383@sybase.com
From: Lee Dong Gun
Newsgroups: ianywhere.public.general
Subject: ASA as BackEnd for Web Apps
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4342200a.7045.1681692777@sybase.com>
X-Original-NNTP-Posting-Host: 10.22.241.42
X-Original-Trace: 3 Oct 2005 23:24:10 -0700, 10.22.241.42
Lines: 9
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 3 Oct 2005 23:24:13 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 3 Oct 2005 23:26:33 -0700
X-Trace: forums-1-dub 1128407193 10.22.108.75 (3 Oct 2005 23:26:33 -0700)
X-Original-Trace: 3 Oct 2005 23:26:33 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!forums-2-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4829
Article PK: 17436

Hello...

Can you give me some pointers on how to standardize my web
ASA database meaning if my client choose ORACLE,postgres, or
other dbms
I can easily migrate my structures. What are the do's and
dont's.

Lee Dong Gun


Greg Fenton Posted on 2005-10-05 21:03:58.0Z
From: Greg Fenton <greg.fenton_NOSPAM_@ianywhere.com>
Organization: iAnywhere Solutions Inc.
User-Agent: Mozilla Thunderbird 1.6.3.2f (Windows/20050317)
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: ASA as BackEnd for Web Apps
References: <4342200a.7045.1681692777@sybase.com>
In-Reply-To: <4342200a.7045.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Original-NNTP-Posting-Host: cpe00096b10fe8a-cm000f212f9e50.cpe.net.cable.rogers.com
Message-ID: <43443f28$1@forums-2-dub>
X-Original-Trace: 5 Oct 2005 14:01:28 -0700, cpe00096b10fe8a-cm000f212f9e50.cpe.net.cable.rogers.com
Lines: 34
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 5 Oct 2005 14:01:29 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 5 Oct 2005 14:03:58 -0700
X-Trace: forums-1-dub 1128546238 10.22.108.75 (5 Oct 2005 14:03:58 -0700)
X-Original-Trace: 5 Oct 2005 14:03:58 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!forums-2-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4833
Article PK: 8568


Lee Dong Gun wrote:
> Can you give me some pointers on how to standardize my web
> ASA database meaning if my client choose ORACLE,postgres, or
> other dbms
> I can easily migrate my structures. What are the do's and
> dont's.

I'm not totally clear on what you are asking. I think you want to
create an ASA database, but want to be able to migrate to other RDBMS's
should a customer request it.

If so, then essentially stick to ANSI SQL as close as you can and avoid
using any vendor-specific extensions. This may sound well and good, but
there are many features of various databases that some people consider
"standard" but which in reality are not. There is also the fact that
when it comes to performance you often need to use some vendor-specific
features. You probably should avoid stored procedures and triggers as
many vendor implementations differ.

Most times that you write an application to support multiple backend
RDBMS's, you will end up having some places where it is necessary to
write db-specific code. Try to layer these aspects of your logic into a
"db layer" so that your business layer doesn't need to worry about the
details.

Hope this helps,
greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/