It will probably be a good idea to avoid, if possible, the less powerfull MS SQL-Server solution...
Best,
-- Pierre
Le 14 avr. 05, � 20:50, Oak Norton a �crit :
Hello all, I'm a total newbie to Revolution and I have limited programming
experience. I'm one of those people I read about in a recent post that
needs a solution so I figure out how to program it for myself. My
experience has mostly been with cold fusion and MS-SQL/Access. I've been
leaning toward MySQL for a cross-platform project, but from the posts on
this board I'm just about ready to look at PostgreSQL. I know there's some
differences between all the SQL's but don't know much about what they are.
In the example below I see a bit of code which illustrated that point and
just worries me a tad because I find Access invaluable to build queries
quickly and test them out and if I didn't have to change the code at all,
that would be a big plus. So which of the sql flavors is closest to MSSQL
and will go cross-platform?
Thanks,
Oak
It's been my experience that if you ultimately want to move to Oracle, Postgresql is a better choice than mySQL because PG tries to be as Oracle compatible as possible. I can also tell you from experience that if you want to move to MS SQL Server later, be VERY careful about your SQL since there are lots of things that are incompatible even with "simple" SQL statements. For example, in Oracle/Postgres you would join two fields you would use something like SELECT last_name || ', ' || first_name whereas in MS SQL it would be SELECT last_name + ', ' + first_name (very VB like).
_______________________________________________ use-revolution mailing list [email protected] http://lists.runrev.com/mailman/listinfo/use-revolution
_______________________________________________ use-revolution mailing list [email protected] http://lists.runrev.com/mailman/listinfo/use-revolution
