Databases: SQL Server Adaptation

Re: Databases: SQL Server Adaptation

by Les Kopari -
Number of replies: 0
> There was another that used open as a column name, which is not allowed  in
> SQL Server.

Similar problems converting to Oracle...wonder if we should upload these somewhere to
form a checklist.  I've got one for the conversion process from MySQL to Oracle, but
the problem there is 30-character names for MySQL's 64 character...haven't found a
workaround for that one that doesn't require changing Moodle code.

> So I wrote ASP to do the query, which I call from PHP.

This sounds like something that might be generally useful to other Moodlers...wonder
if you can sanitize it and upload it here in case someone else has a similar config.

> Ugly? Yes it is. But it works.

Sounds like you got the job done..

Thanks for the follow-up.

Les.