Migrating 300GB+ data not using UI export functionality
Hi,
does anyone know what the most efficient way would be to migrate data from old version of ThingWorx to the latest release.
We are using PostgreSQL as persistence provider. This runs in cluster and HA mode.
DB is a different machine than Tomcat with ThingWorx.
We tried to do In-Place upgrade a had some problems with it. Suggestion was to do a migration:
New DB, installation scripts etc.
export extensions and entities from old platform
We have tried data export via Composer (Export to ThingWorx Storage) but that failed + we dont have lot of space on our application server.
I would like to use pgAdmin or psql to copy content from ValueStream, Stream and Datatable tables (perhaps wiki and blog as well).
Can anyone suggest some concrete SQLs to do that?
Thanks a lot.
Tomas

