• Registered: 2017-12-10
  • Posts: 81

Topic: Import DB

Is it possible to import/load a sqlite.db in a new MVD-project while the sqlite.db is made by an external programm, such as sqlstudio or sqlite maestro etc.

kees.krause's Website

  • Registered: 2014-02-14
  • Posts: 10,294

Re: Import DB

Yes.
Just create s new project with the same database structure which you have in the exists database.


But there is two rules for database structure.
1. Every table must have field called "id" is primary key
2. Every foreign key must have name like: "id_tablename"


After that you can replace sqlite.db with your exists database file.

Dmitry.