Move 2 datawarehouses (created before synapse studio was created) into synapse workspace environment

Question

Have 2 data ware houses which was created before synapse studio and need to migrate them into synapse workspace environment.

Please advise !!!

Answer 1

Hi @Nichenametla, Rajesh ,

Welcome to Microsoft Q&A forum and thanks for posting your query.

To move your datawarehouse, you now have below migration options for your existing database:

1. Enable Azure Synapse workspace features: Go to the overview page for your existing database and choose “New synapse workspace” in the top menu bar and get all the new features except unified management and monitoring. All management operations will continue via SQL resource provider. Except for SQL requests submitted via the Synapse Studio, all SQL monitoring capabilities remain on the database (dedicated SQL pool). So basically you should just continue to use your current processes for monitoring your SQL resources on the server. For more details on the steps to enable the workspace features see Enabling Synapse workspace features for an existing dedicated SQL pool (formerly SQL DW)

Reference document : Enabling Synapse workspace features on an existing dedicated SQL pool (formerly SQL DW)

The following table summarizes by region where the ability to enable the Synapse workspace features on an existing dedicated SQL pool (formerly SQL DW) is not supported. Check back to see when your region becomes available.

Reference document: Enabling Synapse workspace features on a dedicated SQL pool (formerly SQL DW) in your region

2. Migrate to Azure Synapse workspace: Create a user-defined restore point through the Azure portal, create a new synapse workspace or use an existing one, and then restore the database and get all the new features. All monitoring and management is done via the Synapse workspace and the Synapse Studio experience

Here is the reference blog on the same from @James Serra : Azure Synapse Analytics is GA!

Hope this info helps. Do let us know if you have further query.

----------

• Please accept an answer and up-vote if it helps. Original posters help the community find answers faster by identifying the correct answer. Here is how.
• Want a reminder to come back and check responses? Here is how to subscribe to a notification.