From SuperDos to MySql can some one help me | Newbie | | Join Date: Nov 2006
Posts: 3
| | |
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
|  | Expert | | Join Date: Jun 2006 Location: Seremban, Malaysia
Posts: 1,630
| | | re: From SuperDos to MySql can some one help me
Quote:
Originally Posted by Zahaib 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.
| | Newbie | | Join Date: Nov 2006
Posts: 3
| | | re: From SuperDos to MySql can some one help me
Quote:
Originally Posted by sashi 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
| | Expert | | Join Date: Jun 2006 Location: Seremban, Malaysia
Posts: 1,630
| | | re: From SuperDos to MySql can some one help me
Quote:
Originally Posted by Zahaib 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.
|  | Moderator | | Join Date: Jul 2006 Location: The Netherlands
Posts: 4,139
| | | re: From SuperDos to MySql can some one help me
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:
| | Newbie | | Join Date: Nov 2006
Posts: 3
| | | re: From SuperDos to MySql can some one help me
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.
| | Moderator | | Join Date: Jul 2006 Location: The Netherlands
Posts: 4,139
| | | re: From SuperDos to MySql can some one help me
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:
|  |
Similar MySQL Database bytes | | |  /bytes/about
We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights.
Get the best answers to your questions from over 226,223 network members.
|
