-
My source database put the customer address information on a separate table. How can I map the source columns with Target columns?
In MS SQL you can use Views (it is called Queries in MS Access) to join data from multiple tables and you can select which fields are returned by the view. A view is a virtual table whose contents are defined by a query. In DBSync you select the "virtual table" as the source table when you map the columns.
-
With DBSync how can I delete the customer information in InFOREMAX while these data are shown as inactive in my source database?
You can also use Views (Queries) to select merely the data which are currently active. DBSync will automatically delete the customer information in InFOREMAX when these data no longer exist in the source table.