You cannot select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
|
|
|
|
SQLite3 Database Merge Script
|
|
|
|
|
================================
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Usage
|
|
|
|
|
=====
|
|
|
|
|
|
|
|
|
|
* Merges SQL databases that are identical in their tables and their tables' schemas.
|
|
|
|
|
* Databases with mismatched tables will likely NOT merge.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Execution
|
|
|
|
|
=========
|
|
|
|
|
|
|
|
|
|
* Open the Python script in a text editor.
|
|
|
|
|
* Navigate to the section of code labeled, "Input Parameters".
|
|
|
|
|
* Change the value of, "mainDB" to the path of your primary database.
|
|
|
|
|
* Add the name of the other databases to Python list variable, "otherDBs".
|
|
|
|
|
* Open a Python terminal and execute the script.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Requirements
|
|
|
|
|
============
|
|
|
|
|
|
|
|
|
|
* Python 3.5.1 or later
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Authors
|
|
|
|
|
=======
|
|
|
|
|
|
|
|
|
|
* gopherchucks
|
