Converting various databases to Oracle 7.3

Converting various databases to Oracle 7.3

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.

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:
Heading photo, Metadata.

What is Metadata?

What is metadata? Well, It’s an odd concept to wrap your head around. Metadata is essentially the secondary layer of data that tracks details about the “regular” data. The regular

XDR solutions

The Benefits of Using XDR Solutions

Cybercriminals constantly adapt their strategies, developing newer, more powerful, and intelligent ways to attack your network. Since security professionals must innovate as well, more conventional endpoint detection solutions have evolved

AI is revolutionizing fraud detection

How AI is Revolutionizing Fraud Detection

Artificial intelligence – commonly known as AI – means a form of technology with multiple uses. As a result, it has become extremely valuable to a number of businesses across

AI innovation

Companies Leading AI Innovation in 2023

Artificial intelligence (AI) has been transforming industries and revolutionizing business operations. AI’s potential to enhance efficiency and productivity has become crucial to many businesses. As we move into 2023, several

data fivetran pricing

Fivetran Pricing Explained

One of the biggest trends of the 21st century is the massive surge in analytics. Analytics is the process of utilizing data to drive future decision-making. With so much of

kubernetes logging

Kubernetes Logging: What You Need to Know

Kubernetes from Google is one of the most popular open-source and free container management solutions made to make managing and deploying applications easier. It has a solid architecture that makes