Cloning a SQLite (or any SQL) database

Mike Bonner bonnmike at gmail.com
Sun May 22 17:19:20 CEST 2016


If you just need to duplicate the database, would making a copy of the file
be sufficient?

On Sun, May 22, 2016 at 9:15 AM, Paul Dupuis <paul at researchware.com> wrote:

> Does any one have a good script they might care to share for cloning a
> SQLite database?
>
> the basic model is to use revDatabaseTableNames(databaseID) to get the
> list of tables in the source database and then loop through getting each
> tables schema and data and recreate that in the target database.
>
> Achievable, but before I write one, I thought I would save myself the
> effort and see if anyone had one there were willing to share?
>
> _______________________________________________
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
>


More information about the use-livecode mailing list