Anyone have documentation for ora2pg configuration from windows server?

Question

PostgreSQL (English)

N@R£N

Anyone have documentation for ora2pg configuration from windows server?

#programming #russian

0

23.10.2023

7 ответов

33 просмотра

N@R£N Автор вопроса

DB
Their official website mostly covers and provides ...

I have searched that most of it available for linux server not for windows one...

0

23.10.2023

Kirk

Noren, we setup a VM in VirtualBox to run it in Linux against a Windows Oracle machine. We did play around with getting it to run on Windows. We mounted a windows drive, and copied the files to the windows box to work with. HTH. I did find a Microsoft hosted document with a powershell script. But it could be using WSL... https://github.com/microsoft/DataMigrationTeam/blob/master/Whitepapers/Steps%20to%20Install%20ora2pg%20on%20Windows%20and%20Linux.pdf

0

23.10.2023

DB

N@R£N
I have searched that most of it available for linu...

Pearl is something you would require

0

23.10.2023

DB

N@R£N
I have searched that most of it available for linu...

1. Install Perl: ora2pg is a Perl script, so you'll need Perl on your Windows machine. You can download and install ActivePerl or Strawberry Perl. 2. Install Oracle Client: You need Oracle client software installed on your Windows machine. Make sure it's properly configured to connect to your Oracle database. 3. Install Dependencies: Some Perl modules are required by ora2pg. You can install these modules using the Perl package manager, CPAN, by running cpan Module::Name. 4. Download ora2pg: Download the latest ora2pg release from the [ora2pg GitHub releases](https://github.com/darold/ora2pg/releases) page. 5. Configuration: Create a configuration file for ora2pg. This file will contain information about your Oracle database and how you want to migrate the data. You can use a text editor to create this file. 6. Run ora2pg: Open a command prompt, navigate to the directory where you placed ora2pg, and run it with your configuration file, like so: perl ora2pg -t SHOW_VERSION -c your_config_file 7. Review Output: ora2pg will generate SQL files with the schema and data that you can then use to migrate your Oracle database to PostgreSQL. Please note that running ora2pg on Windows may have some limitations and quirks compared to running it on Unix-based systems. Make sure to consult the ora2pg documentation and consider any specific configuration or compatibility issues that may arise in a Windows environment.

0

23.10.2023

N@R£N Автор вопроса

DB
1. Install Perl: ora2pg is a Perl script, so you'l...

I have installed all perl module that you mentioned, facing some error while try to produce SQL file

0

23.10.2023

Stefanie Janine Stölting

N@R£N
I have installed all perl module that you mentione...

"Some error" is near to something happened, but I won't tell you.

0

23.10.2023