database not being copied to the iPhone device from resources

I have come up with a strange problem. I am using sqlite database in my app. The app works fine when running in the simulator but when I deploy the app on iPhone device, it doesn't read from the db. Also, when I try to insert something to a table, it say no such table, which means that my db is not actually copied to the device. I hav tried cleaning the project with Build->Clean all Targets, delete the Build folder and manually remove the app from the device. Then try building again. but no luck. Certainly, I have added the db to the Resources and I can locat开发者_StackOverflowe and actually read the contents. Please guide me whats wrong when deploying on the device.

---

First check that you are copying the db into the bundle in the copy resources build phase. When a resource is in the bundle you cannot modify it, you need to copy it to the application's document directory

NSString *documentsDirectory = [NSSearchPathForDirectoriesInDomains(NSDocumentDirectory, NSUserDomainMask, YES) objectAtIndex:0];

---

I actually never managed to get this right. That's why I've a build script setup that dumps any sqlite DB that i have into a .sql text file. On the first run of the app on the phone, i just generate the sqlite DB from these sql lines. Works much saver for me than working with the binary files from sqlite.