Hello.
i have an slightly off topic question, but i hope that somebody might know.

at the moment we have a database on a MS SQL 7 server.
This data will be transfered to PostgreSQL 7.4.5 or PostgreSQL 8 (when 
it is released). so far so good.

the question now arises, this current database is used in web 
application made with ASP on IIS5. The idea is to move the database and 
the application to a linux or unix environment. Is there a tool that can 
be used convert ASP pages into PHP (or any other language suitable for 
linux/unix), or should we prepare to rewrite most of the code?

Is there a tool, some add-in to apache perhaps that can run ASP code on 
linux/unix, this would help to have the system running while we recode 
the application.

Any thoughts on how such a transfer can be made?

thanks
stig

Sun, 03 Oct 2004 14:33:07 +0200
stig erikson <stigerikson_nospam_@yahoo.se>
OT moving from MS SQL to PostgreSQL
On Sun, 2004-10-03 at 06:33, stig erikson wrote:
> Hello.
> i have an slightly off topic question, but i hope that somebody might know.
> 
> at the moment we have a database on a MS SQL 7 server.
> This data will be transfered to PostgreSQL 7.4.5 or PostgreSQL 8 (when 
> it is released). so far so good.
> 
> the question now arises, this current database is used in web 
> application made with ASP on IIS5. The idea is to move the database and 
> the application to a linux or unix environment. Is there a tool that can 
> be used convert ASP pages into PHP (or any other language suitable for 
> linux/unix), or should we prepare to rewrite most of the code?
> 
> Is there a tool, some add-in to apache perhaps that can run ASP code on 
> linux/unix, this would help to have the system running while we recode 
> the application.

There are a few tools I've seen that will try to convert ASP to PHP, but
for the most part, they can't handle very complex code, so you're
probably better off just rewriting it and learning PHP on the way.

By the way, I have moved this over to -general, as this is quite off
topic for -hackers.  Next person to reply please remove the
pgsql-hackers address from the CC list please.


Sun, 03 Oct 2004 11:24:28 -0600
"Scott Marlowe" <smarlowe@qwest.net>
Re: [HACKERS] OT moving from MS SQL to PostgreSQL
On 3 Oct 2004 at 11:24, Scott Marlowe wrote:

> On Sun, 2004-10-03 at 06:33, stig erikson wrote:
> There are a few tools I've seen that will try to convert ASP to PHP, but
> for the most part, they can't handle very complex code, so you're
> probably better off just rewriting it and learning PHP on the way.
> 
> By the way, I have moved this over to -general, as this is quite off
> topic for -hackers.  Next person to reply please remove the
> pgsql-hackers address from the CC list please.
> 

Also you might want to try converting it to ASP.NET. If you use the 
mono packages you can run ASP.NET on Windows and Linux/Unix with 
very little change (if any).

I have done this just fine with some C# ASP.NET stuff using Apache, 
PostgreSQL and mod-mono. Just needed recompilation because mono 
doesn't understand the debug stuff the MS produces. Otherwise no 
changes.

Cheers,
Gary.


Sun, 03 Oct 2004 19:26:10 +0100
"Gary Doades" <gpd@gpdnet.co.uk>
Re: [HACKERS] OT moving from MS SQL to PostgreSQL
A long time ago, in a galaxy far, far away, stig erikson <stigerikson_nospam_@yahoo.se> wrote:
> Hello.
> i have an slightly off topic question, but i hope that somebody might know.
>
> at the moment we have a database on a MS SQL 7 server.
> This data will be transfered to PostgreSQL 7.4.5 or PostgreSQL 8 (when
> it is released). so far so good.
>
> the question now arises, this current database is used in web
> application made with ASP on IIS5. The idea is to move the database
> and the application to a linux or unix environment. Is there a tool
> that can be used convert ASP pages into PHP (or any other language
> suitable for linux/unix), or should we prepare to rewrite most of the
> code?
>
> Is there a tool, some add-in to apache perhaps that can run ASP code
> on linux/unix, this would help to have the system running while we
> recode the application.
>
> Any thoughts on how such a transfer can be made?

There was a company called Chillisoft that has an ASP processor for
Unix.  They got bought out by Sun:

  <http://wwws.sun.com/software/chilisoft/>

That being said, the tool typically considered the "ASP alternative"
seems to be PHP.

I'd have to colour myself quite conflicted about such...

- Perl gets widely used, and if I'm writing scripts, that what I
  typically use, despite it reading like line noise.

- PHP strikes me as being a re-creation of Perl, with pretty much all
  of the problems I'd regard as demerits.

- Python is _way_ nicer to read, but has the demerit that your 
  application will become a twisty maze of object classes.

- The alternative _I_ would most like would be to deploy web apps
  in Lisp, but I never have the "round tuits" to get into that
  very far...

There are painful things about pretty much every answer there, which
is undoubtedly why NONE of these systems (including MSFT/ASP) has been
able to become dominant over any of the others.

Whichever language you consider, look _seriously_ at what
modules/libraries are available for managing templates, as that is the
key to getting web apps to work out well, and if you can get something
that's high-powered, you can cut down on maintenance costs a lot.
-- 
wm(X,Y):-write(X),write('@'),write(Y). wm('cbbrowne','linuxfinances.info').
http://www3.sympatico.ca/cbbrowne/spiritual.html
If a stealth bomber crashes in a forest, will it make a sound?

Sun, 03 Oct 2004 14:50:52 -0400
Christopher Browne <cbbrowne@acm.org>
Re: OT moving from MS SQL to PostgreSQL
On P, 2004-10-03 at 20:24, Scott Marlowe wrote:
> On Sun, 2004-10-03 at 06:33, stig erikson wrote:
> > Is there a tool, some add-in to apache perhaps that can run ASP code on 
> > linux/unix, this would help to have the system running while we recode 
> > the application.
> 
> There are a few tools I've seen that will try to convert ASP to PHP, but
> for the most part, they can't handle very complex code, so you're
> probably better off just rewriting it and learning PHP on the way.
> 
> By the way, I have moved this over to -general, as this is quite off
> topic for -hackers.  Next person to reply please remove the
> pgsql-hackers address from the CC list please.

If you are adventurous you could also try to run ASP.NET on Mono as
described in:
http://www.pcquest.com/content/search/showarticle.asp?arid=47162&way=search

----------
Hannu

Mon, 04 Oct 2004 23:47:37 +0300
Hannu Krosing <hannu@tm.ee>
Re: [HACKERS] OT moving from MS SQL to PostgreSQL
You could use Sun's ASP engine which was originally produced by chilisoft.

http://wwws.sun.com/software/chilisoft/

-Edwin

On Sun, 03 Oct 2004 11:24:28 -0600, Scott Marlowe <smarlowe@qwest.net> wrote:
> On Sun, 2004-10-03 at 06:33, stig erikson wrote:
> > Hello.
> > i have an slightly off topic question, but i hope that somebody might know.
> >
> > at the moment we have a database on a MS SQL 7 server.
> > This data will be transfered to PostgreSQL 7.4.5 or PostgreSQL 8 (when
> > it is released). so far so good.
> >
> > the question now arises, this current database is used in web
> > application made with ASP on IIS5. The idea is to move the database and
> > the application to a linux or unix environment. Is there a tool that can
> > be used convert ASP pages into PHP (or any other language suitable for
> > linux/unix), or should we prepare to rewrite most of the code?
> >
> > Is there a tool, some add-in to apache perhaps that can run ASP code on
> > linux/unix, this would help to have the system running while we recode
> > the application.
> 
> There are a few tools I've seen that will try to convert ASP to PHP, but
> for the most part, they can't handle very complex code, so you're
> probably better off just rewriting it and learning PHP on the way.
> 
> By the way, I have moved this over to -general, as this is quite off
> topic for -hackers.  Next person to reply please remove the
> pgsql-hackers address from the CC list please.
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
>       subscribe-nomail command to majordomo@postgresql.org so that your
>       message can get through to the mailing list cleanly
>

Mon, 4 Oct 2004 19:24:17 -0500
Edwin Grubbs <edwin.grubbs@gmail.com>
Re: [HACKERS] OT moving from MS SQL to PostgreSQL

Christopher Browne <cbbrowne@acm.org> writes:

> - The alternative _I_ would most like would be to deploy web apps
>   in Lisp, but I never have the "round tuits" to get into that
>   very far...

If you find any tuits sometime you might want to check out Per Bothner's Kawa.
It's a scheme implementation that compiles to java bytecode. 

http://www.gnu.org/software/kawa/

Web pages seem to be one of the applications it's being used for. And I must
say, every time I work with html I do find myself wishing I working in a
language with real macros...

-- 
greg


11 Oct 2004 02:50:18 -0400
Greg Stark <gsstark@mit.edu>
Re: OT moving from MS SQL to PostgreSQL
Greg Stark schrieb:
> Christopher Browne <cbbrowne@acm.org> writes:
>>- The alternative _I_ would most like would be to deploy web apps
>>  in Lisp, but I never have the "round tuits" to get into that
>>  very far...
> 
> If you find any tuits sometime you might want to check out Per Bothner's Kawa.
> It's a scheme implementation that compiles to java bytecode. 
> 
> http://www.gnu.org/software/kawa/
> 
> Web pages seem to be one of the applications it's being used for. And I must
> say, every time I work with html I do find myself wishing I working in a
> language with real macros...

But scheme is just scheme. Most people tend to prefer the real thing 
(Common Lisp) after some time. Esp. when there arose so many new webapps 
for common lisp lately. See http://www.cliki.net/Web
That's a bit more then any scheme can offer, and it's based on an 
industry standard, in contrary to the existing 100 scheme 
implementations, which all do it differently on the corner edges. 
(culprit: tiny standard)

Personally I still prefer PHP, because it's a nice package (in contrary 
to perl) and I can hire more and cheaper dildo's to maintain it then. 
Manager's prefer that.
-- 
Reini Urban
http://xarch.tu-graz.ac.at/home/rurban/

Mon, 11 Oct 2004 15:58:09 +0200
Reini Urban <rurban@x-ray.at>
Re: OT moving from MS SQL to PostgreSQL