[Tips & Tricks] Script to import songs from one EW 6 database into another

Hi community,

I have created a script that can import all songs from one EW 6 database into another. It can be found on https://github.com/johnsivertsen/easyworship-utils

I am not affiliated with Easyworship and no Easyworship employee has verified the validity of the script. But I have of course use it in my own church with success.

Use at own risk and take backup before running the script

Hi John,
Your script looks like it should do just what I need. Unfortunately, it doesn't appear compatible with the version of SQLite that is currently available (3.14.1) as it flags a 'no such collation sequence UTF8_U_CI' on several lines in merge.sql.
The custom collation sequence was built into the original database and the later versions of SQLite3 are not set to ignore non-standard collation sequences. As I'm not an expert on these things, I can't resolve it, nor can I find an old version of the SQLite tools to run your script. Are you able to help, here?
Thanks,
Ian
EW had a script available a while back, works great, it can take a few minutes though because it copies your entire profile.
I have a copy of it here https://drive.google.com/file/d/0B7zcfY ... sp=sharing
The readme.txt file have the instructions in it.
EW had a script available a while back, works great, it can take a few minutes though because it copies your entire profile.
I have a copy of it here https://drive.google.com/file/d/0B7zcfY ... sp=sharing
The readme.txt file have the instructions in it.


Thanks mrvoltz, but your reply addresses the task of backing-up and restoring the folders containing the user profile using a DOS batch file. This thread is dealing with concatenating one song database with another and involves manipulating the SQLite databases containing the songs, i.e. songs.db, songKeys.db, songWords.db and songHistory.db. This is done using SQL statements in a script to manipulate the databases to add the songs from one profile to the songs in another profile.
Sorry, I re read the original post, I did not realize you were merging two databases.
I thought the goal was just to move the db from one computer to the other, which is what those batch files do.