Synchronizing the Database
Click on Tools -> Sync DB menu from Author Main
Window. If the database already
exists then it get loaded automatically.
Prescient Author takes various
informtion like server name, database name etc. entered in the project
properties to make connection to the backend database.
Following are steps for database synchronization
- You should select the ODBC driver first.
- You can create and run script for new database by clicking on New
Database button.
- If you want to create and run alter script then you can click on Alter
Script button.(Refer to Generate Alter Script)
- If you want to create alter script but do not want to run the alter
script then click on Selected Table or Selected
Module or Project button.
- You can select the module form Module combo box for
generating alter script for selected module.
- If your database has some fields which are not present in
the ATH file then you can copy the field from database to the ATH file by
clicking on Copy Fields button.
- If the database is already exists then you can attach it by clicking on
Load Database button. But you should specify the name of the
existing database in Project Property dialog.
Following are steps for Oracle database
synchronization
- Find the script file from ".\Tutorial2\Tutorial2\scripts" which is
generated after selecting "Write All" menu.
- Run the script manually on oracle client.
- Then use the database.
Example of
Synchronizating database
Following example show Loading the database.
