Re: Migrating Oracle9i to ____ ? for standalone usage.
sriharirao Bh <[email protected]> Mon, 18 Mar 2002 09:16:40 -0800 (PST)
| Newsgroups | gmane.comp.java.ejb.general |
|---|---|
| Message-ID | <[email protected]> |
Hi, What i understand from ur requirement is " U want to run ur Ejb/java from weblogic6.1 to any lighter DB on standalone/laptop M/c ,instead of heavy Oracle9i" if this is the case, Then Go for Sqlserver7.0 and use IMPORT/EXPORT WIZARD and slightly change datatypes if required and use weblogic jdbc driver for Sqlserver7.0(default one supplied with weblogic or down load).This may work with minimal changes. Sriharirao --- MATHUR Mushtaq <[email protected]> wrote: > Hello Friends, > > I have a concern here, I have an EJB/Java web > application running on > Weblogic9.1, uses Oracle9i, I need a replica of the > same for a stand alone > system laptop/desktop, I need to lighter the > application so as to suit in a > single machine with a minimal licensing etc, I have > decided to go for MyQql > DB but I need to change entire SQL queries to > generate the same DB in MyQql, > to over come this I have come across 'Oracle9i Lite' > but this seems not an > alternate solution for RDBMS. > > Can any one suggest me what could be the lighter > RDBMS for a single user > usage for a stand alone system which must have > minimal impact on migrating > from Oracle9i to _____ . DB, Is that any one have > phased such scenario? > > I have 'Oracle9i Lite' Downloaded in my system, and > I have the following > issue, the installation procedures, and system > requirement specification > describes the following Oracle Components as > pre-requisites. > > However this may not be advisable for standalone > application. I ll have to > look for something simpler, as this product from > Oracle is dedicated only > for Mobile, PDA devices as an addition to Oracle9i > AS, and not just a > complete RDBMS package as Oralce9i itself as what we > have assumed so far. > > This is just for your information. > > Required Oracle Components > * Oracle9i Application Server (Oracle9i AS) 1.0.2 or > Apache 1.3.14 for > Windows NT/Windows 2000 > * * Oracle 8.1.7 or higher, Standard Edition or > Enterprise > Edition > * > Please write back as you feel better your > comments/suggestions will always > be highly appreciated. > > Thanks in Advance, > Mushtaq A.Mathur > > __________________________________________________ Do You Yahoo!? Yahoo! Sports - live college hoops coverage http://sports.yahoo.com/ ------------------------ Yahoo! Groups Sponsor ---------------------~--> Tiny Wireless Camera under $80! Order Now! FREE VCR Commander! Click Here - Only 1 Day Left! http://us.click.yahoo.com/nuyOHD/7.PDAA/yigFAA/5cFolB/TM ---------------------------------------------------------------------~-> EJB-Developer group email addresses: Post message: [email protected] Subscribe: [email protected] Unsubscribe: [email protected] List owner: [email protected] Our other technical discussion groups: - For general Java (J2EE) questions/answers: http://groups.yahoo.com/group/Java_Developer - For peer-to-peer software development discussion: http://groups.yahoo.com/group/P2P-Developer Web link to the EJB-Developer group: http://groups.yahoo.com/group/EJB-Developer ATTENTION: You are receiving this message because you actively subscribed to the EJB-Developer technical discussion group on Yahoo! Groups. All subscriptions come from Yahoo-verified email addresses and are logged; therefore subscriptions can be proved to any appropriate legal authority. To unsubscribe, send a blank email from the email address receiving group messages to the "Unsubscribe" email address shown above. If unsubscribing doesn't work, send a message concerning this problem to [email protected]. Only Yahoo! Groups is responsible for their own subscription services; the moderator will not perform these services at any time. *** EJB-Developer - A free service brought to you by Democracy 2.0 (www.democracy2.org) *** Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/