[libreoffice-l10n] HSQLDB migration how-to

classic Classic list List threaded Threaded
4 messages Options
sophie sophie
Reply | Threaded
Open this post in threaded view
|

[libreoffice-l10n] HSQLDB migration how-to

Hi all,

With 6.3 release, when you open a database, the UI would show the user a
link, on the dialog box which starts the process, to a wiki page with
detailed information on what was possible with Migration Assistant(MA)
from HSQLDB to another engine and on how to perform a migration with or
without use of the MA too.

The link in the dialog box will point to this wiki page here:

https://wiki.documentfoundation.org/Documentation/HowTo/MigrateFromHSQLDB

It is empty for the moment but documentation team is working on it (a
preview of the structure is on Drew page here
https://wiki.documentfoundation.org/User:Drew/tmpMA

The page will be marked for translation with the wiki translation
extension.

Cheers,
Sophie

--
Sophie Gautier [hidden email]
GSM: +33683901545
IRC: sophi
Release coordinator
The Document Foundation

--
To unsubscribe e-mail to: [hidden email]
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/l10n/
Privacy Policy: https://www.documentfoundation.org/privacy
Martin Srebotnjak Martin Srebotnjak
Reply | Threaded
Open this post in threaded view
|

Re: [libreoffice-l10n] HSQLDB migration how-to

Hi,

Sophie, great to hear this.

Just a suggestion - would it not be better to move that wiki page, once it
is finished in English and maybe localized in a few languages, to LO help
(by the time of string freeze, LO63RC1)?

Some (corporate/government/military etc.) users do not have internet access
due to security reasons, also wiki is simpler to hack, servers can be down
etc.

If local help is not present, the system can still redirect to wiki help,
that mechanism is already in place.

Lp, m.

V V čet., 13. jun. 2019 ob 11:36 je oseba sophi <[hidden email]>
napisala:

> Hi all,
>
> With 6.3 release, when you open a database, the UI would show the user a
> link, on the dialog box which starts the process, to a wiki page with
> detailed information on what was possible with Migration Assistant(MA)
> from HSQLDB to another engine and on how to perform a migration with or
> without use of the MA too.
>
> The link in the dialog box will point to this wiki page here:
>
> https://wiki.documentfoundation.org/Documentation/HowTo/MigrateFromHSQLDB
>
> It is empty for the moment but documentation team is working on it (a
> preview of the structure is on Drew page here
> https://wiki.documentfoundation.org/User:Drew/tmpMA
>
> The page will be marked for translation with the wiki translation
> extension.
>
> Cheers,
> Sophie
>
> --
> Sophie Gautier [hidden email]
> GSM: +33683901545
> IRC: sophi
> Release coordinator
> The Document Foundation
>
> --
> To unsubscribe e-mail to: [hidden email]
> Problems?
> https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
> List archive: https://listarchives.libreoffice.org/global/l10n/
> Privacy Policy: https://www.documentfoundation.org/privacy
>

--
To unsubscribe e-mail to: [hidden email]
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/l10n/
Privacy Policy: https://www.documentfoundation.org/privacy
sophie sophie
Reply | Threaded
Open this post in threaded view
|

Re: [libreoffice-l10n] HSQLDB migration how-to

Hi Martin,
Le 13/06/2019 à 11:50, Martin Srebotnjak a écrit :

> Hi,
>
> Sophie, great to hear this.
>
> Just a suggestion - would it not be better to move that wiki page, once it
> is finished in English and maybe localized in a few languages, to LO help
> (by the time of string freeze, LO63RC1)?
>
> Some (corporate/government/military etc.) users do not have internet access
> due to security reasons, also wiki is simpler to hack, servers can be down
> etc.
>
> If local help is not present, the system can still redirect to wiki help,
> that mechanism is already in place.

From what I understood during the ESC call last week (see the minutes at
the end of this mail), it is transitional until the assistant does its
job. For the moment, some cases are not took into account during the
migration and can mess the database, this is what will be explained in
the how-to, what you should do if your database is out of what the
migration tool can process.
The wiki page will adapt to the progress of the migration assistant
until it's able to migrate all or most types of databases. Drew will
blog also about the progress.
So, I think it's better to have it in the wiki for the moment and have
the help page for 6.4 when and if the migration assistant issues are solved.

Minutes of the ESC on the topic:
----------------------------------
 + HSQLDB vs. Firebird ? (Caolan)
            + last release punted out decision on removing HSQLDB
            + should we do that / who makes that decision ?
            + would like to see it go but – do we think it will work ?
            + not a good idea to remove HSQLDB in 6.3 (Drew)
               + migration assistant is not capable of moving the
                 majority of files it can run across.
               + E-mail on dev. list about this.
               + recommend leave firebird active as in 6.2
               + recommend expose migration assistant as it is today
                  + but reasonable set of data-types doesn’t work for
               + needs to be fixed & improving SDBC driver to have parity
                 with HSQL – spend time to 6.4 to focus activities to
                 encourage migration.
               + prefer to drop this for 6.4 ...
            + what is the state ? (Caolan)
               + firebird is the default in 6.2 (Drew)
                   + in 6.3 we get the migration assistant out of the box.
               + suggest on the dialog box saying “want to migrate ?” (Drew)
                   + link to a wiki page with a tutorial to help there.
               + tie it into some blog posts – to get some urgency here
(Drew)
AI:                + add link to the dialog (Caolan)
            + do we have a migration tracking bug ? (Caolan)
               + https://bugs.documentfoundation.org/show_bug.cgi?id=116968
--------------------------------------

Cheers
Sophie

--
Sophie Gautier [hidden email]
GSM: +33683901545
IRC: sophi
Release coordinator
The Document Foundation

--
To unsubscribe e-mail to: [hidden email]
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/l10n/
Privacy Policy: https://www.documentfoundation.org/privacy
Dennis Roczek Dennis Roczek
Reply | Threaded
Open this post in threaded view
|

Re: [libreoffice-l10n] HSQLDB migration how-to

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA256


Hi *,

On 13.06.2019 12:27, sophi wrote:

> From what I understood during the ESC call last week (see the minutes at
> the end of this mail), it is transitional until the assistant does its
> job. For the moment, some cases are not took into account during the
> migration and can mess the database, this is what will be explained in
> the how-to, what you should do if your database is out of what the
> migration tool can process.
> The wiki page will adapt to the progress of the migration assistant
> until it's able to migrate all or most types of databases. Drew will
> blog also about the progress.
> So, I think it's better to have it in the wiki for the moment and have
> the help page for 6.4 when and if the migration assistant issues are solved.
Uhm, just for the case 6.4 will still have HSQLDB integrated (because of
existing problems): shouldn't we link to a wiki page with version
numbers so we can track the changes based on different versions?

Best regards,

Dennis
-----BEGIN PGP SIGNATURE-----
Comment: Using GnuPG with Thunderbird - https://www.enigmail.net/

iQIzBAEBCAAdFiEEhYmMfFabYko4V91Tzj5B/c4qttkFAl0CWhQACgkQzj5B/c4q
ttls6A//aP+ZVgz6hbp6iMMGg6qh40yc+I2fCutQI2apNd+g5g0E0Xa/nLunM8dk
VwT3yIfhSYyNpEgcWQdxFbpYEhr58wKOU7ddhLyHD65u+3TbzkPuFmVUACt9gOVE
Dev3+0OxDd3uKMMYPScovi6lBKXeuNXn2D+se0wPpq6OlmGfRN3iYsJ0KwvFIJw5
MmJdYJVeJ+CxqkHO2D+zQTQ24s0cmBoeiZ8CbikX8MkYE5GN0R08jSqDKAcuFNSU
k4kT5U+awZp1woMMz7wHUw/oIwgKOnaUinnDwgLL4Yvq7D0QMD26fk2Xmsn4WQ2o
i+xRu11Ch6Hi89YHuoD39mUufoOcpjV8rxBehpL5c0MMjYhu5EbA8sjbDSxSp0dV
ZD7Y+w0nPIcF8/jWpgnUcRgfmLQidrOUpY5g8VSj4iINfabak+8wGVYfMvNq05t5
W17VIKCTUPQvbeiP6tcmUk939j4ba0tHlMxq83uXgaIrNR6ys8kst/Sx4lIB4r+O
3g+DdpX/FnIi1NdDw1q+eGK6FkJFWkwE0tb9MQfUMWvrf69iQBll6zmq1Ab8ynKh
RlKEHHIzFs+FshAFoLiqv3iasroH+4M6c+uTvxLmhOkzdWP5ig9fv5CwHZ8LOBQT
R+D/hIorbX/2owRmi8wwjJxKu5MZK8yO+M6nzJe5VYFM5NYV/1k=
=KQsJ
-----END PGP SIGNATURE-----

--
To unsubscribe e-mail to: [hidden email]
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/l10n/
Privacy Policy: https://www.documentfoundation.org/privacy