Forum Discussion
Advocate IVHow to easy script all objects in warehouse or Lakehouse sql endpoint?
Version Control is "coming soon", but it is not yet available. My commercial comparing tool has the. support on the roadmap. But how to work this will be implemented?
Visual Studio SchemaCompare doesn't work, because when connecting to an Azure content I can't switch the account to be used.
I use SSMS to connect with lakehouse sql endpoints or warehouse. Normal databases have options to create a script of all objects, but these items are not available for fabric content.
What would be an easy way to script database objects from time to time to get the structure under source control?
3 Replies
Hi, germo Thanks for posting your question in Microsoft Fabric community I have been trying the "Synapse VS Code" extension for a few days now, still in pre-release, but it can connect to Fabric workspaces and I think it might work in your case
Regards
Geetha
germoI tested this VSC Extension one or two weeks ago. It can connect to the workspace, notebooks are available. But this extension didn't yet work for me. The automatic merging is unusable for me, especially in case of merge conflicts. The extensions just takes the local version and don't allow me to select the server version. I think, this could be implemented later, and I created issues.
Let me say, I believe, in the future there will be all, what we need. But for now the missing source control integration is my main issue. I hope that this becomes a high priority. For now, playing a bit with fabric is fine. But for real development it is too early (for me).
