What are the different options to export a workspace let's say from Development into another workspace in TEST, UAT OR Production Synapse Analytics. Most of the options I have come across has been around copying code and pasting it in the intended environment. But, I want it to be automated so there's less moving parts and seamlessly move pipelines, linked services & datasets into different environments and less prone to run into errors.
I suppose that you could follow this doc Source control in Synapse Studio to establish the integration. And also you need to check your role assignments in access control for the workspace.