William Hicks
New Member
I need to export data from tables in a Progress database that contain array columns so that it can be imported into MS SQL Server for analysis. The database in question doesn't have username/password so I can't use ODBC, as works for other databases.
I have generated scripts to create the tables in SQL Server from which include the array columns expanded out so an array of 100 would create 100 columns named col##1 to col##100.
However, when I export the data from Data Administration->Admin->Export Data->Text... the array columns are not included when choosing All fields form the radio button nor are they offered when choosing Selected.
How can I export the table data including the array columns?
Progress is v10.2. Dev environment is on Windows 10 Enterprise. Database is on Linux.
I have generated scripts to create the tables in SQL Server from which include the array columns expanded out so an array of 100 would create 100 columns named col##1 to col##100.
However, when I export the data from Data Administration->Admin->Export Data->Text... the array columns are not included when choosing All fields form the radio button nor are they offered when choosing Selected.
How can I export the table data including the array columns?
Progress is v10.2. Dev environment is on Windows 10 Enterprise. Database is on Linux.