Moving from RMS files to a relational database-

[Peter Bateman]

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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.sowder.com/pipermail/powerh-l/attachments/20081205/f6abc51a/attachment.htm