search

cockroachdb / docs

CockroachDB user documentation
https://cockroachlabs.com/docs
Creative Commons Attribution 4.0 International
187 stars 453 forks source link

steps migrate data from oracle to cockroachdb - #14921

Open odessit55 opened 2 years ago

odessit55 commented 2 years ago

Alexander Rivilis (odessit55) commented:

We were following the steps migrate data from oracle to cockroachdb by following this step : https://www.cockroachlabs.com/docs/v22.1/migrate-from-oracle.html

In which step4 we have to run an python script to convert the oracle data into csv format , on executing the code we had error

AttributeError: module 'string' has no attribute 'strip'

Code in Python -- writer.writerow(map(string.strip, rec))

Attribute strip is available in python2 and not in python3 .

However the document points to use python3.

Jira Issue: DOC-5461

exalate-issue-sync[bot] commented 2 years ago

Andrew Feierabend (andf-crl) commented: Original py script added for v19.1: https://github.com/cockroachdb/docs/commit/5b619ab518338aacccb03d0f3b0c07b9020bb53d

Spoke with Andrew Deally , original engineer for above PR, who advised that CRDB should update this script for py3.

Created https://github.com/cockroachdb/cockroach/issues/86785 on his advisement.

exalate-issue-sync[bot] commented 7 months ago

Abbey Russell (amruss) commented: Update to say python 2 instead of 3: https://www.cockroachlabs.com/docs/v22.1/migrate-from-oracle#step-4-configure-and-convert-the-table-data-to-csv