September 14, 2017 at 4:01 am
Hi,
My company are running a proof of concept at the moment with an Azure DW. We have a list of objectives, one of which is to assess the development tools available.
Our databases at present (and our future new DW) would be Visual Studio projects under source control and then deployed automatically so I had hoped Visual Studio 2017 would support Azure DW, sadly I'm starting to think whilst they support Azure V12 they don't support an Azure DW, meaning we would have to go back to old school scripts for the DW.
So my question is simple, to all the people using Azure DW, how do you do your development work?
Thanks,
Nic
September 26, 2017 at 10:04 pm
NicHopper - Thursday, September 14, 2017 4:01 AMHi,
My company are running a proof of concept at the moment with an Azure DW. We have a list of objectives, one of which is to assess the development tools available.
Our databases at present (and our future new DW) would be Visual Studio projects under source control and then deployed automatically so I had hoped Visual Studio 2017 would support Azure DW, sadly I'm starting to think whilst they support Azure V12 they don't support an Azure DW, meaning we would have to go back to old school scripts for the DW.So my question is simple, to all the people using Azure DW, how do you do your development work?
Thanks,
Nic
Sorry I missed this question. Would have answered sooner.
I just moved to Azure DW myself and I have never really depended on visual studio in the past for SQL Server. Thus, maybe this is not a great question for me.
However, exporting SQL for views, stored procedures and so forth is the approach I took both with SQL Server and now with Azure DW. All of these pieces of code are already backed up with Azure, but exporting to commit to source control with GIT is not difficult at all. The same goes for Team Foundation. The thing is, this is outside of Visual Studio and integrated with other IDE's that are more suitable until more support comes about for Azure.
For example, I use a lot of Python with Azure DW. Instead of Python in visual studio, I am using PyCharm that has ODBC connections and GIT integration. Being Azure DW is cloud based, spinning up a development environment is extremely easy.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply