Cody Morton
New Member
I'm the computer guy for a company that needs their Progress database to be exported and they are converting to another company (former was SX). In order to save money, they've asked me to try and export the data to tab-delimited files for the new company.
I've been using Hyperion to export data. It was working fine, until I come across tables with millions of rows and hundreds of columns.
So let's say I need to export this huge table. It has 200 columns so eventually I come down to about 20 parts.
To make these 20 parts, I add the first 20 tables to the query then export the results. For the 2nd part I add the 20 following parts and then export.
So.. it appears that I am doing it right. I would use scripts like I see everyone else doing but I have no idea what the user/pass is for admin account. The old company probably has it but I doubt they will give it to us.
My my issue here is: I have no idea if the "parts" i am making actually add up. Is the first row in Part 1 the same row in Part 13?
Please let me know if I am doing all of this right and if the data I'm exporting is correct. I'm completely new to all of this and trying not to make any mistakes.
Thank you so much! Also, if you need any more information please let me know.
I've been using Hyperion to export data. It was working fine, until I come across tables with millions of rows and hundreds of columns.
So let's say I need to export this huge table. It has 200 columns so eventually I come down to about 20 parts.
To make these 20 parts, I add the first 20 tables to the query then export the results. For the 2nd part I add the 20 following parts and then export.
So.. it appears that I am doing it right. I would use scripts like I see everyone else doing but I have no idea what the user/pass is for admin account. The old company probably has it but I doubt they will give it to us.
My my issue here is: I have no idea if the "parts" i am making actually add up. Is the first row in Part 1 the same row in Part 13?
Please let me know if I am doing all of this right and if the data I'm exporting is correct. I'm completely new to all of this and trying not to make any mistakes.
Thank you so much! Also, if you need any more information please let me know.