Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!news.linkpendium.com!news-out.visi.com!petbe.visi.com!feed2.newsreader.com!newsreader.com!newshosting.com!nx02.iad01.newshosting.com!216.166.71.118.MISMATCH!small1.nntp.aus1.giganews.com!border1.nntp.aus1.giganews.com!intern1.nntp.aus1.giganews.com!nntp.giganews.com!nntp.comcast.com!news.comcast.com.POSTED!not-for-mail NNTP-Posting-Date: Thu, 01 Jan 2004 10:52:49 -0600 Reply-To: "Mark C. Stock" From: "Mark C. Stock" Newsgroups: comp.databases.oracle.tools References: <2c2cd9b8.0401010104.1857dc7f@posting.google.com> Subject: Re: Import/Export Wizard for Oracle 9i, Need Help!!! Date: Thu, 1 Jan 2004 11:51:24 -0500 Organization: Enquery, Incorporated X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2800.1158 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 Message-ID: Lines: 65 NNTP-Posting-Host: 68.57.99.86 X-Trace: sv3-2kiVLlBNR04I8vibQAGhuhVUo+5CGSdqEbdPxsiy2a084WRW2TXm1anEQ86QdKNw+EspJe/fZndYX7z!fuWQ3+zEdffpckva3+RSEWZRkSPokJs0HcFtHYI2OG1ELblbwLymOYAwgDY= X-Complaints-To: abuse@comcast.net X-DMCA-Complaints-To: dmca@comcast.net X-Abuse-and-DMCA-Info: Please be sure to forward a copy of ALL headers X-Abuse-and-DMCA-Info: Otherwise we will be unable to process your complaint properly X-Postfilter: 1.1 Xref: newssvr20.news.prodigy.com comp.databases.oracle.tools:84129 Virat, Thanks for being up front and honest about your situation. Unfortunately, it appears that MCA has not equipped you with the necessary skills for the assignment. You will need good analysis and design skills to further identify your problem, possible solutions, and the overall functionality that your solution should include. You will also need a good understanding of the data access methods for all tools and databases involved. The scope of your request (and the scope of your responsibility) is far beyond the type of help for which this forum is intended, although you may get some pointers on what to research. For starters, may I suggest that you create a Functional Breakdown of the requirements as you understand them? Use a design tool, or just a simple outline tool (even the outline mode in MS-Word) to organize the requirements in an outline form in increasing levels of detail, until you get all branches of the outline down to a level of detail that corresponds with something you can implement in a software module. -- mcs "Virat" wrote in message news:2c2cd9b8.0401010104.1857dc7f@posting.google.com... | Hey All, | First, my introduction, I am Virat, a student of MCA (Master of | Computer Applications) I am in my final semester doing a project with | a company in Chennai, India.I have done a few programs in VB-Oracle 9i | for my academic labs. And understand basic queries and Oracle command. | | Now, the question that I have is that I have to do this project for | the company where I am doing my Internship. The problem statment is as | follows: | | I am supposed to develop a tool like DTS (Data Transfer Service) | Wizard available in SQL Server 7.0. In which I have to transfer data | from: | 1. SQL Server 7.0 | 2. Microsoft Access | 3. Microsoft Excel | 4. Flat Files (CSV - Comma Seperated Values and Fixed Length) | to Oracle 9i and back to respective sources. | | Also, I have to take care of the following Performance Parameters: | 1. Data Integrity during transfer. | 2. Speed of transfer. | 3. Any Issues faced while doing this project. | 4. Multiplexed (Forward and Backward Data Movement, ie. import/export | between above mentioned softwares.) | | Now, my problem is I am new to databases and do not know how to go | about this problem. I do not know how to start working on this | project. Also, I have to do this project in VB.NET. | Can anyone please help me in this regard? | | Thanks, | | Regards, | Virat