Converting various databases to Oracle 7.3

Question:
I have a number of databases – filemaker, DBase, ASCII and CAD drawings. We want to convert everything to one database. Is this possible? What are some initial steps to take to get on the path of converting everything over.

Answer:
Well, it’s certainly time to settle on one database!

OPO Version 2 includes ODBC access to a fairly wide variety of databases,which includes ASCII and DBase files. Once you define these files as anODBC data source, you can access them through an OPO session, just as youwould an Oracle database. After you have defined a session to access thedata, you can move the tables and their data to any other session by simplydragging and dropping the tables.

You could, concievably, use the Migration Expert that comes with OPO forthe same purpose once you have created an ODBC data source for the files.For the FileMaker files, you have a couple of choices. You could see ifthere is an ODBC driver available for FileMaker files and use the samemethods described above. This should work, although there may be someproblems, especially with data conversion, for an untested ODBC driver inOPO. You could also dump the files to an ASCII or CSV format and importthe data. I describe how to do this in detail in my book MasteringOracle Power Objects, available from O’Reilly and Associates.

Finally, for the CAD drawings, I would use some care here. You could storethem in a LONG-type of column in an Oracle database, but you may still havea problem displaying them outside of the CAD product, since most CADproducts use a proprietary format. If you do want to keep the data in anoracle database, consult the Oracle manuals as to the best way to get thesefiles into an Oracle database.

Share the Post:
Share on facebook
Share on twitter
Share on linkedin

Overview

The Latest

microsoft careers

Top Careers at Microsoft

Microsoft has gained its position as one of the top companies in the world, and Microsoft careers are flourishing. This multinational company is efficiently developing popular software and computers with other consumer electronics. It is a dream come true for so many people to acquire a high paid, high-prestige job

your company's audio

4 Areas of Your Company Where Your Audio Really Matters

Your company probably relies on audio more than you realize. Whether you’re creating a spoken text message to a colleague or giving a speech, you want your audio to shine. Otherwise, you could cause avoidable friction points and potentially hurt your brand reputation. For example, let’s say you create a

chrome os developer mode

How to Turn on Chrome OS Developer Mode

Google’s Chrome OS is a popular operating system that is widely used on Chromebooks and other devices. While it is designed to be simple and user-friendly, there are times when users may want to access additional features and functionality. One way to do this is by turning on Chrome OS