Let PowerDesigner support sqlite!

PowerDesigner is a powerful database design software that is currently using it to design a database of new systems, but it would be convenient to use the lightweight SQLite for testing in the early stages of the project, but found that PowerDesigner did not seem to support it directly. SQLite DBMS, so that the data table created can not be generated directly in SQLite, it is not very cool



But there is always a solution, in fact, only need to install SQLite driver, you can let PowerDesigner support directly generated to SQLite, SQLite driver Download:

http://www.ch-werner.de/sqliteodbc/

But a friend said that even if the installation of the above driver is not possible, because in the creation of the physical data model also does not have the SQLite option, in fact, SQLite is an ODBC connection, here, we should think of it, ah, yes, when selecting the DBMS as long as the choice of ODBC 3.0 driver can be, this is can generate the corresponding data model of SQLite, the following are the methods of operation:

1. Create a new physical data model and select ODBC 3.0:



2, after creating the data structure, start to generate the database, click the menu of Generate database:



3, build the database and then select SQLite3.0 Driver, and then point to confirm it:



Finally, we recommend a very useful SQLite visual management tool, can be downloaded to the following address:

http://sqliteadmin.orbmu2k.de/

Let PowerDesigner support sqlite!