[prev in list] [next in list] [prev in thread] [next in thread]
List: postgresql-announce
Subject: Ora2Pg 24.2 have been released
From: HexaCluster via PostgreSQL Announce <announce-noreply () postgresql ! org>
Date: 2024-03-08 20:49:25
Message-ID: 170993096541.640.5990421402781597583 () wrigleys ! postgresql ! org
[Download RAW message or body]
[Attachment #2 (multipart/alternative)]
Hyderabad, India - March 8th, 2024
## Ora2Pg
Version 24.2 of Ora2Pg, a free and reliable tool used to migrate an
Oracle database to PostgreSQL, has been officially released and is
publicly available for download.
This release fix several issues reported since last release and adds some
new features and improvements.
* Allow `DATA_EXPORT_ORDER` to take a filename at value to be able to give a custom \
table order. The file must contain the ordered list of the tables. One table per line \
in upper case for Oracle.
* Add progress bar when option `--oracle_speed` is used to avoid waiting for the \
whole data export ends.
* Add replacement of the `BITAND` function by the & operator.
* Add option -f, --format to set the output format for the reports. It can be html \
or json. Default to html.
* Add automatic addition of the partition key to the primary key. Prefix all \
columns with the alias in the query to get data from Oracle.
* Add information about MSSQL masked columns in report build by action \
`SHOW_COLUMN`.
* Add information about columnstore and compression on MSSQL tables with action \
`SHOW_TABLE`.
* Add new configuration directive `PARTITION_BY_REFERENCE` to defined how to export \
Oracle partition by reference. Possible values are `none`, `duplicate` or the number \
of hash partitions to create.
Value `none` mean no translation and export of partition by reference like \
before. Value `duplicate` will duplicate the referenced column in the partitioned \
table and apply the same partitioning from the referenced table to the partitioned \
table. If the value is a number, the table will be partitioned with the HASH method \
using the value as the modulo. For example if you set it to 4 it will create 4 HASH \
partitions. Default valuer is `none` to not export the partitions by reference \
definition.
For a complete list of change see \
[https://github.com/darold/ora2pg/blob/master/changelog](https://github.com/darold/ora2pg/blob/master/changelog)
Thanks to all contributors, they are all cited in the changelog file. With special \
thanks to Martin Gerhardy for all the recent pull requests, this is much appreciated \
to not feel alone in the Ora2Pg code development.
## Links & Credits
I would like to thank all users who submitted patches and users
who reported bugs and feature requests, they are all cited
the ChangeLog file.
Ora2Pg is an open project. Any contribution to build a better tool is
welcome. You just have to send your ideas, features requests or patches
using the GitHub tools or directly to ora2pg(at)darold(dot)net(dot)
**Links:**
- Website: [https://www.ora2pg.com/](https://www.ora2pg.com/)
- Download1: [https://github.com/darold/ora2pg/releases](https://github.com/darold/ora2pg/releases)
- Download2: [https://sourceforge.net/projects/ora2pg/](https://sourceforge.net/projects/ora2pg/)
- Development: [https://github.com/darold/ora2pg](https://github.com/darold/ora2pg)
- Changelog: [https://github.com/darold/ora2pg/blob/master/changelog](https://github.com/darold/ora2pg/blob/master/changelog)
- Documentation: [https://github.com/darold/ora2pg/blob/master/README](https://github.com/darold/ora2pg/blob/master/README)
##About Ora2Pg
Ora2Pg is an easy and reliable tool to migrate from Oracle to PostgreSQL.
It is developed since 2001 and can export most of the Oracle objects into
PostgreSQL compatible code.
Ora2Pg works on any platform and is available under the GPL v3 licence.
Docs, Download & Support at [http://www.ora2pg.com/](http://www.ora2pg.com/)
[Attachment #5 (text/html)]
<!doctype html>
<html>
<head>
<meta name="viewport" content="width=device-width">
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Ora2Pg 24.2 have been released</title>
<style>
@media only screen and (max-width: 620px) {
table[class=body] h1 {
font-size: 28px !important;
margin-bottom: 10px !important;
}
table[class=body] p,
table[class=body] ul,
table[class=body] ol,
table[class=body] td,
table[class=body] span,
table[class=body] a {
font-size: 16px !important;
}
table[class=body] .wrapper,
table[class=body] .article {
padding: 10px !important;
}
table[class=body] .content {
padding: 0 !important;
}
table[class=body] .container {
padding: 0 !important;
width: 100% !important;
}
table[class=body] .main {
border-left-width: 0 !important;
border-radius: 0 !important;
border-right-width: 0 !important;
}
table[class=body] .btn table {
width: 100% !important;
}
table[class=body] .btn a {
width: 100% !important;
}
table[class=body] .img-responsive {
height: auto !important;
max-width: 100% !important;
width: auto !important;
}
}
@media all {
.ExternalClass {
width: 100%;
}
.ExternalClass,
.ExternalClass p,
.ExternalClass span,
.ExternalClass font,
.ExternalClass td,
.ExternalClass div {
line-height: 100%;
}
.apple-link a {
color: inherit !important;
font-family: inherit !important;
font-size: inherit !important;
font-weight: inherit !important;
line-height: inherit !important;
text-decoration: none !important;
}
#MessageViewBody a {
color: inherit;
text-decoration: none;
font-size: inherit;
font-family: inherit;
font-weight: inherit;
line-height: inherit;
}
.btn-primary table td:hover {
background-color: #34495e !important;
}
.btn-primary a:hover {
background-color: #34495e !important;
border-color: #34495e !important;
}
}
</style>
</head>
<body class="" style="background-color: #f6f6f6; font-family: sans-serif; \
-webkit-font-smoothing: antialiased; font-size: 14px; line-height: 1.4; margin: 0; \
padding: 0; -ms-text-size-adjust: 100%; -webkit-text-size-adjust: 100%;"> <table \
border="0" cellpadding="0" cellspacing="0" class="body" style="border-collapse: \
separate; mso-table-lspace: 0pt; mso-table-rspace: 0pt; width: 100%; \
background-color: #f6f6f6;"> <tr>
<td style="font-family: sans-serif; font-size: 14px; vertical-align: \
top;"> </td> <td class="container" style="font-family: sans-serif; font-size: \
14px; vertical-align: top; display: block; Margin: 0 auto; max-width: 580px; padding: \
10px; width: 580px;">
<div class="content" style="box-sizing: border-box; display: block; Margin: \
0 auto; max-width: 580px; padding: 10px;">
<span class="preheader" style="color: transparent; display: none; height: \
0; max-height: 0; max-width: 0; opacity: 0; overflow: hidden; mso-hide: all; \
visibility: hidden; width: 0;"></span> <table class="main" style="border-collapse: \
separate; mso-table-lspace: 0pt; mso-table-rspace: 0pt; width: 100%; background: \
#ffffff; border-radius: 3px;">
<tr>
<td class="wrapper" style="font-family: sans-serif; font-size: 14px; \
vertical-align: top; box-sizing: border-box; padding: 20px;">
<table border="0" cellpadding="0" cellspacing="0" \
style="border-collapse: separate; mso-table-lspace: 0pt; mso-table-rspace: 0pt; \
width: 100%;"> <tr>
<td style="font-family: sans-serif; font-size: 14px; \
vertical-align: top;">
<div>
<h1 style="color: #000; font-family: sans-serif; line-height: 1.4; margin: 0; \
margin-bottom: 30px; font-size: 25px; font-weight: 300; text-align: center">Ora2Pg \
24.2 have been released</h1> </div>
<p style="font-family: sans-serif; font-size: 14px; font-weight: normal; margin: 0; \
margin-bottom: 15px">Hyderabad, India - March 8th, 2024</p> <h2 style="color: #000; \
font-family: sans-serif; font-weight: 400; line-height: 1.4; margin: 0; \
margin-bottom: 30px">Ora2Pg</h2> <p style="font-family: sans-serif; font-size: 14px; \
font-weight: normal; margin: 0; margin-bottom: 15px">Version 24.2 of Ora2Pg, a free \
and reliable tool used to migrate an Oracle database to PostgreSQL, has been \
officially released and is publicly available for download.</p>
<p style="font-family: sans-serif; font-size: 14px; font-weight: normal; margin: 0; \
margin-bottom: 15px">This release fix several issues reported since last release and \
adds some new features and improvements. </p>
<ul style="font-family: sans-serif; font-size: 14px; font-weight: normal; margin: 0; \
margin-bottom: 15px"> <li style="list-style-position: inside; margin-left: 5px">Allow \
<code>DATA_EXPORT_ORDER</code> to take a filename at value to be able to give a \
custom table order. The file must contain the ordered list of the tables. One table \
per line in upper case for Oracle.</li> <li style="list-style-position: inside; \
margin-left: 5px">Add progress bar when option <code>--oracle_speed</code> is used to \
avoid waiting for the whole data export ends.</li> <li style="list-style-position: \
inside; margin-left: 5px">Add replacement of the <code>BITAND</code> function by the \
& operator.</li> <li style="list-style-position: inside; margin-left: 5px">Add \
option -f, --format to set the output format for the reports. It can be html or json. \
Default to html.</li> <li style="list-style-position: inside; margin-left: 5px">Add \
automatic addition of the partition key to the primary key. Prefix all columns with \
the alias in the query to get data from Oracle.</li> <li style="list-style-position: \
inside; margin-left: 5px">Add information about MSSQL masked columns in report build \
by action <code>SHOW_COLUMN</code>.</li> <li style="list-style-position: inside; \
margin-left: 5px">Add information about columnstore and compression on MSSQL tables \
with action <code>SHOW_TABLE</code>.</li> <li style="list-style-position: inside; \
margin-left: 5px"> <p style="font-family: sans-serif; font-size: 14px; font-weight: \
normal; margin: 0; margin-bottom: 15px">Add new configuration directive \
<code>PARTITION_BY_REFERENCE</code> to defined how to export Oracle partition by \
reference. Possible values are <code>none</code>, <code>duplicate</code> or the \
number of hash partitions to create.</p> <p style="font-family: sans-serif; \
font-size: 14px; font-weight: normal; margin: 0; margin-bottom: 15px">Value \
<code>none</code> mean no translation and export of partition by reference like \
before. Value <code>duplicate</code> will duplicate the referenced column in the \
partitioned table and apply the same partitioning from the referenced table to the \
partitioned table. If the value is a number, the table will be partitioned with the \
HASH method using the value as the modulo. For example if you set it to 4 it will \
create 4 HASH partitions. Default valuer is <code>none</code> to not export the \
partitions by reference definition.</p> </li>
</ul>
<p style="font-family: sans-serif; font-size: 14px; font-weight: normal; margin: 0; \
margin-bottom: 15px">For a complete list of change see <a \
href="https://github.com/darold/ora2pg/blob/master/changelog" style="color: #3498db; \
text-decoration: underline">https://github.com/darold/ora2pg/blob/master/changelog</a></p>
<p style="font-family: sans-serif; font-size: 14px; font-weight: normal; margin: 0; \
margin-bottom: 15px">Thanks to all contributors, they are all cited in the changelog \
file. With special thanks to Martin Gerhardy for all the recent pull requests, this \
is much appreciated to not feel alone in the Ora2Pg code development.</p> <h2 \
style="color: #000; font-family: sans-serif; font-weight: 400; line-height: 1.4; \
margin: 0; margin-bottom: 30px">Links & Credits</h2> <p style="font-family: \
sans-serif; font-size: 14px; font-weight: normal; margin: 0; margin-bottom: 15px">I \
would like to thank all users who submitted patches and users who reported bugs and \
feature requests, they are all cited the ChangeLog file.</p>
<p style="font-family: sans-serif; font-size: 14px; font-weight: normal; margin: 0; \
margin-bottom: 15px">Ora2Pg is an open project. Any contribution to build a better \
tool is welcome. You just have to send your ideas, features requests or patches
using the GitHub tools or directly to ora2pg(at)darold(dot)net(dot)</p>
<p style="font-family: sans-serif; font-size: 14px; font-weight: normal; margin: 0; \
margin-bottom: 15px"><strong>Links:</strong></p> <ul style="font-family: sans-serif; \
font-size: 14px; font-weight: normal; margin: 0; margin-bottom: 15px"> <li \
style="list-style-position: inside; margin-left: 5px">Website: <a \
href="https://www.ora2pg.com/" style="color: #3498db; text-decoration: \
underline">https://www.ora2pg.com/</a></li> <li style="list-style-position: inside; \
margin-left: 5px">Download1: <a href="https://github.com/darold/ora2pg/releases" \
style="color: #3498db; text-decoration: \
underline">https://github.com/darold/ora2pg/releases</a></li> <li \
style="list-style-position: inside; margin-left: 5px">Download2: <a \
href="https://sourceforge.net/projects/ora2pg/" style="color: #3498db; \
text-decoration: underline">https://sourceforge.net/projects/ora2pg/</a></li> <li \
style="list-style-position: inside; margin-left: 5px">Development: <a \
href="https://github.com/darold/ora2pg" style="color: #3498db; text-decoration: \
underline">https://github.com/darold/ora2pg</a></li> <li style="list-style-position: \
inside; margin-left: 5px">Changelog: <a \
href="https://github.com/darold/ora2pg/blob/master/changelog" style="color: #3498db; \
text-decoration: underline">https://github.com/darold/ora2pg/blob/master/changelog</a></li>
<li style="list-style-position: inside; margin-left: 5px">Documentation: <a \
href="https://github.com/darold/ora2pg/blob/master/README" style="color: #3498db; \
text-decoration: underline">https://github.com/darold/ora2pg/blob/master/README</a></li>
</ul>
<h2 style="color: #000; font-family: sans-serif; font-weight: 400; line-height: 1.4; \
margin: 0; margin-bottom: 30px">About Ora2Pg</h2> <p style="font-family: sans-serif; \
font-size: 14px; font-weight: normal; margin: 0; margin-bottom: 15px">Ora2Pg is an \
easy and reliable tool to migrate from Oracle to PostgreSQL. It is developed since \
2001 and can export most of the Oracle objects into PostgreSQL compatible code.</p>
<p style="font-family: sans-serif; font-size: 14px; font-weight: normal; margin: 0; \
margin-bottom: 15px">Ora2Pg works on any platform and is available under the GPL v3 \
licence.</p> <p style="font-family: sans-serif; font-size: 14px; font-weight: normal; \
margin: 0; margin-bottom: 15px">Docs, Download & Support at <a \
href="http://www.ora2pg.com/" style="color: #3498db; text-decoration: \
underline">http://www.ora2pg.com/</a></p>
</td>
</tr>
</table>
</td>
</tr>
</table>
<div class="footer" style="clear: both; Margin-top: 10px; text-align: \
center; width: 100%;">
<table border="0" cellpadding="0" cellspacing="0" \
style="border-collapse: separate; mso-table-lspace: 0pt; mso-table-rspace: 0pt; \
width: 100%;"> <tr>
<td class="content-block" style="font-family: sans-serif; \
vertical-align: top; padding-bottom: 10px; padding-top: 10px; font-size: 12px; color: \
#999999; text-align: center;">
<span class="apple-link" style="color: #999999; font-size: 12px; \
text-align: center;"> This email was sent to you from HexaCluster. It was delivered \
on their behalf by the PostgreSQL project. Any questions about the content of the \
message should be sent to HexaCluster.
</span>
<br><br>
You were sent this email as a subscriber of the <em>pgsql-announce</em> mailinglist, \
for the content tag Related Open Source.
To unsubscribe from
further emails, or change which emails you want to receive, please click the personal \
unsubscribe link that you can find in the headers of this email, or visit
<a href="https://lists.postgresql.org/unsubscribe/" style="color: #3498db; \
text-decoration: underline">https://lists.postgresql.org/unsubscribe/</a>.
</td>
</tr>
</table>
</div>
</div>
</td>
<td style="font-family: sans-serif; font-size: 14px; vertical-align: \
top;"> </td> </tr>
</table>
</body>
</html>
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic