Session 5: Building a Database Project

From RapidSQL
Jump to: navigation, search

Go Up to Rapid SQL Tutorial exercises

Rapid SQL provides an excellent team development environment by allowing you to reverse engineer live database objects into off-line SQL source code files. You can subsequently perform tasks such as distribute the files or add them to a Version Control System (VCS). This example will reverse engineer the table objects from the Microsoft SQL Server AdventureWorks database into a Rapid SQL project

  1. Select File > New > Project to open the wizard.
  2. Enter sample_project as the name, and accept the default target directory. Select From Database and click OK.
  3. On the Connection page, select SAMPLE_DATASOURCE and click Next.
  4. On the Catalogs page, select AdventureWorks and click Next.
  5. Click Schemas to open the Schema Selection dialog. Select Human Resources, Purchasing, and Sales, and then click OK. The Object Selection page opens.
  6. Under Object Types, select Tables. Then, under Objects, expand the Tables node and select the Purchasing.Vendor, Sales.SpecialOffer, and HumanResources.Employee tables. Click Next.
  7. On the Options page, leave the default selections and click Finish.
  8. When the Execute page shows that reverse engineering is complete, click Continue.

The Project tab displays the results of the reverse engineering.

af0f5d07.jpg

Before closing the Project tab, investigate the individual project elements. Also, check the File and Project menus for project and version control options.

Proceed to Session 6: Visual Query Builder.