<html>
<head>
<style>
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Verdana
}
</style>
</head>
<body class='hmmessage'>
Hi Desmond:<BR>
<BR>
There are a lot of factors to consider when making an investment in a relational database.<BR>
DB2, Oracle and MS SQL Server are in my opinion the 3 most popular.<BR>
<BR>
1) Cost of ownership. Including new hardware, software and on site expertise. <BR>
<BR>
2) How much growth is expected in users and data volume. The volumes indicated in your<BR>
e-mail are not high and I would suspect any of the three databases merntion above would not have <BR>
a problem nor would Oracle/RDB. Before you buy make sure your database can handle over 2gb tables.<BR>
<BR>
3) What do the users want that they are not getting now?<BR>
e.g. fulltext searches on character data.<BR>
<BR>
4) Are you also planning to give the users reporting tools such as ReportNet or Crystal Reports , etc.?<BR>
If so you may need more capacity as some queries can consume<BR>
a lot of database server resources.<BR>
<BR>
5) Are you thinking of going to Itanium? If so you will have to upgrade both your version of <BR>
OpenVMS and PowerHouse.<BR>
<BR>
<BR>
<BR>
Regards,<BR>
Peter Bateman<BR><BR>> To: ddujon@yahoo.com<BR>> Subject: Re: Moving from RMS files to a relational database-<BR>> From: Bob.Deskin@ca.ibm.com<BR>> Date: Thu, 4 Dec 2008 09:02:22 -0500<BR>> CC: powerh-l-bounces+bob.deskin=ca.ibm.com@lists.sowder.com; powerh-l@lists.sowder.com<BR>> <BR>> Are you planning on upgrading your PowerHouse version? 7.10 supported RDB <BR>> (and Interbase, which is gone). Currently on OpenVMS, PowerHouse supports <BR>> Oracle and Oracle RDB. <BR>> <BR>> There's some discussion on migrating from indexed (RMS) to relational in <BR>> the PowerHouse for OpenVMS migration guide. While the guide is generally <BR>> aimed at migrating PowerHouse from OpenVMS to UNIX, Linux, or Windows, the <BR>> section on moving to relational applies generally. It's available for <BR>> download from http://powerhouse.cognos.com. Near the bottom of the main <BR>> section there's a heading titled "Migration Considerations". Click the <BR>> OpenVMS link.<BR>> <BR>> Bob <BR>> <BR>> <BR>> <BR>> From:<BR>> Desmond Dujon <ddujon@yahoo.com><BR>> To:<BR>> powerh-l@lists.sowder.com<BR>> Date:<BR>> 2008-12-03 05:57 pm<BR>> Subject:<BR>> Moving from RMS files to a relational database-<BR>> <BR>> <BR>> <BR>> Hi folks.<BR>> <BR>> I am using rms files on openvms 7.3 We have one main server , an HP ES47 <BR>> with 2 gb of ram, which also runs POWERHOUSE 7.10.g3. We have about 20 GB <BR>> of data in 400 files on this server.Largest file may be 2gb . Which <BR>> database is easiest to migrate to? Should everything be kept on the VMS <BR>> server or should the database be held on a different server. Suggestions <BR>> are welcome.<BR>> <BR>> <BR>> <BR>> -- <BR>> = = = = = = = = = = = = = = = = = = = = = = = = = = = =<BR>> Mailing list: powerh-l@lists.sowder.com<BR>> Subscribe: 'subscribe' in message body to <BR>> powerh-l-request@lists.sowder.com<BR>> Unsubscribe: 'unsubscribe &lt;password&gt;' in message body to <BR>> powerh-l-request@lists.sowder.com<BR>> http://lists.sowder.com/mailman/listinfo/powerh-l<BR>> This list is closed, thus to post to the list you must be a subscriber.<BR>> Add 'site:lists.sowder.com powerh-l' to your search terms to search the <BR>> list archive at Google.<BR>> <BR>> <BR>> <BR>> -- <BR>> = = = = = = = = = = = = = = = = = = = = = = = = = = = =<BR>> Mailing list: powerh-l@lists.sowder.com<BR>> Subscribe: 'subscribe' in message body to powerh-l-request@lists.sowder.com<BR>> Unsubscribe: 'unsubscribe &lt;password&gt;' in message body to powerh-l-request@lists.sowder.com<BR>> http://lists.sowder.com/mailman/listinfo/powerh-l<BR>> This list is closed, thus to post to the list you must be a subscriber.<BR>> Add 'site:lists.sowder.com powerh-l' to your search terms to search the list archive at Google.<BR><BR><br /><hr />Win a trip with your 3 best buddies. <a href='http://www.messengerbuddies.ca/?ocid=BUDDYOMATICENCA19' target='_new'>Enter today.</a></body>
</html>