Database Migration From LiteDBv5 to SqlLite

[Omzig]

Summary of the new feature / enhancement

As a v4 user, I want to use v5 that uses SQLite instead of LiteDBv5 and I need to migrate the database so that I do not lose all my identities, git settings, secrets, etc.

Proposed technical implementation details (optional)

Mike says it the best below.

[MikeShepard]

Kind of a late ask, but probably better than a bunch of critical support calls post-migration.

Maybe some instructions like:

1. Copy your db file (and make a backup)
2. Run this utility
3. Copy the transformed db file
4. Do the upgrade

[adamdriscoll]

Looking into this already! It will be a command line tool.

[MikeShepard]

Perfect! Thanks!

On Tue, Jul 16, 2024 at 3:00 PM Adam Driscoll @.***> wrote:

Looking into this already! It will be a command line tool.

— Reply to this email directly, view it on GitHub https://github.com/ironmansoftware/powershell-universal/issues/3461#issuecomment-2231728764, or unsubscribe https://github.com/notifications/unsubscribe-auth/ABKI2ISXA4GN3QL33NELR4DZMV3UTAVCNFSM6AAAAABK7FY6NKVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDEMZRG4ZDQNZWGQ . You are receiving this because you commented.Message ID: @.***>

-- https://powershellstation.com

[adamdriscoll]

psudb.exe will be included with the installation media. It will be able to convert a LiteDB file to a SQLite file. We should be able to convert a SQLite to SQL or PostgreSQL as well but we'll implement that at another time.

[MikeShepard]

@adamdriscoll - I don't see it in the 5.0 rc1 zip file. Should it be there?

[adamdriscoll]

@adamdriscoll - This was finished after RC1. We have some tests failing on the v5 nightly that need to be fixed. I just realized now it hasn't published a kit for 2 days.