Re: Installing Postegres side-by-side with M$ SQL server]]

From: Paul Lambert <paul(dot)lambert(at)autoledgers(dot)com(dot)au>
To: Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Installing Postegres side-by-side with M$ SQL server]]
Date: 2007-01-22 23:51:44
Message-ID: 45B54E10.6000201@autoledgers.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Ron Johnson wrote:
<blockquote cite="mid45B52170(dot)90109(at)cox(dot)net" type="cite">
<pre wrap="">-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 01/22/07 14:01, Paul Lambert wrote:
</pre>
<blockquote type="cite">
<pre wrap="">Ron Johnson wrote: On 01/22/07 07:09, Paul Lambert wrote:

</pre>
<blockquote type="cite">
<blockquote type="cite">
<blockquote type="cite">
<pre wrap="">Alban Hertroys wrote:

</pre>
<blockquote type="cite">
<pre wrap="">Paul Lambert wrote:

</pre>
</blockquote>
</blockquote>
</blockquote>
</blockquote>
<pre wrap="">[snip]

</pre>
</blockquote>
<pre wrap=""><!---->[snip]

</pre>
<blockquote type="cite">
<pre wrap="">We've got pretty new hardware - DS15's, DS25's, Itaniums and so
forth. But we don't run any DB app on it, most of our data sits
in RMS files or flat binary files - even text files in a few
instances, thus making standard DB queries nigh on impossible
with the exception of a report generator we've built into the
app, but that has nowhere near the capabilities of something like
crystal reports or M$ Access, thus the need for a 'replica'
standard db model. We looked at Mimer on VMS for a while but
</pre>
</blockquote>
<pre wrap=""><!---->
CONNX &amp; Easysoft appear to offer ODBC drivers for (probably only
indexed) RMS files, if that helps you.

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFFtSFwS9HxQb37XmcRArreAJ0Y7hxAGemjhMnukvyHGLWDwWy1/QCdHx4t
jJoVFkzeucdDivL9QEJXm5k=
=uxvA
-----END PGP SIGNATURE-----

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to <a class="moz-txt-link-abbreviated" href="mailto:majordomo(at)postgresql(dot)org">majordomo(at)postgresql(dot)org</a> so that your
message can get through to the mailing list cleanly

</pre>
</blockquote>
Probably wouldn't - as I said we use a mix of binary, rms (some
indexed, some not) and text files - so an<br>
odbc driver into RMS files would only give us a portion of the
database. A lot of what I replicate to SQL<br>
server at the moment comes from flat binary files and a couple of the
tables from text files, the rest from<br>
RMS files. Having this mix of types would mean we need to manage things
ourselves, thus having our main<br>
in-house faux-database engine forward messages directly to the Weendoze
box which then uses ODBC to<br>
pump the data into the database of my choice. It would make things a
lot easier to manage if I could forward<br>
it to an ODBC database on the VMS machine - oracle is just way out of
our reach though.<br>
<br>
Thanks for the suggestion though, that may come in handy down the track
for another project I'm looking at.<br>
<br>
P.<br>
<pre class="moz-signature" cols="72">--
Paul Lambert
Database Administrator
AutoLedgers
Level 3, 823 Wellington Street, West Perth, W.A. 6005
Postal: P.O. Box 106, West Perth, W.A. 6872
Ph: 08 9217 5086 Fax: 08 9217 5055
AutoLedgers&nbsp;Technical Support Desk: 1800 649 987 (Free call) 08 9217 5050 (Perth local and mobile)
Email: <a class="moz-txt-link-abbreviated" href="mailto:paul(dot)lambert(at)autoledgers(dot)com(dot)au">paul(dot)lambert(at)autoledgers(dot)com(dot)au</a> <a class="moz-txt-link-rfc2396E" href="http://www.reynolds.com.au">&lt;http://www.reynolds.com.au&gt;</a>
------------------------------------------------------------------------------------
For AutoLedgers technical support, please send an email to <a class="moz-txt-link-abbreviated" href="mailto:helpdesk(at)autoledgers(dot)com(dot)au">helpdesk(at)autoledgers(dot)com(dot)au</a>.

</pre>
</body>
</html>

Attachment Content-Type Size
unknown_filename text/html 3.8 KB

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Adam Gordon 2007-01-23 00:32:23 New US DST Rules & PostgreSQL
Previous Message Steve Atkins 2007-01-22 23:39:10 Re: [HACKERS] Autovacuum Improvements