Migrate SQLITE DB to PostgreSQL

PowerShell Universal
1

Hello,

yesterday we tried to change our database from SQLite to PostgreSQL.
We did a import of the .db-File (200MB) via pgloader. (Encoding=UTF8)
Afterwards we changed ”Plugins” and the “ConncetionString” in application.json. After starting the Powershell Universal Server it opened the “/first-steps”-page in my browser.
It seems like it can connect to the postgreSQL but can’t read the tables. Our Application wasnt licensed, we didn’t have entries in Jobs etc.

Any advice? Is this a permission issue?

Thanks in Advance!

Product: PowerShell Universal
Version: 5.6.2
2

I was able to solve my problem.
I’ve used the DB Migration Tool from the PS Universal CLI.

  1. Stop the “Powershell Universal”-Service
  2. update applications.json from SQLite Connection String to a PostgreSQL Connection String.
    1. Important: the migration tool later on will copy the rows. It wont create the Scheme etc. so therefore database should not exist already
  3. Start the “Powershell Universal”-Service again.
  4. Database will be created now.
  5. Stop the “Powershell Universal”-Service again.
  6. Run the Powershell Universal CLI db migrate Command
  7. Start the “Powershell Universal”-Service again.

thread can be closed and marked as solved