MS SQL server anyone?
michael at james.st
Fri Aug 30 11:32:42 EST 2002
A vendor is trying to sell us a membership database
but at present it only runs against a foxpro ODBC file
or a microsoft SQL (Sequel?) server.
I don't like the ODBC file idea.
A system involving shared access to a file
(between our Linux/Solaris and their Windows systems)
sounds like an invitation to untraceable db-file corruption.
So that leaves us with a windows server,
but it's just answering SQL queries on the intranet,
it need not be visible from the internet.
Does anyone know of any glaring faults of MS SQL?
Can Perl DBI and PHP work with it?
Does it provide reasonable robustness,
the ability to throw down checkpoints
ie: a consistent snapshot of the DB, while running,
or dump the DB into an ascii file of SQL commands like MySQL?
And for the conversion from the existing foxpro 2.6 system,
what open source tools exist to read a Foxpro data file.
Could they dump it into SQL that could be loaded into a MySQL/Postgress server?
TIA for any experience in this area,
A right not exercised is a privilege
a privilege not exercised is illegal.
Michael James michael at james.st
8 Brennan St Phone: +61 2 6247 2556
Hackett, ACT 2602 Mobile: +61 4 1747 4065
AUSTRALIA Fax: +61 2 6278 0011
More information about the linux