Copy sqlite db from resource folder to Application.persistentDataPath (iOS/Android)

Unity Engine
1

I’ve lost a few days on this and can’t seem to find the pattern I need across other posts…

Keeping it simple: inside of editor folder “Assets/Resources/mySqlite_db”

When I stay within the editor, something basic like this works fine:

string assetPath = "Assets/Resources/" + mySqlite_db;
string dataPath = Application.persistentDataPath + "/" + mySqlite_db;
File.Copy(assetPath, dataPath);

When I run my app on iOS/Xcode, the database fails to copy to the persistent path on the iOS device.

I’m hoping someone can explain the correct way to load and then copy my Db from the Resources Folder over to the Device’s persistent folder.

If Resources folder is not the correct place to start, I’m flexible. Just stuck at the moment so thank you for your time in advance.

2

Even though assets in Resources/ ARE included in the build, you can’t access them like the above.

I put my SQL database into StreamingAssets, where you CAN copy it like above.

With that I copied it out to persistent storage only for Android.

Here’s more: