Can I Replicate Views Using DSS?

Question

Can I replicate views using DSS?

Environment

DSS 6

Answer

Yes, you can replicate views using Refresh. When selecting tables to replicate, you can see and include views by selecting the Show Views checkbox. However, we log changes in your database's logs for tables, not views. As a result, change data capture (CDC) is not supported for views. In addition, when replicating views, we create corresponding tables in your target rather than replicating views.

Alternatively, consider replicating the tables on which you built the view and manually creating the view in the target. If you choose this approach, you may need to adjust for syntax differences between the source and target and maintain the view logic in each environment separately.