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.
Retrieving data ...