SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Azure DW - Development Tools


Azure DW - Development Tools

Author
Message
NicHopper
NicHopper
SSCrazy Eights
SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)

Group: General Forum Members
Points: 8251 Visits: 2223
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

------------------------------------------------------------Check out my bloghttp://www.sqlservercentral.com/articles/Best+Practices/61537/
xsevensinzx
xsevensinzx
SSC-Insane
SSC-Insane (22K reputation)SSC-Insane (22K reputation)SSC-Insane (22K reputation)SSC-Insane (22K reputation)SSC-Insane (22K reputation)SSC-Insane (22K reputation)SSC-Insane (22K reputation)SSC-Insane (22K reputation)

Group: General Forum Members
Points: 22330 Visits: 5978
NicHopper - Thursday, September 14, 2017 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

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.

Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum









































































































































































SQLServerCentral


Search