Unless I’m being stupid, I don’t think (?) there is any way to migrate/export a local mAirListDB to a networked mAirListDB.
I know that at Leith FM, this is something that will be needed fairly soon, as we’re using mAirList on a single PC for overnight automation just now, but at some point we will want to use a networked mAirListDB, but retaining the content (to begin with) of our current local mAirListDB.
I’m sure that other stations will also have a need at some point for a migration utility if they start off with a local mAirListDB.
If I’m wrong, and there is already a way to do this, can someone please explain the steps required?
I’m not going to write a migration tool. First, because the conversion requires some manual work that can’t be automated so easily. Second, because the manual clearly states that you cannot convert between the database types, and it is very rare that someone ignores the warning, starts off with a local database and wishes to covert it later
It is possible to migrate the data, but I’m only offering that as a (paid) service.
Basically, the process involves creating a blank database of the other type, creating an SQL dump of the old database, add all data through the SELECT statements from the dump (taking care of the correct data types and column order), and finally adjust all sequences for the index columns.
The task is not too difficult, that’s true. But making a reliable migration tool suitable for end users would be very time consuming. I think I could make 10 or 20 manual conversions in the same time.
