Re: [foxboro] client server

On 3/28/07, Corey R Clingo <corey.clingo@xxxxxxxx> wrote:
> SQL sounds good on paper, but if it is M$ SQL Server, and I'm running a
> processing script on a Unix box (AW51 or something else), how do I get to
> it?  Maybe there are Unix ODBC drivers for SQL Server, but it can't be
> common.

I don't think ODBC would be necessary. I am far from a proponent of
M$, but SQL is a standard (albeit every db has proprietary additions,
but you aren't required to use them). Just because the data would be
in M$ SQL Server, does not mean that it would be any harder to get out
than it is now. SQL Server has a command line query program. A SQL
script could be saved in a text file and run with the command line
utility. That would be easily scriptable from UNIX. Much in the same
way that no one needs to know the ICC commands to run the iccprt
script. I doubt ANY method they come up with for getting data out if
the IEE will be directly usable on the UNIX boxes, something will no
doubt have to be run on the windows machines. Why not have the power
of SQL if you want it? A SQL script could be used to export the data
as flat ascii delimited text, or even XML. So EVERYONE could have what
they want.

Perhaps I am biased as I think SQL rocks, but I see it as the generic
solution that provides the most power and flexibility. Want to know
where a block is used then run a simple query, rather than 1) export
to XML, 2) write a parser, 3) read in the exported file, 4) scan the
XML for your answer (which is not trivial). All that could be done in
one step.

But as I have said before, a SQL solution will provide all the other
formats too. Why limit it to one of the others?
 
 
_______________________________________________________________________
This mailing list is neither sponsored nor endorsed by Invensys Process
Systems (formerly The Foxboro Company). Use the info you obtain here at
your own risks. Read http://www.thecassandraproject.org/disclaimer.html
 
foxboro mailing list:             http://www.freelists.org/list/foxboro
to subscribe:         mailto:foxboro-request@xxxxxxxxxxxxx?subject=join
to unsubscribe:      mailto:foxboro-request@xxxxxxxxxxxxx?subject=leave

Other related posts: