Unanswered: Extract IBM UniData (Pick database) data into SQL Server
Good afternoon SQL dudes
Does anyone have any experience of extracting data from IBM's UniData (or any post-relational\ Pick\ nested relational\ multi-valued relational database) into a SQL Server?
More info here, here and here
I don't (which is why I am asking) but I could imagine it being a right bugger. No need for detailed or technical info - I have no more info at this stage - just wondered if anyone has any similar experience.
Probably gonna show my age now :/ its been a while since i have done anything in Pick (over 10 years)
If tools dont already exist to do the export the easies way would be to write a small program in PickBasic that just displayed the data to screen, and a small app that runs on the PC that initates the Pick Program, and then just captures to output to a file (from what i remember alot of pc based terminal emulation programs already do that)
Just remember to calculate a checksum for the data, then re-calculate it from the captured files.
If its UniData then there are ODBC drivers available that will let you connect to the data directly.
Sorry cant be more helpfull, its been a while since i have used that technology, although i must admit, i loved working in that environment xD