Forum OpenACS Q&A: porting acs sql to mssql7.0

Posted by David Wu on 06/21/00 08:45 PM

I am trying to decide if it makes sense to port the acs sql
definitions to mssql 7.0. Can anyone send to me (or point me to) the
changes that were made to acs to support postgres? For instance, I
expect that decode (a non-standard sql construct) does not work on
postgres. Any help would be appreciated. Thanks.

David

2: Response to porting acs sql to mssql7.0 (response to 1)

Posted by Roberto Mello on 06/21/00 08:53 PM

You can look at the guide that Ben, David and Don created for porting SQL from Oracle to PostgreSQL at openacs.org/doc/acspg. It's not an easy task especially when there are new versions coming out frequently.

What I think would be best for you to do is wait until ACS 4 comes out. We are waiting for ACS 4 so we can port it to PostgreSQL and it's going to be much better to port it because of the new aD database API.

Porting to MS-SQL now would be a waste of time and effort, unless you want to stay with ACS 3.2.2 (or 3.2.3) forever and lose the delicious goodies in ACS 4.

3: Response to porting acs sql to mssql7.0 (response to 1)

Posted by Roberto Mello on 06/21/00 08:57 PM

I forgot to ask... wouldn't it be easier to just install PostgreSQL on your NT box ? It works just fine and PostgreSQL is a breeze to administer.

If I had access to a Win2K (or NT) box I could write some documentation on how to get it up and running on that environment. All you need is get PostgreSQL and AOLserver running on NT, then get OpenACS installed and be happy.

4: Response to porting acs sql to mssql7.0 (response to 1)

Posted by Brian Baquiran on 06/22/00 02:40 AM

If you're only interested in the data model, then I guess it should port pretty quickly. You could try a pg_dump with the option to dump as SQL CREATE TABLEs and INSERTs on an existing OpenACS installation, then work from there.