...
The steps below describe how to create this view using Microsoft SQL Server Management Studio in a local database other than APTIFY. The screen captures included with these steps illustrate how to create a view of data from a LibraryInventory table that exists in a database named Vault on another SQL server on the network. This other SQL server (named, EXTERNAL_DATA) has a Linked Server relationship with the local SQL server.
| Note |
|---|
Best Practice Tip: If you want to create the view of the external data directly in the APTIFY database, Aptify strongly recommends that you add the view to the database using a Database Objects record rather than creating the view using Microsoft SQL Server Management Studio. See Database Objects Service for information on using the Database Objects service. |
...
- The second example creates a view of Aptify's ProductPrices sub-type entity in another database on the local server.
...