Article

How to buffer-copy Progress database table to dataserver foreign database table.

« Go Back

Information

 
EnvironmentProduct: OpenEdge
Version: 10.x, 11.x
OS: All supported platforms
Other: Dataserver
Question/Problem Description
When using the process for migrating Progress to MS-SQL, if the process is stopped due to a network error in the MS-SQL load steps, what are the steps to re-start it and only load the tables into MS-SQL that have not been loaded by the conversion process.
When using the process for migrating Progress to Oracle, if the process is stopped due to a network error in the Oracle load steps, what are the steps to re-start it and only load the tables into Oracle that have not been loaded by the conversion process.

 
Steps to Reproduce
Clarifying Information
Error Message
Defect/Enhancement Number
Cause
Resolution
There are no options to modifying the Data Dictionary / Data Administration tool to specify individual tables to copy.

It will be necessary to drop the delete the contents of the table in the foreign database then push the data to the table.

Example of code to copy all records from a Progress / OpenEdge database to a foreign database table via DataServer.

Define BUFFER <tablename01> for <tablename>.

for each <tablename01>  no-lock.
    buffer-copy <tablename01> to <logical db name of foreign database>.<tablename>.
end.

In the above code it will be necessary to define a different name for the buffer and to modify the buffer name and table names throughout the sample code.

Depending on the version of OpenEdge, there may be issues if one of the fields of the Progress / OpenEdge table is a BLOB/CLOB.
If a BLOB / CLOB field exists in the table the following two options are possible to migrate all but the BLOB/CLOB data.

Exclude the key fields from BUFFER-COPY.
Example:
buffer-copy <tablename01> except <lobfieldname>  to <logical db name of foreign database>.<tablename>.
 
Exclude the LOB columns from the BUFFER-COPY using NO-LOBS option. Copy the LOB columns after changing the key field(s).
Example:
buffer-copy <tablename01> to <logical db name of foreign database>.<tablename> NO-LOBS/

 

Workaround
Notes
Attachment 
Last Modified Date5/19/2017 6:49 PM
Disclaimer

The origins of the information on this site may be internal or external to Progress Software Corporation (“Progress”). Progress Software Corporation makes all reasonable efforts to verify this information. However, the information provided is for your information only. Progress Software Corporation makes no explicit or implied claims to the validity of this information.

Any sample code provided on this site is not supported under any Progress support program or service. The sample code is provided on an "AS IS" basis. Progress makes no warranties, express or implied, and disclaims all implied warranties including, without limitation, the implied warranties of merchantability or of fitness for a particular purpose. The entire risk arising out of the use or performance of the sample code is borne by the user. In no event shall Progress, its employees, or anyone else involved in the creation, production, or delivery of the code be liable for any damages whatsoever (including, without limitation, damages for loss of business profits, business interruption, loss of business information, or other pecuniary loss) arising out of the use of or inability to use the sample code, even if Progress has been advised of the possibility of such damages.



Feedback
 
Was this article helpful?

   

Your feedback is appreciated.

Please tell us how we can make this article more useful.



Characters Remaining: 255