(Powerdesigner&sqlite) When you have finished designing the table in PD, import it into the database

I have connected SQL Server with SQLite

Ⅰ, SQL Server, Baidu, turn: http://jingyan.baidu.com/article/7f766daf465e9c4101e1d0d5.html only copied the text, Picture trouble, just in case the link fails

1. When the table structure is established, select "Database" in the navigation bar and select "Configure Connections" as shown:

2. Add a data source, click on the red location, then select "File Data source (machine Independent)" and select "Next", locate SQL Server in the list and select "Next"

3, enter a name in the text box, here I enter "Test", continue to "next", and then click "Done"

4, Next is to establish a SQL Server can be connected to the ODBC data source, such as: Description can be filled in, the server we fill in "IP", and then select "Next" Choose to use "User input and Password Authentication" and then fill in the database "user name" and "password" continue to "next"

5, here we choose the default import into the "master" database, of course you can choose another database, and then always "next" will appear a "test data source" interface, and then we test the data source is configured correctly, here we test successfully. And then always make sure it's OK.

6. Next, we will import all the table structures into the database. or select "Database" on the navigation bar, then select "CREATE TABLE" and then click on the Red button to select the data source you just created, then the default all action is OK

Ⅱ, import to SQLite

Upfront: When designing models in PD, choose ODBC3.0 and download the SQLite driver.

First, use the SQLite management tool to create an empty. db file, which is the database (for container use, the table in PD is put into this file)

Then set up the data source, control Panel (here's a shortcut, Win8 down win+x)--admin Tool-->obdc32--> Add--Select driver (SQLite3 ODBC Driver generally last)--click Done , enter your own data source name, select the database (the newly created database. db), time is not filled, OK.

Then open PD, menu database-->connect, set

When the connection is complete, click Generate Database

Ok,run, ignore all, so your container. DB is already full of tables and generates a. sql file that can be opened and used by SQL Server.

You can then view the. db directly into your SQLite management tool, I use SQLite Database Browser 2.0 B1

(Powerdesigner&sqlite) When you have finished designing the table in PD, import it into the database