Migrating DB from SQLLite to SQL

[EddyCwdry]

This isn't an issue per se, but i'm trying to get some guidance/advice on the best course of action to migrate an existing piranha site backed by SQLLite to a regular SQL instance, it seems there are some differences in the db schema of the two and i'm not certain if porting is something that's even intended to be possible in piranha

Is it feasible to just use an off the shelf porting tool or are there underlying differences between the two setups that will cause problems? And would it be of value to others if I document out whatever process I end up with? I have around 4 instances that i've been asked to port, so I want to streamline this as much as possible for my own sake and also anyone else in future with this.