porting phpMyAdmin to MSSQL

Hi,

I have a site written in PHP with MS SQL Server 2000 as the db backend. When
the site was made there was no need for advanced banner rotation so a 10
line script was written and it served well for years but now there's a need
for a much more powerful banner rotation.
At first I thought to buy some banner management app but after some time I
realized that phpMyAdmin is the best thing.
The problem is PMA uses MySQL. I can install MySQL on my box but I would
like to avoid that if possible.

With a lot of enthusiasm I started to port PMA. After about 70 hours of
coding I gave up :-) I managed to port all the queries except the date
related ones. Unfortunately they make about 70% of all queries. The problem
is because the date function of SQL and MySQL are so different I would have
to literally understand every query I "port" and believe me there are just
too many queries :-))

It's obvious that it would be very ridiculous to ask advice of any sort
because this port is just a matter of sitting down rolling up the sleeves
and typing but can somebody give me any advice? :-)

Also if you know any good commercial PHP+MSSQL banner management please let
me know.


Gordan

re: porting phpMyAdmin to MSSQL

"Gordan1" wrote:[color=blue]
> Hi,
>
> I have a site written in PHP with MS SQL Server 2000 as the db
> backend. When
> the site was made there was no need for advanced banner
> rotation so a 10
> line script was written and it served well for years but now
> there's a need
> for a much more powerful banner rotation.
> At first I thought to buy some banner management app but after
> some time I
> realized that phpMyAdmin is the best thing.
> The problem is PMA uses MySQL. I can install MySQL on my box
> but I would
> like to avoid that if possible.
>
> With a lot of enthusiasm I started to port PMA. After about 70
> hours of
> coding I gave up :-) I managed to port all the queries except
> the date
> related ones. Unfortunately they make about 70% of all
> queries. The problem
> is because the date function of SQL and MySQL are so different
> I would have
> to literally understand every query I "port" and believe me
> there are just
> too many queries :-))
>
> It's obvious that it would be very ridiculous to ask advice of
> any sort
> because this port is just a matter of sitting down rolling up
> the sleeves
> and typing but can somebody give me any advice? :-)
>
> Also if you know any good commercial PHP+MSSQL banner
> management please let
> me know.
>
>
> Gordan[/color]

Don’t have a ready answer, but you can search hotscripts.com for
banner management (use php from pull-down menu). Look for "database
abstraction layer" or something like that which says the s/w has
isolated the database layer.

Since mysql can easily be installed, and a lot of sql server hosting
companies (e.g. crystaltech) support mysql as well, have you
considered running an instance of mysql in parallel to sql server (to
spare yourself the coding changes and possible bugs, etc.).

--
http://www.dbForumz.com/ This article was posted by author's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.dbForumz.com/PHP-porting-...ict151269.html
Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbForumz.com/eform.php?p=506587