Delphi & MySQL: Database and subdatabase
Posted by:
Date: October 15, 2010 06:29AM
Hi,
i am new to MySQL. I used to write simple applications since delphi 5 along with BDE (Visual dBase) and few of them are still running. But now BDE is obsolete and has compatibility issues with newer versions of Windows. So, i wanted to switch to real DBMS and i decided to go with MySQL.
I wrote a simple application-driver to transfer my existing data to MySQL using ADO.
Everything ok here.
But, i have a question.
My existing database architecture uses a base directory with some tables (dbf files) which are common (lets say default values, cities, professions etc), and some other directories (lets say companies) with their individual files. what would be the best approach to this architecture? I mean is there anything like subdatabase? Or i have to create a schema for the base tables and all subdatabases will be separate schemas?
Thanks in advance.
Subject
Written By
Posted
Delphi & MySQL: Database and subdatabase
October 15, 2010 06:29AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.