We are preparing a migration from PDI 7.0 to 8.0. Our repository is in the database (MSSQL).
Should I deploy a new data model for PDI 8.0 and if yes where do I get the SQL migration script?
You can generate the repository schema via the PDI desktop app after you setup the new db connection. There's an option that says something like 'Create repository for connection'. This will execute the SQL to create the necessary tables. You can then export your PDI 7 repo and import into your PDI 8 repo.
This has worked successfully many times for me.
I set up the db connection but I find nowhere the option "create repository for connection"...
I am working with pentaho 8.1. In former editions, you're right, the option existed...
When I set up a new repository with an existing and functionning db connection I have only two options : connect (but the repository tables do not exist) or manage the existing repositories (which is basically the first step of the operation).
Thank you for your help.
Retrieving data ...