Overview
In this lesson we will explain how to associate existent Tables in our databases and the relation with the different instances depending on the environment that Wayfast users are going to develop the application. Also we will describe how to create a new table in SQL and synchronize it into Wayfast.
How to associate an existent Table from Wayfast?
On Wayfast, make sure that the Project is created and at least, a requirement is in “Active” status.
Click on “Database” icon at the top menu.
...
On Submenu, selects click on “Tables” subtab
...
Wayfast automatically shows the different Transactional, Master data and Business data tables in grid view dashboard.
...
Select any object and click on “Assign” button.
...
Now we have the “Table” object associated to the Project and we can continue defining the Requirements.
How to create a new Table in SQL and synchronize it on Wayfast?
Turn to SQL Server Management Studio and connect to the DB associated to the Project. In a new query, create a new table with the following data settings:
| Code Block | ||
|---|---|---|
| ||
CREATE TABLE HelloHWD_World_TableTransactions( Field1 Nvarchar(50) COLLATE DATABASE_DEFAULT NULL, Field2 Nvarchar(50) COLLATE DATABASE_DEFAULT NULL, Field3 Nvarchar(50) COLLATE DATABASE_DEFAULT NULL, Field4 Nvarchar(50) COLLATE DATABASE_DEFAULT NULL, Field5 Nvarchar(50) COLLATE DATABASE_DEFAULT NULL, Status int NULL) |
...
Return to Database-Table submenu
...
Automatically the new row is added on the Transactional Tables grid view with the corresponding “Instance” and “Database” values that we create on SQL.
Recap
In this lesson, we learnt how to associate existent tables in our Project’s database. And we observed how the new tables created from the SQL Server Management Studio are synchronized in simple steps into Wayfast.