MS SQL server anyone?

Michael James 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,
michaelj

-- 
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 mailing list