If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > Informix > SMART files Migration

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 03-08-03, 06:50
Ursula Ursula is offline
Registered User
 
Join Date: Mar 2003
Posts: 6
Question SMART files Migration

I'm searching for a way to migration old DOS based SMART files (databases) to a modern RDBMS system. Is there a way ????
Reply With Quote
  #2 (permalink)  
Old 03-11-03, 07:34
Roelwe Roelwe is offline
Registered User
 
Join Date: Aug 2002
Location: Belgium
Posts: 534
If SMART is a database, I assume you can execute SQL statements?
Isn't there an unload feature included to unloçad table in comma delimited files?
Is ther a possibility to print to files?
Once you have comma-delimited files, the job is easy...
__________________
rws
Reply With Quote
  #3 (permalink)  
Old 03-11-03, 10:09
Ursula Ursula is offline
Registered User
 
Join Date: Mar 2003
Posts: 6
Quote:
Originally posted by Roelwe
If SMART is a database, I assume you can execute SQL statements?
Isn't there an unload feature included to unloçad table in comma delimited files?
Is ther a possibility to print to files?
Once you have comma-delimited files, the job is easy...
Thanks for the reply....
I´m looking for a way to migrate the stuff into a later version of the SMART files (which are just flat files, managed by a data management on DOS) or a Database and not have to re-program the user interface and the like....
Reply With Quote
  #4 (permalink)  
Old 03-11-03, 10:17
Roelwe Roelwe is offline
Registered User
 
Join Date: Aug 2002
Location: Belgium
Posts: 534
If you have flat files I can show you how to migrate them to an informix RDBMS. Lots of tools are available to do so, but something tells me that's not what you're interested in...
__________________
rws
Reply With Quote
  #5 (permalink)  
Old 03-13-03, 03:23
Ursula Ursula is offline
Registered User
 
Join Date: Mar 2003
Posts: 6
Correct...
The database comes with lots of user interfaces (forms) being generated from the flat files.
I do not want to program a new application offering these oportunities. But they are needed and the PC the SMART system runs on now, will probably soon fade. Additionally the files still reside on DOS so they cannot really be transfered anywhere else, printers able to work with them get rarer and so on. I should really need a migration thing for them. It should be something like a later version of these file system stuff, to which all data and most of the functions can be transferred.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On