This article describes the process of developing the entire Data Tier in Visual Studio SQL Server Data tools (SSDT.)
Many Software Development Life Cycle (SDLC) processes use hand-coded SQL publish scripts when making changes to the data tier. This process is error prone, and is not able to be versioned as easily as C# code projects. SSDT is a technology that brings the data tier in-line with C# projects, and both can be developed, versioned and released in the same manner.
This article describes how to upload your Visual Studio developed SQL Server Report Services (SSRS) RDL file from your local machine to a SSRS server. This procedure was developed for Visual Studio 2015 and SQL Server 2014, but also works with versions as old as 2010/2012.
ClickOnce will auto-manage everything about desktop-app deployment, updating and execution.
You can start an app via Url, everything else is automatic.
Running an exe Url like this will:
•Verify OS, security, permissions requirements
•Auto-install .Net Framework and all 3rd party dependencies
•Auto-install the app
•Auto-update the app when newer versions exist on the server
•Auto-run the app