I have a project, this guy has a customized system which was put into place in 1987. now we need to upgrade it to an online Database, The problem is that i dont kow what steps should be taken to do this. if anyone has the magic wond that would export from Superdos directly to MySql then i think the problem is 50% solved the rest is just doing it right. otherwise we will have to enter like a million enrties manually.
If any one has dealt with some thing like this please guide me
Sincerely
Zahaib
6 1260 sashi 1,754
Recognized Expert Top Contributor
I have a project, this guy has a customized system which was put into place in 1987. now we need to upgrade it to an online Database, The problem is that i dont kow what steps should be taken to do this. if anyone has the magic wond that would export from Superdos directly to MySql then i think the problem is 50% solved the rest is just doing it right. otherwise we will have to enter like a million enrties manually.
If any one has dealt with some thing like this please guide me
Sincerely
Zahaib
Hi there,
Am not sure what is SuperDos, anyway, how are the records currently saved? I meant to ask about the format? Please check out. Good luck & Take care.
Hi there,
Am not sure what is SuperDos, anyway, how are the records currently saved? I meant to ask about the format? Please check out. Good luck & Take care.
not sure yet but i am working on it, i am hoping to find out soon
sashi 1,754
Recognized Expert Top Contributor
not sure yet but i am working on it, i am hoping to find out soon
Hi there,
Great, keep working. Good luck & Take care.
SuperDos did not have relational data, let alone databases. Application in that time were merely collections of flat file records posing as 'relational' objects. Believe me: they were not.
So you'll have to find out how the data was stored in each flat record and then insert it into MySQL.
You also have to find out the queries that were used on that data and see if there is an equivalent SQL command for that.
Maybe it will be a lot easier just to re-evaluate the whole data design and then re-design the data handling part of the application.
Anyway, good luck with that!
Ronald :cool:
Thanks alot for the reply, I havent had much luck as of yet. I am also thinking of doing the whole thing again the only thing is its alot of work.
I don't think you have to manually enter the lot. You should be able to do a select or show or something alike on each table. That must give you the column names and their values. Export that to a flat file, and you can use CSV routines to convert the data into MySQL tables.
Ronald :cool:
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Dave Ekhaus |
last post by:
hi
my news carrier didn't have any mysql specific news groups - so
apologize in advance if this isn't exactly the proper group for these
question(s) ...
anyway - i'm trying to figure out how...
|
by: amg |
last post by:
--------------2ABCD8BC51CA575D47B206C8
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
--------------2ABCD8BC51CA575D47B206C8
Content-Type: text/plain;...
|
by: Morten Gulbrandsen |
last post by:
Hello,
starting from some software database spesification,
defined in some Enhanced entity relationship diagram,
resulting in all kinds of
relationships,
1:1
1:Many
Many:1
|
by: Khue Pham |
last post by:
Does anyone knows how to copy database from one server to another. By
copying I mean literally everything, not just the database. I know we
can dump the database from one server then reload it to...
|
by: DD |
last post by:
I have a mainform with a subform.
The main form as a dropdown box "chooseDate", in the afterupdate event
i requery the subform so all records with the same date are viewed.
Now i only want to...
|
by: Good Man |
last post by:
Hi there
I've noticed some very weird things happening with my current MySQL setup
on my XP Laptop, a development machine.
For a while, I have been trying to get the MySQL cache to work....
|
by: Cheryl Langdon |
last post by:
Hello everyone,
This is my first attempt at getting help in this manner. Please
forgive me if this is an inappropriate request.
I suddenly find myself in urgent need of instruction on how to...
|
by: Mike Husler |
last post by:
I have been tasked with copying data from our SQL Server to a local
MySQL (windows).
About 75 tables are involved. The data arrive in SQL Server at
irregular cadences.
Some every 1/2 second,...
|
by: Randy |
last post by:
Folks:
We have a web-based app that's _really_ slowing down because multiple
clients are writing their own private data into a single, central
database. I guess the previous programmer did...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
| |